Forum Discussion

lwhal's avatar
lwhal
Frequent Visitor
5 years ago
Solved

Help with Heatmap in a matrix visual

Hello,    I am hoping someone can help me with a solution to my problem. I was asked to use a matrix to create a heatmap. I have done it before but this particular report is displaying the data and...
  • lbendlin's avatar
    lbendlin
    5 years ago

    Two comments:

     

    You can simplify your logic like this

    Maturity color = SWITCH(SELECTEDVALUE(years[maturity]),
    "2" , "#AED6F1",
    "1" , "#85C1E9",
    "#5DADE2")
     
    But this will still not help you with the cells where there is no "SELECTEDVALUE"  (missing data).  For that you may need to create dummy data points (via a cross join)  or use a fake matrix background color set to  #5DADE2.
lbendlin's avatar
lbendlin
Super User
5 years ago

Two comments:

 

You can simplify your logic like this

Maturity color = SWITCH(SELECTEDVALUE(years[maturity]),
"2" , "#AED6F1",
"1" , "#85C1E9",
"#5DADE2")
 
But this will still not help you with the cells where there is no "SELECTEDVALUE"  (missing data).  For that you may need to create dummy data points (via a cross join)  or use a fake matrix background color set to  #5DADE2.
  • lwhal's avatar
    lwhal
    Frequent Visitor
    5 years ago

    Thank you so much it worked great.