I have this search, but I am not seeing any values for Requests:
(status=200 OR status>399) | eval Type=if(status==200,"Good","Bad") | chart count as requests over host by Type | rename "requests: Good" as GoodRequests ,"requests: Bad" as Failures | eval TotalRequests= (GoodRequests+Failures) | eval GoodRequestsPerc = round((GoodRequests/TotalRequests)*100,2) | eval FailuresPerc = round((Failures/TotalRequests)*100,2) | table host, GoodRequests,Failures,GoodRequestsPerc, FailuresPerc | sort -"FailuresPerc"
I am not seeing any values for GoodRequests, Failures, etc.
Any suggestions?
when i renamed, If i used the same name as i have in the if condition (instead of GoodRequests, used Good& requests: Bad as Bad) i am able to see the stats.
when i renamed, If i used the same name as i have in the if condition (instead of GoodRequests, used Good& requests: Bad as Bad) i am able to see the stats.
If this answered your own question then please mark it as accepted.
If not then please explain your question.