# CUMSUM is missing in machine learning

**URL:** https://discuss.elastic.co/t/cumsum-is-missing-in-machine-learning/144666
**Category:** Elasticsearch
**Tags:** elastic-stack-machine-learning
**Created:** [August 16, 2018, 9:04am UTC](https://discuss.elastic.co/t/cumsum-is-missing-in-machine-learning/144666 "2018-08-16T09:04:59Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Amon](https://avatars.discourse-cdn.com/v4/letter/a/91b2a8/32.png) [@Amon](https://discuss.elastic.co/u/Amon)
#### Post date: [August 16, 2018, 9:04am UTC](https://discuss.elastic.co/t/cumsum-is-missing-in-machine-learning/144666/1 "2018-08-16T09:04:59Z")

</div>

Dear,

For a project I'm using your machine learning part. Unfortunaletly I'm using a collumn with value +1,-1 and 0 which stand for people in a queue. I want to detect anomalies with the "high sum" function to detect when there are to many people in a queue, but I see when I'm using it he only take into account the amount of people who are coming in or leaving the queue on that particular moment without taking into account the past. Are guys gonna add the cumsum function in the future?

With kind regards, Amon De Keyser

---

<div class="post-metadata">

### Author: ![a5a](https://avatars.discourse-cdn.com/v4/letter/a/a87d85/32.png) [@a5a](https://discuss.elastic.co/u/a5a)
#### Post date: [August 16, 2018, 4:03pm UTC](https://discuss.elastic.co/t/cumsum-is-missing-in-machine-learning/144666/2 "2018-08-16T16:03:11Z")

</div>

Moving this to Machine Learning forum.

---

<div class="post-metadata">

### Author: ![richcollier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/richcollier/32/115035_2.png) [@richcollier](https://discuss.elastic.co/u/richcollier)
#### Post date: [August 16, 2018, 8:24pm UTC](https://discuss.elastic.co/t/cumsum-is-missing-in-machine-learning/144666/3 "2018-08-16T20:24:41Z")

</div>

Try the [cumulative sum aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-cumulative-sum-aggregation.html) in ES, then have your ML job use the output of this aggregation ([docs here](https://www.elastic.co/guide/en/x-pack/current/ml-configuring-aggregation.html), and a [similar example here](https://www.elastic.co/blog/custom-elasticsearch-aggregations-for-machine-learning-jobs))

---

<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 13, 2018, 8:25pm UTC](https://discuss.elastic.co/t/cumsum-is-missing-in-machine-learning/144666/4 "2018-09-13T20:25:00Z")

</div>

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