Heatmap Shows Duplicate Rows

Reply
Yellow Belt

Heatmap Shows Duplicate Rows

I'm on a roll with asking questions here so I figure I'll keep going. I'm trying to create a heatmap to show the number of hours by group for a large set of projects but I'm running into an issue where the project name is creating a duplicate line for each group that has hours in the project. See example below.

Screen Shot 2018-08-08 at 11.36.02 PM.png

 

 

 

 

 

Or Screen Shot 2018-08-08 at 11.35.27 PM.png

 

 

 

 

 

 

 

The columns currently missing hours are ones I just haven't added yet. I'm getting the columns from the groups by a beast mode that looks like this and using each one as a column.

(CASE WHEN `GROUP` LIKE 'Network Engineering' THEN `Proposed Hours` END)

 

 

Any thoughts on how to get these to show up on a single row for each project name?


Accepted Solutions
Highlighted
Yellow Belt

Re: Heatmap Shows Duplicate Rows

Okay so I just realized that I could run my dataset through another ETL and uncollapse the columns which in turn solves my problem.


All Replies
Highlighted
Yellow Belt

Re: Heatmap Shows Duplicate Rows

Okay so I just realized that I could run my dataset through another ETL and uncollapse the columns which in turn solves my problem.

Announcements
New to Dojo Please update your Dojo handle and personal settings. Click here!