cancel
Showing results for
Did you mean:

# Set Conditional Formatting of cell Based on a Separate Measure

7 - Data Storage

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)

1 ACCEPTED SOLUTION
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

6 REPLIES 6
10 - ETL

Hi @tsaho8 ,

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
7 - Data Storage

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

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

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.

9 - Travel Pro

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

9 - Travel Pro

@tsaho8 Your formula should look like this:

2000*[Overall Vol]/[Rank]

Community Toolbox

Developers Group:

Product Feedback Forum: