How to manipulate result of cumulative sum metric?

Elastic Stack Kibana
1

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 )

histogram2.PNG937×650 23.8 KB

Currently, I have achieved step1 as below.

histogram1.png1374×647 36.2 KB

However, I am struggling with Step2. After reading the document , 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?

2

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.

3

@tsmalley

Thank you for the reply.

Ok. So input data will be below. Score will be the histogram in this case.

data_series

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 ?

4

@tsmalley @thomasneirynck

Any luck ?

5

I have amended the original data series. Since it was the result aggregation instead.

6

Any good idea?

7

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