Hello! I am currently trying to make a grouped bar chart that is also stacked. In this scenario I want to compare our power and core members and within those groups how many of each are a website client with us. If they are a website client, I want that bar to be stacked to show what type of website that member has.
This is what I get when I do a simple group chart and use Website Client (True/False) as the series. If I change the chart type to "Grouped + Stacked" I get one series field option so I just dropped the Website Type over the top of the Website Client field and got this:
This looks how I want the chart to look except the values completely changed. For reference, 186 on the top picture now says 100 on the bottom. Is this an impossible task or is there possibly a better way to do it?
Thanks in advance!