Last x Weeks compared to same periods PY

Hello @FelixPlatora, I completely understand your frustrations and I hope I can be of assistance. I actually am helping another user through a very similar situation where they are trying to show the comparison between data from 2 different years on a line graph where they are side by side, rather than one after the other. I’ll link that topic here in case it provides some information that will help you understand how we need to craft this solution.

Basically, you will want to use some sort of string naming convention that will allow us to group the dates so they will show as something like “This Year” and “Last Year”. Then, we can use the addDateTime function to convert our previous year’s data to this year. Then both of those metrics can be charted over the same 5 week period, and the string field value will display them on separate lines in the visual. Let me know if you have any specific follow-up questions on implementing this with your data, but I hope this helps get you started!