Splunk Search

How to compute results using rows /cells from a table?

andres91302
Communicator

Hello Friends, 

I'm trying to generate a table that summarizes the total count of events A, B and C as follows

 

search 1 | fields A 
| stats  count(A) as Net 
| eval stage="A"
| append 
    [ search search 2 | fields B
    | stats count(B) as Net 
    | eval stage="B"] 
| append 
    [ search search 3 | fields C
    | stats count(C) as Net 
    | eval stage="C"] 
| table stage, Net

 

But I cannot seem to find a way to the create a field named "conv" that will compute the follow opeacion:

take the value of the current Net count subtract the previous value and then devide it by the previous value, in other words find the percentage of conversion between stages, BUT for thw first row it will be zero something like this:


StageNetconv
A1000
B80(80- 100)/100  = -0.2  
C70(70-80) /80 = -0.125 


I was thinking about a way to calculate something with a for loop? but I dont know how ti access the indexes of the table... Thank you so much to everyone that can help me like THANK YOU SO MUCH

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| streamstats values(Net) as previous window=1 current=f
| eval conv=(Net-previous)/previous

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| streamstats values(Net) as previous window=1 current=f
| eval conv=(Net-previous)/previous

andres91302
Communicator

@ITWhisperer  thank you for your great help! it means a lot to me, your code worked as expected 10/10 I will reading documenaton of streamstats and eventstats to use them in the futurethank you so much again, thanks a lot

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 ...