# Visual Builder: cumulative sum doesn't work using a "calculation" as metric?

**URL:** https://discuss.elastic.co/t/visual-builder-cumulative-sum-doesnt-work-using-a-calculation-as-metric/109036
**Category:** Kibana
**Created:** [November 24, 2017, 1:34pm UTC](https://discuss.elastic.co/t/visual-builder-cumulative-sum-doesnt-work-using-a-calculation-as-metric/109036 "2017-11-24T13:34:31Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![pchanas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pchanas/32/15311_2.png) [@pchanas](https://discuss.elastic.co/u/pchanas)
#### Post date: [November 24, 2017, 1:34pm UTC](https://discuss.elastic.co/t/visual-builder-cumulative-sum-doesnt-work-using-a-calculation-as-metric/109036/1 "2017-11-24T13:34:31Z")

</div>

Hello

Using Visual Builder I am trying to compute a cumulative sum on a calculation (on 2 aggs).  
I get this error: "The request for this panel failed"

 ![zzz](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cd2e5724c5d6232331e9fd107f25de5c7247caee.jpeg)

Thanks in advance for you help.  
Pascal

---

<div class="post-metadata">

### Author: ![simianhacker](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simianhacker/32/3383_2.png) [@simianhacker](https://discuss.elastic.co/u/simianhacker)
#### Post date: [November 27, 2017, 6:28pm UTC](https://discuss.elastic.co/t/visual-builder-cumulative-sum-doesnt-work-using-a-calculation-as-metric/109036/2 "2017-11-27T18:28:38Z")

</div>

I think there is a bug with using cumulative sum with other pipeline aggregations. I've submitted a bug with the Elasticsearch team: [https://github.com/elastic/elasticsearch/issues/27544](https://github.com/elastic/elasticsearch/issues/27544)

---

<div class="post-metadata">

### Author: ![pchanas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pchanas/32/15311_2.png) [@pchanas](https://discuss.elastic.co/u/pchanas)
#### Post date: [November 29, 2017, 9:48am UTC](https://discuss.elastic.co/t/visual-builder-cumulative-sum-doesnt-work-using-a-calculation-as-metric/109036/3 "2017-11-29T09:48:21Z")

</div>

Thanks for your feedback and help.  
In the meantime, I found a workraound by using "Series Agg" and "Cumlative Sum" as function.

Pascal

---

<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: [December 27, 2017, 9:48am UTC](https://discuss.elastic.co/t/visual-builder-cumulative-sum-doesnt-work-using-a-calculation-as-metric/109036/4 "2017-12-27T09:48:38Z")

</div>

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