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.
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:
5 Likes