I have forex information for each day. Close, Open, Low, High.
Now, I would like to calculate the difference in % between a point in time, lets say today (t0), and the day before (-t1). That is: (|t0-t1|/((t0-t1)/2))*100
Are there any "inter record" functions to use for this in Kibana? How can I "fetch" a value from another row?
I would like to display this data in a table per day. So each row would have the data for that date but also the calculated fields.
Desired result: Date, Open, Close, High,Low, % Diff 2017-08-01, 10, 11, 13, 9, 10% 207-07-31, 9, 10, 12, 8, x%