Dear Friends,
Need your guidance to implement conditional palette on a bar chart as per the following scenario.
So I have a year data item with two values - 2013, 2014
I have two measures - Measure A, Measure B
I have another data item on X axis - ABC
So I am displaying the series as -
2013 Measure A, 2013 Measure B, 2014 Measure A, 2014 Measure B. Now I want to fix colors for all these 4 bars.
In the variable that I am using here , I am able to include and conditionally check the year. So for example -
case
when year = 2013 then green
else blue
But how to include the condition in the variable where I want to determine which measure is being used . So for example
Case
when (year = 2013 and Measure A or something) then green
when ( year = 2013 and Measure B or something) then yellow
when (year = 2014 and Measure A or something) then blue
when (year = 2014 and Measure B or something) then red
else none
end
So where I say "Measure A or something" can you please suggest a code or an alternate solution ?
Would be eternally grateful :)
Regards
Shuks