SOLVED

count unique value in a column

Iron Contributor

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 Replies
best response confirmed by Stefan Kießig (Iron Contributor)
Solution

Hi,

 

You can do run the following query:

TableName
| summarize count() by Name

Thanks,

-Evgeny

Thanks this helps

1 best response

Accepted Solutions
best response confirmed by Stefan Kießig (Iron Contributor)
Solution

Hi,

 

You can do run the following query:

TableName
| summarize count() by Name

Thanks,

-Evgeny

View solution in original post