Conditional formatting based on user-configurable thresholds

Conditional formatting only supports hard-coded values.
Looking for a feature to create “traffic lights” icons (red / amber / green dots) based on user-configurable thresholds. Is it possible to do this?

Hi @Jelena -

You can place the “traffic light logic” in calculated fields and use the conditional value as the switch.

Here is an example.

Step 1 - Create 3 Parameters for your Configurable Thresholds.
image

Step 2 - Create a calculated field for the threshold logic/color.
c_color

ifelse({c_greatest} >= ${pGreen},1,
{c_greatest} >= ${pYellow},0,
{c_greatest} <= ${pRed},-1,
null
)

Step 3 - Create Conditional Rule for 1,0,-1 values

Result:

4 Likes