How do I get the failure status for that percentile?

[karthi2809]

i want to calculate failure status 404 for service name .when the status is reached 90% .I need to trigger email?

index=xxx* |eventstats count(eval(Proxy)) as "totcnt" count(eval(Status="404")) as "failurecnt" by Name |stats perc90(failurecnt) as perc90_avg by Name

[somesoni2]

Try this (not sure if need to use percentile, just percentage should do it)
Updated

index=xxx* 
|stats count(Proxy) as "totcnt" count(eval(Status="404")) as "failurecnt" by Name 
|eval failurepercent=failurecnt*100/totcnt | where failurepercent>90

[micahkemp]

Unless I'm missing something, count(eval(Proxy)) could be more simply written count(Proxy), which will give the count of values in the Proxy field.

[somesoni2]

You're correct. Didn't look for that before. Corrected.