How to calculate delta value

[hsiuming]

Hello

we now create a Visualize data table in kibana.

The content of the table is:

August 29th 2017, 13:56:49.121 0.063733000
August 29th 2017, 13:56:49.207 0.149665000
August 29th 2017, 13:56:49.291 0.233901000
August 29th 2017, 13:56:49.373 0.316168000

The first column is timestamp and the second is time value.

If i want to calculate the delta value in the third column,for example:

August 29th 2017, 13:56:49.121 0.063733000 0.063733000
August 29th 2017, 13:56:49.207 0.149665000 0.085932000
August 29th 2017, 13:56:49.291 0.233901000 0.084236000
August 29th 2017, 13:56:49.373 0.316168000 0.082267000

How can I do this calcuation in Visualize data table or can any other tool do this calculate?

I can not do it on timelion.

The interval of timestamp is millisecond but the minimun offset parameter is 1 second.

Thanks.

[Stacey_Gammon]

Have you tried creating a scripted field and adding that into the data table? That should work.

I tried to see if I could do this in the Time Series Visual Builder because it handles calculations like that, but the markdown doesn't support tables yet(https://github.com/elastic/kibana/issues/14436), so I don't think it'd have what you are looking for.

[hsiuming]

Thank for your reply.

What I want is the delta value in the same column.

This function seems only can calculate the value between two column.