# How to compare hourly performance on different days
**URL:** https://discuss.elastic.co/t/how-to-compare-hourly-performance-on-different-days/146973
**Category:** Kibana
**Created:** [September 2, 2018, 10:08am UTC](https://discuss.elastic.co/t/how-to-compare-hourly-performance-on-different-days/146973 "2018-09-02T10:08:02Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)
#### Post date: [September 2, 2018, 10:08am UTC](https://discuss.elastic.co/t/how-to-compare-hourly-performance-on-different-days/146973/1 "2018-09-02T10:08:02Z")
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.
---
### Author:  [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [September 4, 2018, 11:26am UTC](https://discuss.elastic.co/t/how-to-compare-hourly-performance-on-different-days/146973/2 "2018-09-04T11:26:43Z")
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.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 2, 2018, 11:38am UTC](https://discuss.elastic.co/t/how-to-compare-hourly-performance-on-different-days/146973/3 "2018-10-02T11:38:58Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.