# Make cumulative sum to zero at midnight **URL:** \ **Category:** Kibana\ **Created:** [April 3, 2025, 8:33pm UTC](https://discuss.elastic.co/t/make-cumulative-sum-to-zero-at-midnight/376768 "2025-04-03T20:33:18Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [April 3, 2025, 8:33pm UTC](https://discuss.elastic.co/t/make-cumulative-sum-to-zero-at-midnight/376768/1 "2025-04-03T20:33:18Z")
I have simple data get in every 15 min. date - size and I would like to create cumulative sum of size. but at midnight I would like to reset it to zero and start over again for a day. how do I do it? is it possible? if I have insert zero value to size I can do that ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/2/b2b6b912ed056162b3663762b55c7aa47ad613c1.png) ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [April 4, 2025, 11:31am UTC](https://discuss.elastic.co/t/make-cumulative-sum-to-zero-at-midnight/376768/2 "2025-04-04T11:31:08Z")
is it possible in vega or Timelion? ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [April 4, 2025, 12:24pm UTC](https://discuss.elastic.co/t/make-cumulative-sum-to-zero-at-midnight/376768/3 "2025-04-04T12:24:05Z")
oh figure out how to do it. it is in lens ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/e/5e6ec03ff90cdcad050fd1e129687997cbccc292.png) X - axis is one hour interval breakdown - is one day it starts fresh from each day ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/9/09c524c9b3124e7cf03f52e4cafc089d8368f7df.png)