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.
Hi,
Something like
stats count(Numbers) as Times by Numbers
gets you what you were looking for?