Forum Discussion
StefanKi
May 29, 2018Iron Contributor
count unique value in a column
Hallo,
I need do count unique value in the column name. How I can do his?
Input:
Name | Time |
Honda | 2015-01-01T00:00:01.0000000Z |
Honda | 2015-01-01T00:00:02.0000000Z |
Toyota | 2015-01-01T00:00:01.0000000Z |
Toyota | 2015-01-01T00:00:02.0000000Z |
Toyota | 2015-01-01T00:00:03.0000000Z |
Output:
Name | Count |
Toyota | 3 |
Honda | 2 |
Hi,
You can do run the following query:
TableName | summarize count() by Name
Thanks,
-Evgeny
- Evgeny Ternovsky
Microsoft
Hi,
You can do run the following query:
TableName | summarize count() by Name
Thanks,
-Evgeny
- StefanKiIron Contributor
Thanks this helps