Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me here.
We Have two tables like below
Table1.
From | To | ColorCode |
---|---|---|
0 | 100 | RGB(0,255,0) |
101 | 500 | RGB(255,251,122) |
501 | 999 | RGB(0,255,0) |
Table2.
MetricID | DrillDownGroup | value |
---|---|---|
1 | L1 | 50 |
2 | L1 | 50 |
1 | L2 | 45 |
2 | L2 | 45 |
1 | L3 | 60 |
3 | L3 | 60 |
I have a pivot table with Level(DrillDown Group) in Dimension and Value in Measure.
Background Color of the Measure should be from Table1 based Aggregated Value between From and To.
Level | Value |
---|---|
L1 | 100 |
L2 | 90 |
L3 | 120 |
Note: The Color should change in runtime because the Aggregated value will change drill down to next level.
Hi,
If there is no relation between your table , you can't directly give your range in the chart..
May be you can use the if condition in background expression.. Like
if(Value >0 and Value <=100, RGB(0,255,0))
Like wise other conditions..
Or in the backend , you can Aggregate your second Table,check your range using if condition, and create new color code field based on your range..