is it possible to mix a grouped with a stacked bar chart?
Currently I'm using a grouped bar chart with one dimension and five expressions. One expression shall be changed to consist of two parts. I think the screenshot and the example qvw show it quite good.
Can you please check the app attached. It is little bit tricky. I have placed a chart over the other chart in step 1. But may be it will serve your purpose, otherwise their is no way to get grouped and stacked chart together.
thanks for providing this solution. Problem is, when I change the selected territory from 'b' to 'a', there is a gap between the two bar parts. Is there a way to solve this?
Check this one, it will solve the problem you are facing when selection is changed.
But that mouse-over problem can't be rectified, as it is underlying chart, you can't get the value on mouse-over.
I have made it, it looks the way I want to :-).
I had some help and ideas from a parallel thread, this can help others, too, hopefully:
Month was my only dimension, I then added a second one which I called BarType. The four single bars got a single entry in that field, the stacked bar a combined one and two expressions, for each part a separate one,
Only issues are now, that the order is not in the way I want it (Should be Offen, Verloren, Gewonnen, Soll and the stacked one), I have no solution yet, and the legend (Safe+Threat, TCV Open) that needs to be removed.