How do I calculate the average no. of HTTP requests per second?

[moizmmz]

I have a field name called http_method which lists 6 different types of HTTP requests. I need the average number of a particular HTTP request (say GET) per second. I also have a field called date_second which lists the count as it increases for every second.

How do I go about doing this? All I need is an average no of that request per second.

[HiroshiSatoh · Accepted solution]

Try this!

index="your index" http_method=GET
| timechart count span=1s
|stats avg(count)

[moizmmz]

It worked! thank you so much :)!!

[moizmmz]

There's one small problem I'm facing. I'm not able to use the single value visualization for this. I need to put it as a dashboard panel.