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

HI .,

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


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

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