Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Dante_83
Contributor III
Contributor III

Show Start & Stop date and Sum Actual Hours used base on Phase on a Table

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
Labels (2)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

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_brown_2-1661376897149.png

 

 

 

View solution in original post

2 Replies
BrunPierre
Partner - Master
Partner - Master

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_brown_2-1661376897149.png

 

 

 

Dante_83
Contributor III
Contributor III
Author

Peter,

 

Thank you so much for your help! The Expression work.