https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338914#M100502 <P>nope, they are fine, and still same result:( is there any other way to display 0 whenever the search returns nothing?</P> Wed, 19 Apr 2017 17:12:17 GMT Chinmai 2017-04-19T17:12:17Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338908#M100496 <P>Hello Guys,</P> <P>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.<BR /> Currently it shows no results found whenever the search returns nothing.</P> <P>Can anyone help me with this problem?</P> <P>Many Thanks in advance.</P> Wed, 19 Apr 2017 14:53:01 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338908#M100496 Chinmai 2017-04-19T14:53:01Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338909#M100497 <P>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.</P> <PRE><CODE>| appendpipe [ stats count | eval foo="Nothing found" | eval bar=0 | where count==0 | fields - count ] | ... </CODE></PRE> Wed, 19 Apr 2017 15:24:53 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338909#M100497 richgalloway 2017-04-19T15:24:53Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338910#M100498 <P>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</P> Wed, 19 Apr 2017 15:39:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338910#M100498 Chinmai 2017-04-19T15:39:18Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338911#M100499 <P>It won't change the type of chart. You'll still see a pie chart, but that's better than "No results found", right?</P> Wed, 19 Apr 2017 16:37:44 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338911#M100499 richgalloway 2017-04-19T16:37:44Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338912#M100500 <P>when count is 0, its not showing pie chart, it is showing "numeric data required"</P> Wed, 19 Apr 2017 16:49:46 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338912#M100500 Chinmai 2017-04-19T16:49:46Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338913#M100501 <P>Check the field names in the <CODE>appendpipe</CODE> command. You may have foo and bar mixed up.</P> Wed, 19 Apr 2017 17:00:02 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338913#M100501 richgalloway 2017-04-19T17:00:02Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338914#M100502 <P>nope, they are fine, and still same result:( is there any other way to display 0 whenever the search returns nothing?</P> Wed, 19 Apr 2017 17:12:17 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-a-pie-chart-into-a-single-value-visualization/m-p/338914#M100502 Chinmai 2017-04-19T17:12:17Z