https://community.splunk.com/t5/Splunk-Search/How-to-display-success-rate-as-100-if-no-API-calls-are-invoked/m-p/292044#M88203 <P>Please help me in the below search query </P> <PRE><CODE>index=Index1 sourcetype="Tablename" CounterName="Number of Successful API calls" OR CounterName="Number of Failed API calls" OR CounterName="Number of Request API calls" | eval Fail=if(match(CounterName,"Number of Failed API calls"),Value,0) | eval Success=if(match(CounterName,"Number of Successful API calls"),Value,0) | eval Total =Success+Fail | eventstats sum(Success) as Success,Sum(Total) as Total by CounterApiName | eval SuccessRate= (Success/Total)*100 | timechart limit=10000 span=30m values(SuccessRate) by CounterApiName </CODE></PRE> <P>This is showing as 0.00% when no API calls were triggered. I need to display 100% as success rate if no API calls are triggered </P> Tue, 20 Feb 2018 15:41:37 GMT rgopal88 2018-02-20T15:41:37Z https://community.splunk.com/t5/Splunk-Search/How-to-display-success-rate-as-100-if-no-API-calls-are-invoked/m-p/292044#M88203 <P>Please help me in the below search query </P> <PRE><CODE>index=Index1 sourcetype="Tablename" CounterName="Number of Successful API calls" OR CounterName="Number of Failed API calls" OR CounterName="Number of Request API calls" | eval Fail=if(match(CounterName,"Number of Failed API calls"),Value,0) | eval Success=if(match(CounterName,"Number of Successful API calls"),Value,0) | eval Total =Success+Fail | eventstats sum(Success) as Success,Sum(Total) as Total by CounterApiName | eval SuccessRate= (Success/Total)*100 | timechart limit=10000 span=30m values(SuccessRate) by CounterApiName </CODE></PRE> <P>This is showing as 0.00% when no API calls were triggered. I need to display 100% as success rate if no API calls are triggered </P> Tue, 20 Feb 2018 15:41:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-success-rate-as-100-if-no-API-calls-are-invoked/m-p/292044#M88203 rgopal88 2018-02-20T15:41:37Z https://community.splunk.com/t5/Splunk-Search/How-to-display-success-rate-as-100-if-no-API-calls-are-invoked/m-p/292045#M88204 <P>You can just add a check on your penultimate line by replacing this:</P> <PRE><CODE>| eval SuccessRate= (Success/Total)*100 </CODE></PRE> <P>with:</P> <PRE><CODE>| eval SuccessRate=if(Total=0, 100, (Success/Total)*100 ) </CODE></PRE> <P>That way, if Total was 0, then your SuccessRate will be 100, as desired. If Total was not 0, then it will be calculated as usual.</P> Tue, 20 Feb 2018 16:02:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-display-success-rate-as-100-if-no-API-calls-are-invoked/m-p/292045#M88204 elliotproebstel 2018-02-20T16:02:42Z