I need to put some colors in a table chart
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
@samuelTrujillo, did totesmgoet's reply help answer your question?