Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I want to show the [Start Date] & [End Date] and sum [Sched Hrs] & [Act Hrs] base on [Phase] name? Below is an example of my data.
Phase | Start Date | Stop Date | Sche Hrs | Act Hrs |
Induc | 07-May-2021 | 08-May-2021 | 4 | 5 |
Induc | 08-May-2021 | 09-May-2021 | 4 | 3 |
Induc | 09-May-2021 | 10-May-2021 | 4 | 4 |
Induc | 10-May-2021 | 11-May-2021 | 4 | 3 |
Induc | 11-May-2021 | 12-May-2021 | 4 | 5 |
Induc | 12-May-2021 | 13-May-2021 | 4 | 4 |
Induc | 13-May-2021 | 14-May-2021 | 4 | 3 |
Induc | 14-May-2021 | 15-May-2021 | 4 | 5 |
Induc | 15-May-2021 | 16-May-2021 | 4 | 3 |
Induc | 16-May-2021 | 17-May-2021 | 4 | 2 |
Inspect | 17-May-2021 | 18-May-2021 | 2 | 2 |
Inspect | 18-May-2021 | 19-May-2021 | 2 | 2 |
Inspect | 19-May-2021 | 20-May-2021 | 2 | 2 |
Inspect | 20-May-2021 | 21-May-2021 | 2 | 2 |
Repair | 21-May-2021 | 22-May-2021 | 10 | 13 |
Repair | 22-May-2021 | 23-May-2021 | 10 | 4 |
Repair | 23-May-2021 | 24-May-2021 | 10 | 10 |
Repair | 24-May-2021 | 25-May-2021 | 10 | 12 |
Repair | 25-May-2021 | 26-May-2021 | 10 | 6 |
Repair | 26-May-2021 | 27-May-2021 | 10 | 10 |
Test | 27-May-2021 | 28-May-2021 | 20 | 15 |
I want my table to look like the table below. Under [Phase], the Row Indoc, Inspect, Repair, and Test shows only the First [Start Date] and Last [End Date]. Also, the [Sche Hrs] and [Act Hrs] are sum. Does anyone know if this is possible? I really appreciate any help you can provide.
Phase | Start Date | Stop Date | Sche Hrs | Act Hrs |
Induc | 07-May-2021 | 17-May-2021 | 40 | 37 |
Inspect | 17-May-2021 | 21-May-2021 | 8 | 8 |
Repair | 21-May-2021 | 27-May-2021 | 60 | 55 |
Test | 27-May-2021 | 28-May-2021 | 20 | 15 |
Expressions
Start Date - Min([Start Date])
Stop Date - Max([Stop Date])
Sche Hrs - SUM({<Phase={'Induc','Inspect','Repair','Test'}>}[Sche Hrs])
Act Hrs - SUM({<Phase={'Induc','Inspect','Repair','Test'}>}[Act Hrs])
Output
Expressions
Start Date - Min([Start Date])
Stop Date - Max([Stop Date])
Sche Hrs - SUM({<Phase={'Induc','Inspect','Repair','Test'}>}[Sche Hrs])
Act Hrs - SUM({<Phase={'Induc','Inspect','Repair','Test'}>}[Act Hrs])
Output
Peter,
Thank you so much for your help! The Expression work.