Creating Dimensions based on existing dimension and then colouring bars in a bar chat based off of i

[jacobcreek]

I have an existing dimension called sports that consists of sports: a,b,c,d,e,f.

the measure on the bar chart is called 'perc'. I would like to colour the bars of the bar chart by a new created dimension. e.g. i want the bars for a,b,c to be one colour, bar d to be another, and bars e and f to be another (3 colours in all). How do i go about doing this? and is it possible to display the dimension on the bar graph itself? i.e. say the new created dimension has values 1 (a,b,c), 2(d) and 3(e,f).

[Channa · Accepted solution]

choose presentation Color

IF(Match(sport='a','b'),red(),if(match(sport='e','f'),green()))

try