Customizing specific background colors in a discovery - Version 2020.16.031

Hi Yolanda

Your scenario sounds like this would be best addressed by applying value driven colors using a formula to provide the logic.

This approach is described here 

I have created an example of the approach on our Explore Server so you can see it working in action

You can sign up to the Explore server environment with the link below

Pyramid Explore Server - How to Sign up

the example is found in this location

Link to the folder HOW TO: Value driven Color cells using RGB

The discover "Discovery - Conditional Color" looks like this

Conditional formatting has been applied to cell backgrounds based on Net Margin values: Purple (Net Margin > 35%), Blue (30% ≤ Net Margin ≤ 35%), Green (25% ≤ Net Margin < 30%), Yellow (20% ≤ Net Margin < 25%), Red (Net Margin < 20%).

Lets go through how we got here

For improved code readability, I defined variables to represent the colors, although this wasn't strictly required.

this is the formula for the 'Color - Red', I wont go through each one but I have created a formula for Yelllow, Green, Blue and Purple.

 more details on the RGB function can be found here  RGB (PQL) 

I then made a formula "Color Value" to return the color required to color a cell based on the value of the Net Margin. 

I used a case statement to evaluate each scenario and return the color measure that was required. 

Finally, I placed this metric onto the discovery grid in the color zone

this could have also been achieved by right clicking on the 'color value' chip and selecting  "edit color logic"

then 'value' > Color Format RGB

this may differ slightly  in 2020 where you will have to drop the color chip and select 'Custom Colors'

 

I hope this helps

 

thanks

Mark

Hi Yolanda Heldsinger

On top of Mark Oldfield 's answer, if you have a measure you want to color based on a values of a measure, you can do it like this:

On the grid you have, copy the HR_EFF measure to the color, then right click on the measure in the color and choose "color logic".

and define the color bands:

 

I think it may be the same with Pyramid 2020, it definitely works in 2023 and upwords.

Regards