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.
| Scenario |
id |
s_seq |
s_date |
r_seq |
r_date |
| 1 |
c1 |
1 |
1-10-2022 |
1 |
4-10-2022 |
| 2 |
c1 |
2 |
6-10-2022 |
2 |
8-10-2022 |
| 3 |
c1 |
3 |
11-10-2022 |
3 |
15-10-2022 |
| 4 |
c1 |
4 |
19-10-2022 |
|
|
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)
