BusinessObjects Board

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

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.


Afreen (BOB member since 2016-10-25)