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?

Best Answer

  • jlazerus
    jlazerus ⚪️
    Accepted Answer

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

This discussion has been closed.