Hello Team,
I have the list of Order IDs and each Order Id has 3 unique statuses NEW/IN PROGRESS/CAPTURED or DECLINED
Could you please help me to calculate:
- AVG time in SEC and MSSEC from NEW status to COMPLETED or DECLINED for exact Order ID?
- AVG time in SEC and MSSEC from NEW status to COMPLETED or DECLINED for all trx in general?
- Max time to approve trx (from NEW to CAPTURED or DECLINED)
- Min time to approve trx (from NEW to CAPTURED or DECLINED)
- How many trx have IN PROGRESS for more than 5 seconds
Thank you in advance!