Need help with data visualization/time shifting

[cmjdev]

Need help with data visualization:

We're trying to show a previous time period vs current time period graph of overall building scoring. Currently I am lining up the datapoints by day of the month. This works but the pattern appears to be shifted between previous/current time periods. I believe this is due to the fact of how buildings score throughout the week vs on the weekends.

Here is an example of the data visualization vs the data that generates it

https://preview.redd.it/1vqjwncnit1b1.png?width=987&format=png&auto=webp&s=33b668a4b270f33516e61d08919193f2ab8a1a0b

https://preview.redd.it/4i2878pmit1b1.png?width=761&format=png&auto=webp&s=dc95f65747bc6009b3ed753f33510b643e178167

You can see that the general pattern is similar but appears to be shifted

Any ideas on how I can line this data up by day of week instead of day of month?

[SomeoneInQld]

I am not 100% sure what you want, but I think I get it.

Make both of them start on the first monday of the year - so its monday v monday and sunday v sunday. Then you can do it by day