Configuring rules

You can create conditional formatting rules based on if conditions. To create a rule, select the New 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.

Analytics option for creating rules

Learn more about creating conditional formatting rules for charts.

Learn more about creating conditional formatting rules for cards.

Learn more about creating conditional formatting rules for tables.