I've been tasked with creating a trend line graph that goes back 52 weeks from the current date. I have created a concatenation of the year and week fields in order to sort the graph properly.
The problem is I have Jan 1, 2022 dates which are being grouped into 22-52 when it should be grouped as 21-52. Any ideas on how to get my graph to sort properly?
I know the week of year function is based on ISO and the week starts on the first thurs but surely this issue has come up before? Thank you in advance!