How to apply arithmetic division on aggregation value in Kibana Data table?



I am using ELK GA 5.0.0. I have created a data table, containing a sum aggregation, and rows are split using a term. What I want is, I want to divide the values in sum column by 10. Is this possible?

Thanks in advance..

(CJ Cenizal) #2

Hi there, is this what your visualization configuration looks like:

If so, can you create a scripted field that divides the field by 10 (in the screenshot above, this would be the "bytes" field), and do your sum on that?



Hi there,

@cjcenizal isn't there any method other than scripted field? Will scripted fields affect Kb/ES performance? When I tried this, the fractions are getting removed. Posted here Scripted field is ignoring fractional points

(system) #4

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