Beast Mode - Color Coding

MThebeau

I am trying to do a beast mode with HTML code for if the Variance > Schedule, then make it red.

The hiccup I am running into is that Variance and Scheduled are both already beast mode calculations, not natively in the ETL. So how can I do the HTML coloring beast mode case when statement when both items are beast mode calculations themselves so that I keep the calculations in there to still have Variance calculated properly?

Any suggestions?

MarkSnodgrass

You would just expand your beast mode to include the logic to color your values

Here is an example of how you would do your variance beast mode:

CONCAT('<div style=color:',
CASE WHEN SUM(NumberOfVisits) + SUM(Activities) > 0 THEN 'green'
ELSE 'red'
END,'>',
SUM(NumberOfVisits) + SUM(Activities),
'')

MarkSnodgrass

You would just expand your beast mode to include the logic to color your values

Here is an example of how you would do your variance beast mode:

CONCAT('<div style=color:',
CASE WHEN SUM(NumberOfVisits) + SUM(Activities) > 0 THEN 'green'
ELSE 'red'
END,'>',
SUM(NumberOfVisits) + SUM(Activities),
'')