Expression for average TAT(turn around time) calculation

manjunaths — Wed, 19 Oct 2022 11:07:14 GMT

Hi,

I hope someone can help me with this.

I have below scenarios. With this I want to calculate TAT(Turn around Time) for each scenario. I want to create a report for this TAT calculation.

I need output as below.(report selection is based on max(s_date))

* if i select date range between 1-10-2022 and 5-10-2022 then scenario 1 should not appear in the report.(report should not show any records)

*if i select date range between 1-10-2022 and 10-10-2022 then report output should be as below

id	max_s_date	max_r_date	count of id	Average TAT(latest s_date – previous r_date)
c1	6-10-2022	8-10-2022	1	2

*if i select date range between 1-10-2022 and 18-10-2022 then report output should be as below

id	max_s_date	max_r_date	count of id	Average TAT(latest s_date – previous r_date)
c1	11-10-2022	15-10-2022	1	3

*if i select date range between 1-10-2022 and 19-10-2022 then report output should be as below

id	max_s_date	max_r_date	count of id	Average TAT(latest s_date – previous r_date)
c1	19-10-2022	15-10-2022	1	3

To get the above outputs, I need two expressions.

1. Count of IDs

2. Avergae TAT( max_s_date-max_r_date)

Re: Expression for average TAT(turn around time) calculation

manjunaths — Fri, 21 Oct 2022 14:53:16 GMT

adding more information to the above question...

I have created a variable as below.

vTest=max_s_date-(if (max_r_date>max_s_date, max(prev_r_date), max_r_date))

Used this variable in the below Set Analysis to calculate TAT.

Avg({<[max_s_date]={">=$(=$(vNumSF)) <=$(=$(vNumST))"}>} $(vTest))

here $(vNumSF) and $(vNumST) are date selection variables.

Kindly anyone help? if above analysis is correct or not..

manjunaths — Fri, 28 Oct 2022 06:39:56 GMT

can anyone reply for this?