count distinct

[ntudev]

Can someone write a code that will count distinct values? example below.

Value  Count

12        1

33        1

22        1

21        1

55        1

[Felipe_Ribeir0 · Accepted solution]

Hi @ntudev 

To count how many times the value shows, use the summarize tool configured like this:

[gautiergodard]

hey @ntudev 

You can use a summarize tool and group on Value column.

Then you can either count or count distinct .