How to calculate average response time by day per request type?

[nlrdy]

Hello,

I was able to get the chart with below fields. Now my question is how do I calculate average response time ((NA+EMEA+APAC)/3) for each web service request for each day ?

[somesoni2 · Accepted solution]

Just add following to your current search

your current search | eventstats avg(avg_response) as DailyAvg by Time Request

[nlrdy]

Works perfectly !!. Thank you.

[martin_mueller]

Assuming you have events with timestamp, Request, DC, and response fields, you can do something like this:

base search returning those events | bin span=1d _time | stats avg(response) as avg_response by DC Request | timechart avg(avg_response) by Request

That's assuming you want to average per DC first, then average those again. Alternatively, you could average over all DCs together like this:

base search returning those events | timechart avg(response) by Request

[nlrdy]

The chart should still be present with aggregated values. is this possible without using dashboard ?