Splunk Dev

Add Values from Rows

dfrench151
Explorer

Hello,

I'm trying to add values from rows. See the picture below. alt text

What I am pretty much trying to do is add the count from unconfirmed_down status to the up status. The thing is is that the unconfirmed_down status isn't always there depending on the source I am pulling from and could vary from month to month, so I need to have an exception included in case it is not there. I have though have saying add field 1 to field 2, but that could produce incorrect results if that particular status is not there...

0 Karma
1 Solution

niketn
Legend

@dfrench151 can you try the following?

index=<yourIndexName>
| eval status=if(status=="unconfirmed_down","up",status)
| stats count by status
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma

niketn
Legend

@dfrench151 can you try the following?

index=<yourIndexName>
| eval status=if(status=="unconfirmed_down","up",status)
| stats count by status
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

dfrench151
Explorer

This only produced that status for up and count unfortunately

0 Karma

niketn
Legend

The above should move unconfirmed_down as up and remaining up and down status intact. So final sum should be only up and down status. Is your expectation different
?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

dfrench151
Explorer

Sorry about that. I re-ran that and it did what I needed. Thank you

niketn
Legend

No problem. Glad it worked!

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...