Help with Beast code to do color coding on the data..

ozarkram
ozarkram Member
edited April 2022 in Magic ETL

Hi All,

I am trying to do a color coding on two columns in my card (1 yr change % and 3 year change %) like below as in excel...Higher the percentage towards 100 and greater than 100 the brighter the red color and the lesser it is the lower the red shade and it should do it across two columns ...Can you please help me here..


image.png


Tagged:

Comments

  • ST_-Superman-_
    ST_-Superman-_ Coach

    Have you tried a Heatmap table card? You can use the chart properties to select the color theme as well as which columns in the table should have the colors. You also get the option to use the same scale for all columns, or a different scale for each column.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • ozarkram
    ozarkram Member

    Hi @ST_-Superman-_ : When I try to use the Heatmap table card the entire table changes to heatmap..Can you please let me know how to use it for the two specific columns and then display the values along with the color..

Categories