# How to manipulate result of cumulative sum metric?
**URL:** https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063
**Category:** Kibana
**Created:** [July 21, 2017, 6:52am UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063 "2017-07-21T06:52:05Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [July 21, 2017, 6:52am UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063/1 "2017-07-21T06:52:05Z")
Kibana version : 5.4.0
Hello .
I have a goal to achieve but struggling with kibana interface so I would like to get some help with this.
## My Goal
I will need to achieve below 2 steps
1. Calculate the _cumulative sum_ of field _spamscore_ using the histogram bucket
2. Using the _cumulative sum_ I will need to calculate the ratio of against the _total hits_ of search period.
For step2 , I will need to divide each histogram bucket by _73_ (e.g 3 / 73 , 5/73,etc )
Currently, I have achieved step1 as below.
However, I am struggling with Step2. After reading the [document](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-script-aggregation.html) , I assume that I will need to write script but not sure **where to write it** and **how to access the cumulative sum series as doc field**.
May I ask how can I achieve my goal?
---
### Author:  [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)
#### Post date: [July 21, 2017, 8:56pm UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063/2 "2017-07-21T20:56:50Z")
Unfortunately, you are not currently able to chain aggregations in Visualize. However, this might be possible with Timelion if you are actually looking for a histogram.
What should the visualization look like in the end?
@thomasneirynck might be able to provide some insights.
---
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [July 24, 2017, 1:45am UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063/3 "2017-07-24T01:45:11Z")
@tsmalley
Thank you for the reply.
Ok. So input data will be below. _Score_ will be the histogram in this case.
From above time series , I want to do aggregation like below.
From the data above I am trying to draw a chart like below. The charts consists of
1. Counts per scores
2. ratio of counts against cumulative sum of counts along the over the scores.
Can this be drawn on timelion ?
---
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [July 27, 2017, 8:19am UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063/4 "2017-07-27T08:19:47Z")
@tsmalley @thomasneirynck
Any luck ?
---
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [August 7, 2017, 1:53am UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063/5 "2017-08-07T01:53:28Z")
I have amended the original data series. Since it was the result aggregation instead.
---
### Author:  [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)
#### Post date: [August 10, 2017, 11:39am UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063/6 "2017-08-10T11:39:21Z")
Any good idea?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 7, 2017, 11:39am UTC](https://discuss.elastic.co/t/how-to-manipulate-result-of-cumulative-sum-metric/94063/7 "2017-09-07T11:39:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.