Can we display YOY% over a line between bars in a Combo chart

[Anonymous]

Hi,

I have a combo chart to display sum(sales) for 3 years, stacked bars display sales and Line displays the total on the bars showing the trend. Can we display YOY% over the line between bars in a Combo chart?
Something like in the below chart, am using text boxes now but they are overlapping with the line and bars on selections.

Please suggest me a solution asap. Thanks!

Requirement:

[vgutkovsky]

Well, the simple answer is no. You can't display anything between the bars, because expressions are only shown for dimensions. The space between the bars doesn't correspond to a dimension, it's just white space. That said, there's probably a hack approach you could implement. See attached for a simplified example which should hopefully point you in the right direction.

Cheers,

Vlad

[Anonymous]

Hi Vlad,

I have attached my qvw to the original post, can you please help me implementing the approach you mentioned in your sample. It is kind of tricky with the data I have. I would really appreciate your help.

Thanks Much!

[Anonymous]

Chinnu let me try this. i think you called me for this i guess

[Anonymous]

swuehl‌ mrkachhiaimp can you please help. i wanted to bring this thread to your attention.

[Anonymous]

Yes Vinay, I called you for help with this issue.

I appreciate your help! Thanks!

[Anonymous]

I am working on the solution provided by Vlad. lets see if that works

[MK_QSL]

I haven't gone through this app but just looking the chart you can try this..

Add one more expression as Line

((sum({<SPENDTYPE = {'OTHER_GL','PAYMENTS'}>}SPEND/1000000)) - Above((sum({<SPENDTYPE = {'OTHER_GL','PAYMENTS'}>}SPEND/1000000))))/Above((sum({<SPENDTYPE = {'OTHER_GL','PAYMENTS'}>}SPEND/1000000)))

[Anonymous]

mrkachhiaimp

Bhai no luck i tried in the app.

[Anonymous]

Can you please help me fix this, users wants this to be fixed ASAP