Please help me in the below search query
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
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
... View more