Sorting Axis for dual plots

[alex-wb]

Hi All,

I have plotted two 52 week periods that role every time a new week is started.  The code for it is

Current 52  week period:

Count({$<Fault_Received_Day={">=$(=WeekEND(max(Fault_Received_Day),-105,))<=$(=WeekEND(max(Fault_Received_Day),-53))"}
>}Fault_Ref)

Previous 52 week period:

Count({$<Fault_Received_Day={">=$(=WeekEND(max(Fault_Received_Day),-105,))<=$(=WeekEND(max(Fault_Received_Day),-53))"}
>}Fault_Ref)

The axis plot is Week(FAULT_RECEIVED_DAY) As FR_Week,

I can't seem to sort the calendar to be in the correct order which would be 47,48,49,50,51,52,1,2,3,4 and I also want to reduce it to just 52 weeks. Is this something I will need to fix in the data load editor?

Thanks,

Alex