Forum Discussion

tsaho8's avatar
tsaho8
Cloud Apps
05-09-2023
Solved

Set Conditional Formatting of cell Based on a Separate Measure

Hi Angelina_QBeeQ ,

I want to set color(red & green) of Rank cell based on Overall Vol measure.

if Overall Vol>2000 then Rank cell will be Red else Green.

Logic of Overall Vol is Count(call)

 

Data Models
  • Ido_QBeeQ's avatar
    Ido_QBeeQ
    05-10-2023

    Hey tsaho8 it's great to see you're tagging Angelina_QBeeQ and  the QBeeQ team, keep it up! We're very happy to help the Sisense community!

    To do this you need to take the Rank function into consideration into the conditional formatting calculation of the Overall vol, and move it to the other side of the equation. You need to color Y according to X, if X is above or 2000:

    What you need - X>2000

    What you have is Y static on the left hand side of the equation, so you need to multiply by Y and divide by X:

    Y>(Y/X)*2000 => Y/Y>(Y/X)*2000/Y => 1>2000/X => X>2000

    See screenshot and attached dash file

    Always here to help 🙂

    Ido 

    [email protected]

    QBeeQ - Gold Implementation & Development Partner

     

6 Replies

Replies have been turned off for this discussion
  • Ido_QBeeQ's avatar
    Ido_QBeeQ
    ETL
    05-10-2023

    Hey tsaho8 it's great to see you're tagging Angelina_QBeeQ and  the QBeeQ team, keep it up! We're very happy to help the Sisense community!

    To do this you need to take the Rank function into consideration into the conditional formatting calculation of the Overall vol, and move it to the other side of the equation. You need to color Y according to X, if X is above or 2000:

    What you need - X>2000

    What you have is Y static on the left hand side of the equation, so you need to multiply by Y and divide by X:

    Y>(Y/X)*2000 => Y/Y>(Y/X)*2000/Y => 1>2000/X => X>2000

    See screenshot and attached dash file

    Always here to help 🙂

    Ido 

    [email protected]

    QBeeQ - Gold Implementation & Development Partner

     

    • tsaho8's avatar
      tsaho8
      Cloud Apps
      05-10-2023

      Hi Ido_QBeeQ ,

      You have written formula in the condition section(referring image) but how it will compare.

      In my case Overall Vol logic I can put but how will compare with 2000?

      Could you please make it more simpler.

    • zohebakber's avatar
      zohebakber
      Cloud Apps
      09-13-2023

      Hi Ido,
      I am very close. However, this work around fails when value of X=0

    • tsaho8's avatar
      tsaho8
      Cloud Apps
      05-10-2023

      Hi Benji_PaldiTeam ,

      This post won't help me because we need to provide the condition with another measure like below.

      if Overall Vol>2000 then Rank cell will be Red else Green