Skip to Content
0

Dotted line in chart for forecast values for upcoming months

Feb 05 at 07:39 AM

47

avatar image
Former Member

Hi,

I would like to show dotted lines for forecast for upcoming months.

for example: Current month is 08.2017.

As Is clear – blue one. We would like a dotted line for the forecast part of the line- means for month 9-12.

Please refer to the attached snapshot.

Note: I am using SAP Lumira desinger 2.0

Thanks

Palanivel

chart.png

chart.png (25.5 kB)
10 |10000 characters needed characters left characters exceeded

Do you have separate measures for actual and forecast ? Or, do you have a dimension to separate actual and forecast ? Could you please share a screenshot of the initial view of your data source ?

0
Former Member

Hi Arijit,

Yes,I do have separate measures for actual and forecast.Please find the snapshot of initial view.

Thanks

Palanivel

capture.png

capture.png (11.0 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Arijit Das Feb 05 at 03:01 PM
0

I tried to replicate similar scenario:

If I have my data as below:

and I use dotted line for forecast:

Then my chart looks like:

Now, if you can tweak the BEx query to use some calculation for forecast to show the data as below:

Then the chart will look like:


capture0.png (14.8 kB)
capture2.png (12.9 kB)
capture3.png (7.0 kB)
capture4.png (14.6 kB)
capture5.png (7.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

HI Arijit,

Yes you are right,if we have data for forecast as you suggested ,will achieve this.But they want it in single line (part of line and part of dotted line)

Thank you!

Thanks

Palanivel

0