Graph Formatting of Rolling 12 Week Data Over Week 52

[JoeHodgetts]

Hi All,

I have to use Alteryx 2018 for an app on the gallery as this is what our servers use, so consider this version on response.

I have a rolling 12 week graph which displays 'Week Numbers' on the x-axis and 'Volume' on the y-axis. There is another field 'Relative Week' that is always in the range of 1-12 and set to 'descending'. The week numbers display as expected until data at the end of the year, and therefore starting from 1 come into play.

In the later versions of Alteryx, maintaining the 'Week Number' as a string and sorting data on a 'Relative Week' did the trick, but that doesn't seem to work now.

Actual Graph:

Desired Graph:

Thanks for your support.

Joe