TAT

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: TAT

ychaitanya — Fri, 20 Apr 2018 19:04:57 GMT

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

Re: TAT

shiveshsingh — Sat, 21 Apr 2018 12:41:55 GMT

May be this?

You need to check the field names

date(floor(CLOSE_DT),'DD/MM/YYYY')-date(floor(CREATED_Date),'DD/MM/YYYY')

topic Re: TAT in QlikView

TAT

Re: TAT

Re: TAT