Skip to main content

With display rules, I can customize visual styling for the content based on the cell value. However, I would like to use the comparator against another value.

 

In my specific example, I want to add priority symbols next to each PO number based on another attribute, for example the delivery date or net order value. For the latter, I want to define buckets and then map them into priorities that should be the value to compare against in the display rule.

 

You can think of the feature custom conditional formatting in Excel.

 

Is this possible?

 

Cheers

Irfan

Hi Irfan, thank you for your question.

 

Did you try adding different comparators to the same content rule ? eg comparator 1 says if step 1 then yellow, comparator 2 says if step 2 then red, etc...

 

That should do it because one display content rule consists of a list of comparators. 

 

28a7b0dc-3b73-4b00-8ad8-b62f7a9149fe 

Many thanks


Hi Mentor, thank you for your answer.

 

Could you please elaborate further? I'm not sure I understand you completely.

Do you mean that I could also use PQL or attribute IDs as comparators?


In the example on your screenshot, the display rule is not comparing against another attribute or KPI, rather than against fixed hard-coded values


Hi! I am also interested in this question. I have the same request what was mentioned by Irfan Suriaganda. I would like to use display rule to compare a KPI with another KPI. I tell the truth I hardly imagine such a business case when I compare a KPI with fix (harcoded) value.

As I remember this feature is available in process analytics. But I would like to use it in View.

example:

  - id: disp_rule_e2e_int_hour_01

    displayName: Display rule test

    customAttributes:

      - comparator: GREATER_THAN_OR_EQUAL

        KPI: sum_plan_effort_as_quoted

        style:

          textColor: red

          backgroundColor: black


Hi @mentor.vucit , any updates on this?

 

@purszki.sándo explained it very well what I am trying to achieve


My temporary solution was to create a new column representing the ratio of two KPIs. After that I could bind the display rule to constant numbers. The disadvantage of this is that it is an extra column and I could not color more than two KPIs within a column. example: KPI1/KPI2 <0.9 then red background color and KPI1/KPI3 > 1,2 then blue text color.

image.pngimage.png


Hi @irfan.suria12 

 

Display rules only accept static values at the moment. Does @purszki.sándo''s temporary solution worked out for you ?


Unfortunately not, as in the given example, a completely new KPI (ratio) was color coded instead of an existing KPI.

But okay, then it does not work at the moment.


Reply