# Show monthly avrage as 24 hours **URL:** \ **Category:** Kibana\ **Created:** [April 1, 2019, 4:44pm UTC](https://discuss.elastic.co/t/show-monthly-avrage-as-24-hours/174826 "2019-04-01T16:44:27Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Alexander\_Zhilko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexander_zhilko/32/43241_2.png) [@Alexander\_Zhilko](https://discuss.elastic.co/u/Alexander_Zhilko)\ **Post date:** [April 1, 2019, 4:44pm UTC](https://discuss.elastic.co/t/show-monthly-avrage-as-24-hours/174826/1 "2019-04-01T16:44:27Z")
i have web site logs feed to elasticsearch. now i want to aggregate data and couldn't achieve it . i want to give kibana a time frame , lets say 1 weeks and i want to get bar visualization of average clicks per hour. just to be clear i want 24 bars every bar represents one hour interval. but the value of that bar is this exact hour average across the selected time frame . 7PM bar with 1 week time frame will show the average between 7pm today 7pm yesterday 7pm 3 days ago 7pm 4 days ago 7 pm 5 days ago 7pm 6 days ago 7pm 7 days ago. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [April 1, 2019, 9:30pm UTC](https://discuss.elastic.co/t/show-monthly-avrage-as-24-hours/174826/2 "2019-04-01T21:30:41Z")
Kibana works on days, ie 00:00:00 to 23:59:59, rather than specific 24 hour periods. You may want to create a feature request if you want to see this sort of functionality. ---
**Author:** ![Alexander\_Zhilko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexander_zhilko/32/43241_2.png) [@Alexander\_Zhilko](https://discuss.elastic.co/u/Alexander_Zhilko)\ **Post date:** [April 10, 2019, 7:42am UTC](https://discuss.elastic.co/t/show-monthly-avrage-as-24-hours/174826/3 "2019-04-10T07:42:47Z")
ok can these be done through elastic search? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 8, 2019, 7:42am UTC](https://discuss.elastic.co/t/show-monthly-avrage-as-24-hours/174826/4 "2019-05-08T07:42:49Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.