Hi Everyone!
Could you please help, how to calculate (UP percentage) by app_service
I have the query as:
eval status=if(success="successful .Statuscode:200", "UP", "DOWN"
| table app_service status
I get the table I need, but I have difficulty calculating the "UP" percentage and total percentage per app_service from the above query
Thank you
Hi @Noah
Can you try this?
| makeresults
| eval success="successful .Statuscode:200" , app_service="jobber"
| eval status=if(success="successful .Statuscode:200", "UP", "DOWN")
| stats count, count(eval(status="UP")) as up_count by app_service
| eval perc= round((up_count/count) * 100,4)
| table count up_count app_service perc
An upvote would be appreciated and Accept solution if this reply helps!
Hi @Noah
Can you try this?
| makeresults
| eval success="successful .Statuscode:200" , app_service="jobber"
| eval status=if(success="successful .Statuscode:200", "UP", "DOWN")
| stats count, count(eval(status="UP")) as up_count by app_service
| eval perc= round((up_count/count) * 100,4)
| table count up_count app_service perc
An upvote would be appreciated and Accept solution if this reply helps!
Thank you @venkatasri Venkatasri! This definitely helped with some modifications. Much appreciated!