Splunk Search

How to convert a pie chart into a single value visualization when the search returns no results?

Chinmai
Explorer

Hello Guys,

I have a pie chart in my dashboard, so whenever the search returns nothing, the pie chart should convert into single value visualization showing count as 0. And if there are any results from the search, pie chart should remain as it is.
Currently it shows no results found whenever the search returns nothing.

Can anyone help me with this problem?

Many Thanks in advance.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Since the query is returning nothing, there is nothing to chart. Add this snippet to your search to force a count of zero when there are no results. Change the 'foo' and 'bar' fields to fields in your current query.

| appendpipe [ stats count | eval foo="Nothing found" | eval bar=0 | where count==0 | fields - count ] | ...
---
If this reply helps you, Karma would be appreciated.
0 Karma

Chinmai
Explorer

Thanks for your answer, but how will this convert pie chart into single value? this is in my dashboard panel, under chart tag the query is written

0 Karma

richgalloway
SplunkTrust
SplunkTrust

It won't change the type of chart. You'll still see a pie chart, but that's better than "No results found", right?

---
If this reply helps you, Karma would be appreciated.
0 Karma

Chinmai
Explorer

when count is 0, its not showing pie chart, it is showing "numeric data required"

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Check the field names in the appendpipe command. You may have foo and bar mixed up.

---
If this reply helps you, Karma would be appreciated.
0 Karma

Chinmai
Explorer

nope, they are fine, and still same result:( is there any other way to display 0 whenever the search returns nothing?

0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...