# Max sum of 15 min window

**URL:** <https://discuss.elastic.co/t/max-sum-of-15-min-window/233205>\
**Category:** Kibana\
**Created:** [May 18, 2020, 9:53pm UTC](https://discuss.elastic.co/t/max-sum-of-15-min-window/233205 "2020-05-18T21:53:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [May 18, 2020, 9:53pm UTC](https://discuss.elastic.co/t/max-sum-of-15-min-window/233205/1 "2020-05-18T21:53:33Z")

</div>

I have number field called count.  
which is collected every min.  
I want to sum them up for every 15 min. and display only max of that four itration on hourly windows.

1st sum (1-15 min data) 110  
2nd sum (16-30 min data) 120  
3rd sum (31-45 min data) 140  
4th sum (46-00 min data) 100

then on X axis where I have date histogram (one hour) I want to display only 140. is that possible?

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [May 19, 2020, 7:55am UTC](https://discuss.elastic.co/t/max-sum-of-15-min-window/233205/2 "2020-05-19T07:55:54Z")

</div>

This configuration should do the calculation you are interested in (click the visualization and possibly scroll down, it's pretty long):

 ![Screenshot 2020-05-19 at 09.53.57](https://us1.discourse-cdn.com/elastic/original/3X/d/7/d78cb5e891a2e126002205b84e3e89e8978bdc1b.png)

On the X axis it's a regular hourly date histogram. The metric on the y axis is the "Max bucket" of a 15m date histogram of the sum of the field you are interested in.

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [May 19, 2020, 3:05pm UTC](https://discuss.elastic.co/t/max-sum-of-15-min-window/233205/3 "2020-05-19T15:05:12Z")

</div>

@flash1293 Thank you very much for detail reply. that is what I was trying to do.

---

<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:** [June 16, 2020, 3:10pm UTC](https://discuss.elastic.co/t/max-sum-of-15-min-window/233205/4 "2020-06-16T15:10:06Z")

</div>

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