4 Replies Latest reply on May 1, 2018 12:15 AM by Matthijs Blenkers

Comparing daily performance in two different time periods

Hi,

we have two periods that span across years, more specifically:

Period A: 1st September 2016 - 28th February 2017 (blue)

Period B: 2nd September 2017 - 2nd March 2018 (orange)

We would like to compare some key fields and calculations, so that we can visually locate any differences. How can we define the X-axis, so that we can show the time sequence and still have one curve on top of the other in the same graph? (something similar to the attached graph, but with one curve on top of the other).

Perhaps we could enumerate the days of each period, like 1, 2, 3, etc? But with which calculation can we do that?

Thanks,

Panos

• 1. Re: Comparing daily performance in two different time periods

Hi Panos,

You may want to look here for a similar problem (& a possible solution):

Hope it could help a bit.

Yours,

Yuri

• 2. Re: Comparing daily performance in two different time periods

Hi Panos,

Put discrete month (blue pill) en continous day (green pill) on columns.

Add discrete year (blue pill) to color.

The days of each month will overlap with a line for each year.

Is this what you are looking for?

gr.

Matthijs

1 of 1 people found this helpful
• 3. Re: Comparing daily performance in two different time periods

Hi Matthis,

your suggestion worked fine with a minor adaptation. With respect to color, I dragged the predefined times periods (instead of the discrete year) to color.

Thanks a lot.

Regards,

Panos

• 4. Re: Comparing daily performance in two different time periods

You're welcome.

Could you mark the question as 'answered' by selecting the correct answere?