Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below issue.
I am unable to apply colors to pie chart. ONLY able to apply single color.
Please help me on this when i show in auto or in color by dimension its showing like this only.
Thanks in advacne
This expression is working fine.
pick(mod(rank(TOTAL column(1))-1,5)+1 ,argb(255,189,0,38),argb(255,240,59,32),argb(255,253,141,60),argb(255,254,204,92),argb(255,255,255,178))
did you tried ?appearance--colors and legend --custom color by dimension
if not try with expression [instead of dimension]
if(type='value1',RGB(253,208,0),
if(type='valu2',RGB(169,169,169),RGB(0,0,0)))
Try this in color by expression :
ColorMix1( rank(total EXPRESSION ) / NoOfRows(TOTAL) , Color1, Color2)
This expression is working fine.
pick(mod(rank(TOTAL column(1))-1,5)+1 ,argb(255,189,0,38),argb(255,240,59,32),argb(255,253,141,60),argb(255,254,204,92),argb(255,255,255,178))