AnsweredAssumed Answered

date sorting for a chart

Question asked by rubinjm on Jan 30, 2017
Latest reply on Jan 30, 2017 by user19752

I have a chart that displays weeks along the X-axis. I need to have the date sorting go from July-June and it was displaying properly until Jan 1. Since then, January weeks are displaying at the beginning of the X-axis. How do I get them to display at the right end of the X-axis (after December)?


The field being used for the chart is

cweek =

Date(WeekOfYear(Respondents::date); 1 ; Year(Respondents::date))



the X-axis is

Respondents::week start & " - " & Respondents::week end



Chart sort order is by cWeek (ascending)