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 ?
Just add following to your current search
your current search | eventstats avg(avg_response) as DailyAvg by Time Request
Just add following to your current search
your current search | eventstats avg(avg_response) as DailyAvg by Time Request
Works perfectly !!. Thank you.
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
The chart should still be present with aggregated values. is this possible without using dashboard ?