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


#1

Hi,

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?

Thanks,
CJ


#3

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.