Question Re: SAC line chart comparing multiple years in Technology Q&A

SAC line chart comparing multiple years

mwickman — Wed, 20 Jul 2022 12:29:56 GMT

Is there a way to compare multiple years within the same line chart so that I am showing months along the x-axis and each line represents a year? We want to visually compare results of previous years to current year to identify trends above/below previous year results. In other words, is there a way to stack the lines in the chart below? Thank you.

Re: SAC line chart comparing multiple years

SteffenHeine — Wed, 20 Jul 2022 13:09:41 GMT

Hi Michael,

you should be able to achieve this with the previous year calculation.

Click on your measure in the builder panel (...) and add a time calculation with previous year. Then you should see the last year (2021). Filter the chart on 2022. If 2020 is needed repeat on the previous year of the previous year.

Regards,

Steffen

Re: SAC line chart comparing multiple years

mwickman — Wed, 20 Jul 2022 17:28:48 GMT

Thank you! This worked. Ideally I could show the chart without the year to avoid any confusion but can apply other formatting to make clear.

Re: SAC line chart comparing multiple years

kocomandi — Thu, 23 Mar 2023 16:40:39 GMT

Hi

I am looking for displaying three time series above each other.
One for 2023 actual headcount, one for 2023 budget headcount, and one for 2022 actual headcount.

What kind of time calculations are u referring to?

Also, in my model, it appears that I cant choose more than one version for the data.

Thanks

Re: SAC line chart comparing multiple years

N1kh1l — Thu, 23 Mar 2023 16:50:10 GMT

kocomandi

In your case as version is also changing you might need to add restricted measure calculation with date and version. Refer to the instruction below.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/b09a71640ed340188992628ff79aeb48.html?locale=en-US

Nikhil

Re: SAC line chart comparing multiple years

kocomandi — Thu, 23 Mar 2023 18:51:40 GMT

Hm..not sure if that is the solution. My dimension is date, and when I select 2022 and 2023 the charts are not above each other. They are side by side.

Re: SAC line chart comparing multiple years

jlopezm — Mon, 28 Aug 2023 10:44:44 GMT

thank you for the question and the answers.

It worked for me.

Just for what it's worth, add the calculated indicator settings.

Re: SAC line chart comparing multiple years

Gyula_Patay — Fri, 24 Apr 2026 08:35:19 GMT

Looks a tiny bit different in the new UI but still very helpful.