Forum Discussion

StefanKi's avatar
StefanKi
Iron Contributor
May 29, 2018

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

  • Hi,

     

    You can do run the following query:

    TableName
    | summarize count() by Name

    Thanks,

    -Evgeny

Resources