Simple operations on count result

[jeremyr]

Hi All,

Simple question but I can't find a simple answer : I would like to know, if there a way to apply a simple math operation on count result like multiplication or division. ( Kibana 5.6.3)

I tried to add a script_fields on JSON input by following the documentation but it does not work...

My goal is to multiply this result ( see Example below)

Thanks for your help

J.

[rashmi (kulkarni)]

you could achieve it by scripted fields. In the screen shot below I have selected the Aggregation: Sum and field as count_field: This gives you the count of the docs.

Now add a scripted field like shown below where you can apply mathematical calculations on the fields:

This way you can achieve what you wanted multiply the result .

Hope this helps
Thanks
Rashmi

[jeremyr]

Thanks, works perfectly.

J.

[rashmi (kulkarni)]

Thanks for updating the thread.

Cheers
Rashmi