Visualizing Overall Max 'Num of Events per Second' in Hour Buckets

Elastic Stack Kibana
1

I've got multiple events that come in every second to couple of seconds and I'm looking to...

  • Count the number of events that come in for each second
  • Group those 'events per second' in buckets of of an hour
  • Get the overall max of those 'events per second' for each 'hour' bucket
  • And visualize each overall max per hour

I feel like it should be possible to do this in a visualization, but I've tried a number of approaches and none of them seem to give me the correct graph. No matter what I try it seems to keep grouping the count of events per hour and displaying that in the graph.

2

I figured out a solution. It required creating a Transform with a field that counted events per second, using the field from that transform to create the 'Hour Buckets', and then run a Max metric on that new Transform field.