topic Re: Return one value from field-B when counting field-A in Splunk Search

Return one value from field-B when counting field-A

sta_splunk — Mon, 04 Nov 2024 20:18:38 GMT

I have data similar to:

Field-A Field-B
A1 B1
A1 B2
A1 B3
A2 B4
A3 B5
A2 B6

Where Field-A will repeat but Field-B is unique values.

I am using | stats count by Field-A to give me the number of occurrences of A1, A2, A3 and am trying to include a single example of Field-B. Something like:

Field-Count-Example
A1 -- 3 -- B2
A2 -- 2 -- B6
A3 -- 1 -- B5

Thank you for any suggestions.

Re: Return one value from field-B when counting field-A

richgalloway — Mon, 04 Nov 2024 21:34:47 GMT

Try this

| stats count as Count, first(Field-B) as Example by Field-A

Re: Return one value from field-B when counting field-A

sta_splunk — Mon, 04 Nov 2024 21:53:58 GMT

That worked great! I was trying to use two different 'stats' and could not get both of the values.

Thanks for your help!!

Re: Return one value from field-B when counting field-A

richgalloway — Tue, 05 Nov 2024 01:03:06 GMT

Two separate stats commands are unlikely to work because they're transforming commands. That means the seconds stats won't have the same fields to work with as the first one. One alternative is to use eventstats before stats, but it's unnecessary in this case because a single stats can do it all.