How to compare hourly performance on different days

I’d like to see hourly activity over the course of a day, and further broken down day to day — how would I go about doing that?

If I use date histogram on the X-axis and then split chart by day, I can’t quite figure out how I can then align the chart together so that I can compare each hour for each day (e.g. compare activity at 8am across all days)

In screenshot above, what I would like to see is having all charts aligned left.

Hey @smlbiobot, you'll want to extract a separate field for "hour of day" and "day of week" and then use the terms aggregations to perform calculations similar to these. The Date Histogram Aggregation is focused on operating on the full date and time, which makes your type of analysis harder.

1 Like

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