I m trying to create a table were I want to display the 3 biggest values (count) from a field and the existing remain as "others". For example:
Field1 count
A 27
B 20
C 8
others 239
How do I achieve to create "others" ?
*Others=D, E,F, ... (total count of occurrences)
Thanks
I think I got it by applying |timechart span=5m limit=9 usenull=f useother=true count by ALPHABET
|fields + "A" "F" "G" "OTHER"
@diabinho If your problem is resolved, please accept an answer to help future readers.
try this:
.. |top limit=3 Field1 useother=1 showperc=f
Thank you for the help but I posted my question wrongly, never the less your answer helped me with something else 🙂
What I really want is something like this:
Being A, F and G always there despite the number of counts, and OTHER are just the remaining ones. I know if I use limit=limit_number
I get automatically OTHER but I cant see how to "stick" A, F and G there.
Any thoughts?
Thanks
Hello mayurr98,
It helped but it isn't what I was looking for but that's my bad, I didn't explain properly, never the less it helped me with something else.
Thanks