Thanks @FixTestRepeat let me describe with details.
I’m looking for the table like this, I do not need any charts
Request name | TPS |
DELETE->Remove Specific Item | 10 |
GET->Get All Items | 20 |
TPS = (number of requests) / (total time)
number of requests → count of the items for the specific time range.
total time → the duration in seconds for the specific time range
The specific time range can be
- Raw total time. Why raw? → as a total time we are taking the 10 minutes (from user end it is difference between v.timeRangeStart and v.timeRangeStop)
For example in 10 minutes we have the data.
Request name | Number of requests |
DELETE->Remove Specific Item | 650 |
GET->Get All Items | 1200 |
So I need the final result table with calculation
total time in seconds → 10 min * 60 = 600 seconds
Request name | Number of requests/Total time |
DELETE->Remove Specific Item | 650/600 |
GET->Get All Items | 1200/600 |
- Exact total time. As a total time we are taking the difference between two date time points
Total time = last request "_time" - first request "_time".
Further more, for both cases (1 and 2) total time we need to convert duration to seconds and then to int → to have the possibility to do math deviation.
Any option (1 or 2) is acceptable.
So I do not see the huge complexity here at the first look. The problem that I’m not really understand now to implement the “total time” calculation and type conversion (duration to seconds to int) to have the proper math. One again, the goal is to have one query to build the table.
Hope now I described more clear, many thanks.