Dashboards & Visualizations

DIsplay 0 when no results returned in single value

ipops
Path Finder

I have the following search which parses delimited fields.

sourcetype=ivrdata | eval {message}=varValue | stats first(LogTimestamp) as Time values(Network) as Network values(Phone) as Phone values(Tower) as Tower values(Platform) as Platform values(Province) as Province by IVR_SessionID | WHERE Platform="Test" AND Tower="99" | eval _time=Time | stats count by _time | accum count

I want to display the count as a singlevalue on a dashboard. When the search returns no results, the singlevalue displays "N/A". How can I make this show 0 instead?

I tried adding "fillnull 0" before the stats statement but still does not work. any ideas?

Tags (1)
0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...