Comparing a specific week to the corresponding week of the previous year

Hello @Phillip_Le

I think the problem here is that the weeks don’t line up exactly year over year. So using week number would be a better way to do this.

I’m currently trying to create a potential work around for this that uses weeknum() which isn’t a listed funciton in Quick Sight but does work.

In the mean time, you could create an arena link that would help troubleshoot this.