Need help in calculating threshold (Transaction per second) based on relative interval time range in table

Grafana Elasticsearch
1

HI .,

using elasticsearch datasource am getting the data in grafana and displaying as table. like below

image
image1663×971 114 KB

I want to have new column as threshold to calculate Transaction per second based on relative interval time range in table.

can you please davise how to do it

2

I manage to get this TPS calculation based on relative time change thanks

Using Query option in Panel and then with filter and Add field from calculation thanks

3

Can anyone share in depth solution on this?
I am having the same requirement.