1 Reply Latest reply on Jan 30, 2017 11:33 PM by user19752

    date sorting for a chart

    rubinjm

      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)