Stacked Chart with Line Chart

[#1]

Hello,

I would like to stack three variables in a bar chart and then have a fourth variable as a line graph. I would also like this to be part of a cyclic group. Only one of the three variables in the stacked has a relationship with the fourth (line graph).

At the moment, I have "=$(=only(__DateVarianceField))" as the only dimension and this allows me to see the three variables versus date as a bar graph. I have attempted to add the fourth variable as an expression however this seems not to work. Any ideas please?

Thanks,

[chrislofthouse]

Can you upload a copy of the application

[#3]

I could send it to an email address if you can send me one?

It's about 52KB in size.

[chrislofthouse]

[#5]

I do not appear to have the option to 'use advanced editor'

[chrislofthouse]

Hi Mike,

You have to be in the actual blog post not from your inbox!

Click on the blog title to ensure you are redirected to the original blog!