topic Re: How to create a field value from a group of values in the same field? in Splunk Search

How to create a field value from a group of values in the same field?

diabinho — Thu, 07 Nov 2019 14:03:04 GMT

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

Re: How to create a field value from a group of values in the same field?

mayurr98 — Thu, 07 Nov 2019 18:30:51 GMT

try this:

.. |top limit=3 Field1 useother=1 showperc=f

Re: How to create a field value from a group of values in the same field?

diabinho — Fri, 08 Nov 2019 10:52:52 GMT

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

Re: How to create a field value from a group of values in the same field?

diabinho — Fri, 08 Nov 2019 11:17:24 GMT

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

Re: How to create a field value from a group of values in the same field?

diabinho — Fri, 08 Nov 2019 14:18:08 GMT

I think I got it by applying |timechart span=5m limit=9 usenull=f useother=true count by ALPHABET |fields + "A" "F" "G" "OTHER"

Re: How to create a field value from a group of values in the same field?

richgalloway — Fri, 08 Nov 2019 14:32:37 GMT

@diabinho If your problem is resolved, please accept an answer to help future readers.