count unique value in a column

[Stefan Kießig]

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

[#2 · Accepted solution]

Hi,

You can do run the following query:

TableName
| summarize count() by Name

Thanks,

-Evgeny

[#3]

Thanks this helps