Splunk Search

Sum or count by same value

rsokolova
Path Finder

Thanks in advance.

We are trying to sum two values based in the same common key between those two rows and for the ones missing a value should be considered as a cero, to be able to sum both fields (eval Count=Job_Count + Request_Count) . alt text

Expected result should be:
PO_Ready Count
006341102527 5
011561102529 5
011971102529 6
012381102528 5

Tags (4)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi rsokolova,
If you always have only one between Job_Count and Request_Count, you can try something like this:

your_search
| eval Count=coalesce(Job_Count,Request_Count)
| stats sum(Count) AS Count BY PO_Ready 

otherwise if you have for a PO_Ready both Job_Count and Request_Count, you can try something like this:

your_search
| stats sum(Job_Count) AS Job_Count sum(Request_Count) As Request_Count BY PO_Ready 
| eval Count=Job_Count + Request_Count 
| table PO_Ready Count

Bye.
Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi rsokolova,
If you always have only one between Job_Count and Request_Count, you can try something like this:

your_search
| eval Count=coalesce(Job_Count,Request_Count)
| stats sum(Count) AS Count BY PO_Ready 

otherwise if you have for a PO_Ready both Job_Count and Request_Count, you can try something like this:

your_search
| stats sum(Job_Count) AS Job_Count sum(Request_Count) As Request_Count BY PO_Ready 
| eval Count=Job_Count + Request_Count 
| table PO_Ready Count

Bye.
Giuseppe

rsokolova
Path Finder

Thanks cusello for the quick reply the coalesce command did the trick.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...