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)

Outcomes