Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
choose presentation Color
IF(Match(sport='a','b'),red(),if(match(sport='e','f'),green()))
try
choose presentation Color
IF(Match(sport='a','b'),red(),if(match(sport='e','f'),green()))
try