https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316644#M39633 <P>Hi it is simple try this,</P> <P>your search<BR /> | eval count=if(isnull(count),"0",count)<BR /> | table count</P> Sat, 07 Apr 2018 10:09:42 GMT krishnab 2018-04-07T10:09:42Z https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316643#M39632 <P>hi </P> <P>i use this request in a Dashboard<BR /> but when the result = 0 i dont have 0 displaying but Nothing<BR /> i would like to ,have 0<BR /> how to do please?<BR /> thanks</P> <P>index="*" DisplayName="PCServicesWinSrv" Started="false" State="Stopped" | dedup host | stats count by DisplayName | eventstats sum(count) as Total | eval percent=round((count/Total)*100,1) | eval DisplayName=DisplayName."(count: ".count.", percent: ".percent.")" | table count</P> Tue, 29 Sep 2020 18:54:12 GMT https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316643#M39632 jip31jip31 2020-09-29T18:54:12Z https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316644#M39633 <P>Hi it is simple try this,</P> <P>your search<BR /> | eval count=if(isnull(count),"0",count)<BR /> | table count</P> Sat, 07 Apr 2018 10:09:42 GMT https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316644#M39633 krishnab 2018-04-07T10:09:42Z https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316645#M39634 <P>Splunk gives you the fillnull function to do this instead of writing an eval statement(which also should work) - </P> <PRE><CODE>your search | fillnull value=0 count </CODE></PRE> Sun, 08 Apr 2018 09:28:20 GMT https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316645#M39634 Sukisen1981 2018-04-08T09:28:20Z https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316646#M39635 <P>thanks a lot!!!!!!</P> Sun, 08 Apr 2018 15:40:11 GMT https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316646#M39635 jip31 2018-04-08T15:40:11Z https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316647#M39636 <P>thank you very much</P> Sun, 08 Apr 2018 15:40:39 GMT https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316647#M39636 jip31 2018-04-08T15:40:39Z https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316648#M39637 <P>@jip31 if one of the answers has helped you, please do not forget to accept the same to mark this question as answered!</P> Sun, 08 Apr 2018 16:13:59 GMT https://community.splunk.com/t5/Dashboards-Visualizations/0-instead-empty/m-p/316648#M39637 niketn 2018-04-08T16:13:59Z