get the unique count from the list of numbers

[harshal_chakran]

Hi,
I want to get the unique count of the numbers available in the log.

for e,g,

I have used the list query to get the list of numbers at the output from my log:

Number

12

13

24

12

24

44

I wanted the one more column to get count of how many times the specific no. appears in the log .

i.e.

Number-----Times

12-----2

13-----1

24-----2

44-----1

Please Help.

[emaccaferri]

Hi,
Something like

stats count(Numbers) as Times by Numbers 

gets you what you were looking for?