display average hits per minute for each hour for a time range

[jrich523]

how do i show the average number of hits per minute for each hour?

basically i have a system that will, on peak hours, get between 60-80 hits a minute. what i'd like to see is for each hour (11am-12pm) show what the average hits/min is. sort of a nested average i guess.. and then show that for a day.

i wasnt even really sure what field to average so im not really off to a good start

Thanks

[gkanapathy · Accepted solution]

I'm assuming that your log data contains one entry per hit? If so, you can just do:

sourcetype=whatever | timechart span=1h count | eval hpm=count/60