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