Enhancement Proposal: Logical operators and multiple conditions in conditional formatting

Hi,

I have a proposal on workshop/OMAs conditional formatting that would give us more flexibility into guiding our users to the “points of attention”. Happy to hear the thoughts of the community if you encounter the same! :slight_smile:

Background: Color coding cells in tables and pivot tables is a great way to guide user to points of attention. However, with the current abilities at hand when creating the conditional formatting, we struggle to make the color coding as explicit as we would like to have it.

Example: Imagine a pivot table with YoY growth in value and percentage per customer - product. The conditional formatting I would like to implement shall check two conditions. Currently the conditional formatting allows only one or the other. If I just base it on the Growth in €, big customers will have more false-positive highlights as it is super easy for them to get a 1M growth. If I only base the formatting on the % small customers/products will have many false-negative due to their natural fluctuation. So in the end I would like to define:

if (Growth in € > 1M AND Growth in % > 10%) → Then green

Proposal: when setting the conditial formatting in OMA or workshop (tables, pivot table, metric card etc), I would love to be able to set multiple conditions and combine them with logical operators like AND/OR. We are already able to select other properties or even aggregates within a pivot. Just let us connect them smartly with a few logical operators :slight_smile: In fact, I am looking for the same capability as when defining the policy on a restricted view.

2 Likes