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!

Splunk Enterprise Security(ES) 7.3 is approaching the end of support. Get ready for ...

Hi friends!    At Splunk, your product success is our top priority. With Enterprise Security (ES), we're here ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk, and empower your SOC to reach new heights! Duration: 1 hour  Prepare to ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...