Kibnan visualize datatable calculate the average value


(hsiuming) #1

Hello

We now have a data table in kibana:

We want to add one column to calculate the average value of the column2 within a specific time frame.

For example ,we want to calculate the average value between every second.

The export is :

Is there any method to do this?


(Eric Ohtake) #2

I think probably you can accomplish that with scripted field. I didn't try it yet, but it can give some ideas on how to accomplish this.

https://www.elastic.co/guide/en/kibana/current/scripted-fields.html


(hsiuming) #3

I think Scripted fields can't do it.

'doc['field_name'].value' can't get other value on the same column.

Thanks for your reply.

Is there any other method?


(system) #4

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