# Add Cumulative sum and cumul %

**URL:** https://discuss.elastic.co/t/add-cumulative-sum-and-cumul/307884
**Category:** Kibana
**Created:** [June 22, 2022, 1:32pm UTC](https://discuss.elastic.co/t/add-cumulative-sum-and-cumul/307884 "2022-06-22T13:32:54Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![yasser\_elalami](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yasser_elalami/32/107440_2.png) [@yasser\_elalami](https://discuss.elastic.co/u/yasser_elalami)
#### Post date: [June 22, 2022, 1:32pm UTC](https://discuss.elastic.co/t/add-cumulative-sum-and-cumul/307884/1 "2022-06-22T13:32:54Z")

</div>

hello iam new in kibana so i need some help

 ![Capture](https://us1.discourse-cdn.com/elastic/original/3X/e/c/eca81fe5872611a22ffaff676b1795f3934b5649.png)  
as you can see i need to add some formula like this  
 ![1](https://us1.discourse-cdn.com/elastic/original/3X/d/c/dca8a4f0378b7be91f48eb140498c9217cf1821f.png)  
THANK YOU

---

<div class="post-metadata">

### Author: ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)
#### Post date: [June 27, 2022, 4:09pm UTC](https://discuss.elastic.co/t/add-cumulative-sum-and-cumul/307884/2 "2022-06-27T16:09:22Z")

</div>

You can do `cumulative sum` in Lens but only for tables that use a date histogram. So for example using the flights sample dataset you can get a table per week, counting records, and with two columns one with the sum of `DistanceKilometers` and another with the cumulative sum of the previous aggregation.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/8/e8c2073d2aac6de29660dd384993d7b72f377b31.png)

If you use a `keyword` field then the tor terms agg does not enable the cumulative sum for metric columns

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/3/a35e6fdeeb35396644d9d2f79c7d67bd5ff79522.png)

---

<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: [July 25, 2022, 4:10pm UTC](https://discuss.elastic.co/t/add-cumulative-sum-and-cumul/307884/3 "2022-07-25T16:10:12Z")

</div>

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