Kibnan visualize datatable calculate the average value

[hsiuming]

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?

[ericohtake]

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]

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?