How to get transaction count between 5-10 10-15?

[karthi2809]

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

[woodcock · Accepted solution]

You should be able to add this to the bottom:

| eval diff = $5-10 Secs$ - $10-15 Secs$