Target Line In Stacked Bar Chart

amit_saini — Fri, 25 Aug 2017 07:27:47 GMT

Hi Folks,

I'm having stacked bar chart like below:

Now I'm trying to show Target line by AsOfMonth as per below mapping:

load * Inline [

AsOfMonth, Target

201701, 81.186

201702, 93.886

201703, 125.378

201704, 98.453

201705, 6.937

201706, 128.632

201707, 62.659

201708, 9.026

201709, 6.164

201710, 6.386

201711, 19.101

201712, 21.695

];

To do this I'm calling second expression as sum(Sales) ,but chart now looks like below:

But this is not what I'm looking for , I want same first stacked bar chart in addition target line.

Any suggestions how this is possible ???

Attached is sample qvw.

Thanks,

Re: Target Line In Stacked Bar Chart

Frank_Hartmann — Fri, 25 Aug 2017 10:14:26 GMT

see attached

hope this helps

vinieme12 — Fri, 25 Aug 2017 11:27:05 GMT

You will need to keep only one Dimension and add one expression for each stack item in the chart

only then can you have a separate line in a stack chart