# Date histogram that doesn't look at the entire date bucket?

**URL:** <https://discuss.elastic.co/t/date-histogram-that-doesnt-look-at-the-entire-date-bucket/316415>\
**Category:** Kibana\
**Created:** [October 12, 2022, 8:06am UTC](https://discuss.elastic.co/t/date-histogram-that-doesnt-look-at-the-entire-date-bucket/316415 "2022-10-12T08:06:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![netzer](https://avatars.discourse-cdn.com/v4/letter/n/c89c15/32.png) [@netzer](https://discuss.elastic.co/u/netzer)\
**Post date:** [October 12, 2022, 8:06am UTC](https://discuss.elastic.co/t/date-histogram-that-doesnt-look-at-the-entire-date-bucket/316415/1 "2022-10-12T08:06:33Z")

</div>

I'm wondering if the following is possible.  
I have events with metrics sent every 10 minutes, so when I create a dashboard looking at the past 15 minutes I can see the "latest status". I can also do a "SUM" of a field over several events to see the "latest and updated SUM" this way.

However - If now I want to create a date histogram, for example, I want to know the same SUM yesterday, and the day before that, etc, I can't. because the SUM is on the entire time bucket. And what I need is to say "take specific time points, 24 hours apart, and for each time point just take the last 15 minutes".  
Is this possible? if not - what do you think is the "shortest route" here? To have a script reading every 24 hours the relevant data fo the last 15 minutes, creating a single log every 24 hours with the aggregated data of the specific time period? anything shorter?

---

<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:** [November 9, 2022, 8:07am UTC](https://discuss.elastic.co/t/date-histogram-that-doesnt-look-at-the-entire-date-bucket/316415/2 "2022-11-09T08:07:17Z")

</div>

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