Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 04, 2017 at 03:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.