SAC Overlap Line Charts?

[vitran23]

What's the best solution for overlapping 2 line charts where one shows a current 12 mo trend, and the other line shows a prior 12 mo trend? The issue I've ran into when using 2 separate line charts the data points don't line up.

[vitran23]

I've built in my BW query to KPIs. That does current year and prior year. Wasn't sure if it's something I wanted to do in SAC.

[PrathameshA]

Hope you are using correct calculation for Prior Year metric ?

Thanks,

Prathamesh

See sample below :

[vitran23]

I've built in my BW query to KPIs. That does current year and prior year. Wasn't sure if it's something I wanted to do in SAC.

Also the data I'm reporting on is only stored by month and not by day.

[VirginiaToledo]

Hi PrathameshA, Do you know if the color of one serie of data can be change? In Vitran23 example, as some value overlap, there is the possibility to change the number color´s to match the line color? Thanks!

[avsalynin]

vitran23

Have you tried with two axes?

[vitran23]

I have but the issue is it doesn't overlap and just makes a continuous trend line. Instead of having say 06/2020 - 05/2021 overlap 06/2021 - 05/2022 it just does a continuous line.