cancel
Showing results for 
Search instead for 
Did you mean: 

Set Conditional Formatting of cell Based on a Separate Measure

tsaho8
7 - Data Storage
7 - Data Storage

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)

tsaho8_1-1683642325257.png

 

1 ACCEPTED SOLUTION

Ido_QBeeQ
9 - Travel Pro
9 - Travel Pro

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

Ido_QBeeQ_0-1683708262804.png

 

View solution in original post

6 REPLIES 6

Benji_PaldiTeam
10 - ETL
10 - ETL

Hi @tsaho8 ,

Take a look at this post, it will probably help you with your use case.
IIf you need any further assistance or advanced capabilities over your pivot feel free to reach out,
we're always happy to help (: 

Paldi Solutions - Number #1 Sisense Plugins Developer 

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

Ido_QBeeQ
9 - Travel Pro
9 - Travel Pro

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

Ido_QBeeQ_0-1683708262804.png

 

tsaho8
7 - Data Storage
7 - Data Storage

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.

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

Ido_QBeeQ
9 - Travel Pro
9 - Travel Pro

@tsaho8 Your formula should look like this:

2000*[Overall Vol]/[Rank]