Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want to create a chart like this:
I think i could create this with a stacked bar chart.
But i dont know how to apply different colors according to being above/below plan value.
Does someone has already implemented something like that?
Phil
Three expressions in a stacked bar chart:
=Rangemin(sum(Expression3), vThreshold)
=if(sum(Expression3)>vThreshold, sum(Expression3)-vThreshold)
=if(sum(Expression3)<vThreshold, vThreshold-sum(Expression3))
See attached sample qvw
Maybe like attached?
Two expressions in a stacked bar chart:
=Rangemin(sum(Expression3), vThreshold)
=if(sum(Expression3)>vThreshold, sum(Expression3)-vThreshold)
Hey thanks guys! That really helps me.
But how can i change the expression to geht it in another color if its below plan?
Could you post your sample qvw ?
Open the expression attributes of the first expression by clicking on the small plus sign next to the expression label on upper left corner of expression tab.
Then edit the background color attribute expression:
=Black()
Three expressions in a stacked bar chart:
=Rangemin(sum(Expression3), vThreshold)
=if(sum(Expression3)>vThreshold, sum(Expression3)-vThreshold)
=if(sum(Expression3)<vThreshold, vThreshold-sum(Expression3))
Hi,
PFA,
For Line and Mutlicolored Stacks .
I hope this Helps,
Regards,
Hirish.
Hi Jonathan,
thats the right answer!
Thanks alot!
Phil
Got another requirement.
So far it looks like:
If I select more than one Year it looks like:
How can i get this to show grouped? I guess thats not possible?
At the moment ive got one expression for each year.