Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all I want to calculate the TAT
closed order turn around time [TAT] based on transactions.
how can I get this? what is the best way to do this?
any sample ?
Thanks
Sony
We actually calculate TAT for a transaction based on the Status of the transaction and last modified time of the transaction.
Primarily we should have the SCD Type 2 implementation at dB Level for better implementation of TAT's
Secondarily we should identify the business case of calculating TAT based on your defined STATUS fields
Eg : 1 Transaction which has started at 1/1/2018 05:30:00 AM with it's status as OPEN
- When ever there is change in transaction Life Cycle we should have entries in dB the time of last modification and also the status modified.
and like that for all the status of transaction till it COMPLETE.
Now ,
if we need to calculate TAT for for Transaction Response .(i.e from transaction open to responsded)
We need to define the difference between the Time of transaction at open and Time of transaction where last modified and transaction STATUS as responded.
I have architect ed this for one of my client ,Hope this Helps.
Thanks
CY
May be this?
You need to check the field names
date(floor(CLOSE_DT),'DD/MM/YYYY')-date(floor(CREATED_Date),'DD/MM/YYYY')