How to get transaction count between 5-10sec 10-15sec as table ?
Expected :
Total Success Failure 0-5 Secs 5-10 Secs 10-15 Secs >15 Secs
50 40 10 25 15 5 5
60 40 20 45 5 5 5
my query:
index = "test" | eval TransactionTime=TransactionSentEndtime - TransactionReceivedStartTime | eval TransactionTime=round((TransactionTime/1000),3) |eventstats count(eval(Proxy)) as "totcnt" count(eval(Status="500" OR Status="502" OR Status="503" OR Status="504" OR Status="4*")) as "failurecnt" count(eval(Status=200)) as "success" by Sender|stats values(totcnt) as TotalCount values(failurecnt) as FailureCount values(success) as SuccessCount by Sender
You should be able to add this to the bottom:
| eval diff = $5-10 Secs$ - $10-15 Secs$
You should be able to add this to the bottom:
| eval diff = $5-10 Secs$ - $10-15 Secs$