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

Elastic Stack Kibana
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..

2

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

image.png347×843 24.2 KB

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