Can we calculate in Kibana?

[Amit2015 (Amit)]

Hi Guys,

I want to calculate field to get average time. Requirement is like I have request time and submitted time, two different field. I want to know how much it will take time, how can I calculate that average???

[NilsBecker]

I think you could make this with a "Scripted Field".

[Amit2015 (Amit)]

Hey, do you have any sample or tutorial for that???? In other tools like IBM Cognos, SAP BO we can do that directly. In Kibana how can we calculate???

[Pieter_Agenbag]

Just add a scripted field that subtracts the two values from each other and then plot an average of that value.

Manually Calculate Terms within a bar chart

Yup - that should be simple enough with a scripted field. Simply go to Settings choose your index and click on Scripted fields. Click "Add scripted field" and enter a name for the field Define your script , which should be "doc['status1'].value - doc['status2'].value" Done - you should now have a status3 field to use. [image]