Hi Experts
Needed help with Stacked bar chart.
I have below table :
ColA Col2 col3 Col4 col5
S p1 INC1 0 1
S p1 INC5 1 0
S p2 INC2 1 0
S p3 INC3 0 0
E p4 INC4 1 1
E p5 INC5 0 1
O p7 INC6 1 1
O p8 INC7 1 0
I am using a bar graph with col1 x-axis and col2 stacked.
Measure as Count(col3).Coloring I am using col4 and col5 condition like
if(count(col4)=0 and count(col5)=0,green(),
if(count(col4)>0 or count(col5)>1,red(),
if(count(col4)=0 and count(col5)=1,yellow)
So a bar graph with colored stacked project is created but my requirement is all greens,yellows and reds should be grouped
current o/p
desired o/p
Can anyone help me to achieve this?