Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Following is the table in my Data Model which may change this value at any time.
I'm using Bar Chart having multiple bars in which i want to use this range of color.
But i cant do it hardcore.because it may change at any time so i want to use variable.
How can i implement it at Background Expression? How implement it in Varibale?
Color | Value from | Value to |
---|---|---|
Green | 0 | 5 |
Amber | 6 | 95 |
Red | 96 | 100 |
Expression for Bar Chart are as follow
sum(total_exception)/sum(total_qty)*100
Hi sandy, maybe you can use this background expression:
If([ExpressionName]<=Only({<Color={'Green'}>} [Value to]), Green(),
If([ExpressionName]>=Only({<Color={'Red'}>} [Value from]), Red(), Yellow()))
Or create a variable with that content and this bg expression:
$(VariableName)
Change the Green(), Red(), Yellow() for the RGB() you want, and [ExpressionName] to your current expression name, if the name is also an expression you can use [$(CopyNameExpressionHere)]
Hi,
maybe one solution using variables for the 2 limits could be:
hope this helps
regards
Marco