Hello,
i need to calculate dynamically return column, but i don't know if we can get this with kibana:
formula column return = value (today) / value(yesterday) -1
@timestamp account value return (column to calculate)
2020-10-30 A 20972.05 0.0000
2020-11-02 A 44017.80 1,0988
2020-11-03 A 18037.97 0,5902
2020-11-04 A 11723.38 0,3501
2020-11-05 A 21760.75 0,8562
2020-11-06 A 11256.97 0,4827
2020-11-09 A 52654.39 3,6779
2020-11-10 A 34066.16 0,3530
Best regards