I've got 2 search queries that are working for me (Thanks to @harshpatel)
Query #1 returns the average # of successes over the last 7 Days.
"A PUT was made to OpenAAA API - Status: OK" | spath AppID | search AppID=200296 Environment=prod | timechart count by Environment | bin span=7d _time | stats avg(prod)
Query #2 returns the average # of failures over the last 7 Days.
"A PUT was made to OpenAAA API - Status: 1" | spath AppID | search AppID=200296 Environment=prod | timechart count by Environment | bin span=7d _time | stats avg(prod)
How can I find out the percentage of failures based on these 2 queries? AVG # of Failures divided by AVG # of Successes
Example. 100 success and 50 failures .... Percentage of Failures would be 50%)
Any help will be greatly appreciated!
Thanks
... View more