# Transforms - are cumulative sums a possibility?

**URL:** <https://discuss.elastic.co/t/transforms-are-cumulative-sums-a-possibility/244426>\
**Category:** Elasticsearch\
**Created:** [August 10, 2020, 3:16pm UTC](https://discuss.elastic.co/t/transforms-are-cumulative-sums-a-possibility/244426 "2020-08-10T15:16:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Duncan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_duncan/32/46467_2.png) [@Mark\_Duncan](https://discuss.elastic.co/u/Mark_Duncan)\
**Post date:** [August 10, 2020, 3:16pm UTC](https://discuss.elastic.co/t/transforms-are-cumulative-sums-a-possibility/244426/1 "2020-08-10T15:16:32Z")

</div>

I would like to sum a metric over time using Transforms, i.e. a cumulative sum. Is this at all possible?

Whilst you can plot a cumulative sum graph using the basic graphs in Kibana, it's cumulative over the date range selected. I'd like to be able to set a start date in effect in an index/transform output, and the transform produce the cumulative sum over time.

---

<div class="post-metadata">

**Author:** ![Mark\_Duncan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_duncan/32/46467_2.png) [@Mark\_Duncan](https://discuss.elastic.co/u/Mark_Duncan)\
**Post date:** [August 10, 2020, 3:30pm UTC](https://discuss.elastic.co/t/transforms-are-cumulative-sums-a-possibility/244426/2 "2020-08-10T15:30:07Z")

</div>

and to clarify - I know I could produce a single row of output with a sum total of a metric from input, but I am hoping to be able to produce a cumulative sum over time, i.e. per day or better still for each record that I add from my input (at it's timestamp.

Thanks in advance.

---

<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:** [September 7, 2020, 3:30pm UTC](https://discuss.elastic.co/t/transforms-are-cumulative-sums-a-possibility/244426/3 "2020-09-07T15:30:16Z")

</div>

Closed on September 7, 2020, 3:30pm UTC

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