Heatmap Shows Duplicate Rows

jlazerus

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.

 

 

 

 

 

Or 

 

 

 

 

 

 

 

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?

jlazerus

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