Hi,
I have a web service's http access log and I want to find out the average request per minute for each url_path over the WHOLE period. A timechart of per minute average is not what I need.
I tried the following search query, but because during some minutes some url_path may not have events at all, and this search does not give the correct statistics.
sourcetype=accesslog | bucket _time span=1m | stats count by _time url_path | stats avg(count) as avg_per_min by url_path
This should be a very simple use case, but still cannot find a solution to that, could anyone help ?
... View more