If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Sorting in a graph with Weeks of Year

Started by Neo310, 07 Apr 2022 09:16:04 AM

Previous topic - Next topic

Neo310

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!