html table conditional formatting

Sbhatia
Sbhatia Member
in Beast Mode

Hi, I have a table that I would like to format so that anything over 0 is red and less is green. I have created the beast mode below but I am not sure how to amend it so that the result is a percentage that also creates a total in the total row rather than a count


CASE WHEN (sum(Visits last week) -sum(Visits 2 weeks ago))/ sum(Visits 2 weeks ago)

0

then concat('<div style="color: #ff0000">',(sum(Visits last week) -sum(Visits 2 weeks ago))/ sum(Visits 2 weeks ago) ,'</div>')

else

concat('<div style="color: #00ff00">',(sum(Visits last week) -sum(Visits 2 weeks ago))/ sum(Visits 2 weeks ago) ,'</div>')

end

image.png

Any help appreciated!

Answers

  • MichelleH
    MichelleH Coach

    @Sbhatia The reason the total is showing a count is because the actual calculation is occurring within the CONCATs in your case statement, which means the that "Visits vs Prior Week Colour" field has a string datatype. If you want to conditionally color the column and have a total row, I suggest using Domo's built-in color rules on the beast mode below:

    (sum(Visits last week) -sum(Visits 2 weeks ago))/ sum(Visits 2 weeks ago)
  • Sbhatia
    Sbhatia Member

    Thanks Michelle, I am not sure how to use the built in colour rules on a beastmode, how does that work ?

  • Sbhatia
    Sbhatia Member

    I have figured this out, thanks so much for your help

Categories