HTML to color cell green or red

ColinHaze · 2023-12-12T17:17:04+00:00

There was an error rendering this rich post.

Hi,

I am using a pivot table and I am trying to color the cell either red or green if its greater than the goal %.

I just need help with the HTML on how I would do that. Would I write it in a beastmode?

The following code I have is as followed.

CONCAT(CASE WHEN ((SUM(Empty Miles) / SUM(Total Miles)) > AVG(Goal)) THEN '*This is the spot for red*' ELSE '*This is the spot for Green* ' END, ROUND(100*(SUM(Empty Miles) / SUM(Total Miles)) ,2), '%')

Thanks in advance.

Find more posts tagged with

Accepted answers

GrantSmith

I've written up a post about this previously here:

https://community-forums.domo.com/main/discussion/52684/domo-ideas-conference-beast-modes-conditional-formatting

It will go over the beast mode and have a video on it as well.

All comments

GrantSmith

I've written up a post about this previously here:

https://community-forums.domo.com/main/discussion/52684/domo-ideas-conference-beast-modes-conditional-formatting

It will go over the beast mode and have a video on it as well.