Peak Second Each Day Over Time

I'm ingesting data real time and would like to see the peak event rate second by day. Essentially, what was the busiest second each day and how many events occurred at that second. It's pretty straightforward on a smaller time scale, but I need to see it over the past 12 months within Kibana (so I can share with others internally.)

Thoughts?

I'm thinking maybe use a data table - not very cute or pretty, but gets the point across - with a date histogram, one day interval, for the first aggregation, and then for each of those one-day buckets use a max aggregation on a one-second fixed interval histogram. Just doing that off the top of my head, but maybe worth a shot.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.