Incremental reference line x+y

[vaisgaard]

Hi,

I can't get my head around doing a simple incremental reference line i QS.

Problem:

I have this dataset:

YearWeek   Actual
2019-01      125
2019-02      263
2019-03      352
2019-04      589
2019-05   785

I want to create a reference line with my target for performance. The target pr. week is 500.

I hope someone can help.

Best regards

Michael

[Vu_Nguyen]

Hi, can you  further elaborate how the incremental reference line should look like? If it's only about comparing weekly actuals against a fixed target per week of 500, then it's a fixed reference line with expression = 500 (see image below).

[vaisgaard]

Hi Vu,

Yes of course.

The  target shall increment by 500 every week. I hope that clarifies it.

Best regards

Michael