Combo chart with Stacked Bar

[Anonymous]

Hi All

I have a stacked bar chart which shows values by customer by week.  I want to add a line graph to compare the total value by week for the previous year.  If I do a combo chart it won't let me choose stacked as an option for the bar chart, and if I have customer as a dimension the line chart is wrong.  Is there a way around this?

Thanks

[prat1507]

I know this won't sound good, but what you can do is a workaround, just add a copy of the chart you're using and change it to combo chart, add line graph and make the bars invisible and change the transparency of the background to 100%.

This may degrade your performance so use it wisely.

Regards
Pratyush

[vinieme12]

Just keep one Dimension

and add separate expressions for each stack element

add you expression for the line and change it 's Axes to [right (top)  : or different for what you have for the stack bar chart expressions]

that is it!