Dynamic Vertical Line on 100% stacked bar chart- SAP Design Studio 1.6

[former_member544949]

Hi Experts,

I am using SAP Design studio 1.6 and BEX queries as a backend.

I have to develop a dashboard in which I need to draw a vertical line on 100%stacked bar chart. The line should be drawn on 15% of the 100% stacked bar chart. This 15% value is coming from the backend BEX query (because this percentage could be changed in the future)

I am not sure how to get 15% of the 100% stacked bar chart, so I can draw a vertical line on it.

The 100% stacked bar and the 15% value (coming from the backend ) are using different queries.

1. Is there any solution using one query?
2. Is there any solution using two queries ? One for the stacked chart and one for the vertical line ? will using Combined 100% stacked bar and line chart solve the problem ?

Any help will be appreciated!!!

Thanks.

[TammyPowlas]

Hi -

On question 1, are you trying to use a reference line?

I recommend searching; please see this https://archive.sap.com/discussions/thread/3748888 and Karol's reply

[former_member544949]

Thanks Tammy for your quick reply. Yes, I need to use the reference line , which will be relative to the 100% stacked bar chart. I searched the link, it says, the solution is using BEX Analyzer. I don't need to use this.

I can get the relative value (which is 15% in this case) from one query, but is there any way to get where on the screen the 15% of the chart exist? so I can set the left margin of the line relatively.

Please let me know if you need more detail.

Thanks.