I have a scenario where i have to build a splunk form with time picker.
When user selects any custom time, i have to returns the "Transaction per second" value.
Avg. TPS = (Total Number of Transactions in the selected duration)/(Total time in seconds for that selected duration)
The problem is for the custom time selected how do i calculate how many seconds that it constitutes?
Please help me with this.