Beast Mode

MThebeau · October 2023

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 · October 2023

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 · October 2023

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),
'')

Beast Mode

Beast Mode - Color Coding

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories