How I can put Colors in a Table Chart

samuelTrujillo

I need to put some colors in a table chart

totesmgoets

Hi there,

 

I believe you can use case & some html to do this. Here's a beastmode with % examples for you, switching out the `case #` for your arguments.

 

Case 
	When `case 1`THEN CONCAT('<div style="background-color:#fcbcb7; font-weight: bold; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', CONCAT(ROUND((`case 1`*100),2),'%'), '</a></div>')
    When `case 2` THEN CONCAT('<div style="background-color:#fccf84; font-weight: bold; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', CONCAT(ROUND((`case 2`*100),2),'%'), '</a></div>')

    ELSE CONCAT('<div style="background-color:auto; font-weight: normal; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', CONCAT(ROUND((`case 1`*100),2),'%'), '</a></div>')

END

 

kshah008

@samuelTrujillo, did totesmgoet's reply help answer your question?