Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have added custom colors by expression to my bar chart. If my measure is 1 the customized colors effect the line chart, but if I have a staple, if my measure is > 2, the bars have only one color.
At the bars with the number 3, the first bar should be yellow and the upper one gray.
My expressions by color are:
IF(Status = 'finish', color1,
IF(Status = 'open', color2,
IF(Status = 'wait', color3))
Thank you for your help!
I would remove the 3 expressions and replace with count(Status).
Then add Status as a dimension
This will give a stacked bar chart.
You can colour by dimension or use your if formula that should work now
Can you attach the qvw
Hi,
if possible can you share qvf file?
IF(sum(mesure) = '1', color1,
IF(sum(mesure) = '2', color2,
IF(sum(mesure) = '3', color3))
hi, i have attached it.
i have now
I would remove the 3 expressions and replace with count(Status).
Then add Status as a dimension
This will give a stacked bar chart.
You can colour by dimension or use your if formula that should work now
This works. Thank you very much!