# Peak Second Each Day Over Time

**URL:** <https://discuss.elastic.co/t/peak-second-each-day-over-time/301984>\
**Category:** Kibana\
**Created:** [April 8, 2022, 3:30pm UTC](https://discuss.elastic.co/t/peak-second-each-day-over-time/301984 "2022-04-08T15:30:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JWR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jwr/32/27216_2.png) [@JWR](https://discuss.elastic.co/u/JWR)\
**Post date:** [April 8, 2022, 3:30pm UTC](https://discuss.elastic.co/t/peak-second-each-day-over-time/301984/1 "2022-04-08T15:30:29Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![RLPowellJr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rlpowelljr/32/97049_2.png) [@RLPowellJr](https://discuss.elastic.co/u/RLPowellJr)\
**Post date:** [April 8, 2022, 9:07pm UTC](https://discuss.elastic.co/t/peak-second-each-day-over-time/301984/2 "2022-04-08T21:07:59Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 6, 2022, 9:08pm UTC](https://discuss.elastic.co/t/peak-second-each-day-over-time/301984/3 "2022-05-06T21:08:52Z")

</div>

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