Color pivot table column using another column

user060355

I am trying to conditionally format the color of a column (% change). My chart has both revenues and costs. I want the color to be different depending on the category. If actuals are below the budget for revenue it should be red and if actuals are below the budget for the expenses it should be green.

I created a beast mode called "Color Logic" to help with the coloration:

```
CASE
-- Income is bad when Actual < Budget (negative variance)
WHEN Level 1 Description = 'INCOME TOTAL' AND Actuals < Budget THEN -1

-- Expenses/COGS are good when Actual < Budget (positive variance)
WHEN Level 1 Description IN ('Expenses', 'COGS') AND Actuals < Budget THEN 1

-- Income is good when Actual >= Budget
WHEN Level 1 Description = 'INCOME TOTAL' AND Actuals >= Budget THEN 1

-- Expenses/COGS are bad when Actual >= Budget
WHEN Level 1 Description IN ('Expenses', 'COGS') AND Actuals >= Budget THEN -1

ELSE 0
END
```

However when I make a color rule using this color, it only colors this column (which I don't even want on the able). I really want to color my "% change" column using the output of the beast mode. Is there a way to do this?

DavidChurchman

Sadly, no, not out of the box. You cannot color anything in Domo based on a different field. There is an idea similar to this posted in the idea exchange basically every month. Here's one, so feel free to upvote it (and the many others) or add your own idea to the void:

https://community-forums.domo.com/main/discussion/69222/enable-conditional-coloring-in-charts-based-on-another-column-or-beast-mode

Some options in the meantime:

You can add a second value to your pivot table, and color code that value, but that gets really busy/wide very quickly.

As a workaround, I have played with concatenating unicode characters for a pop of color based on conditions:

case
when Category = 1 and sum(Orders)/sum(sum(Orders) fixed(by week No.)) <0.05 then concat(sum(Orders), ' ', % of total, ' 🔴')
when Category = 3 and sum(Orders)/sum(sum(Orders) fixed(by week No.)) >0.1 then concat(sum(Orders), ' ',% of total, ' 🔵')
when Category = 4 and sum(Orders)/sum(sum(Orders) fixed(by week No.)) >0.5 then concat(sum(Orders), ' ',% of total, ' 🔵')
else concat(sum(Orders),' ',% of total, ' ⚪')
end

Originally shared in this thread:

https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482