I would like to create a dashboard to show the percentage of each of my service meeting a certain performance requirement. Each of the request access log entry would have field serviceName, txTime, and I would like to generate a table that show the percentage of requests meeting my SLA requirement of say 1000ms.
The desired output would look something like
ServiceName Percentage
Service1 98.9%
Service2 99%
thank you
How about
| eval SLA = if(txTime < 1000, 1, 0)
| stats count sum(SLA) as meetSLA by serviceName
| eval Percentage = 100 * meetSLA / count
| fields - count, meetSLA