Splunk Search

Sum or count by same value

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=JobCount + RequestCount) . alt text

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

Tags (4)
0 Karma
1 Solution

Legend

Hi rsokolova,
If you always have only one between JobCount and RequestCount, 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 POReady both JobCount 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

Legend

Hi rsokolova,
If you always have only one between JobCount and RequestCount, 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 POReady both JobCount 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

Path Finder

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

0 Karma