You can create conditional formatting rules based on if conditions. To create a rule, select theNew rule option from the menu. The Conditional Formatting side pane opens on selecting this option.
Creating comparisons
You can create custom comparisons using the dropdowns in the If section.
Creating CF rules
i) The first dropdown lists all the measures and dimensions in the visual.
ii) The second dropdown lists the equality conditions like Greater than, Less than, Greater than or equal to, Is between, or Not equal to.
iii) The third dropdown has different comparison options:
Number: You can create numeric comparisons that compare a measure/dimension with a threshold value.
Numeric comparisions
Value: You can compare a measure or dimension with another measure or dimension.
Comparisons with other measures/dimensions
Calculation: Define a basic mathematical formula (addition/subtraction/multiplication/division).
Sample calculations are depicted in the images below.
Condition to check whether AC < 20% of PY
Condition to check whether AC < PY + 10m
Analytics: Compare a measure with the average value of the measure.
