4 Replies Latest reply: Feb 12, 2014 1:35 PM by Henric Cronström RSS

    Sorting by date in a chart

    Richard Chilvers

      I have a chart which selects the most recent 7 days of activity, then uses the WEEKDAY function of those 7 days to produce values in the chart:

       

      I wish these to be displayed in date order. If today is Tuesday, the chart should (last) Wednesday through to today(Tuesday).

       

      I cannot get the sort to work; I have tried using the activity date as a sort expression.

       

      Apologies if a similar question has previously been answered.

       

      Thanks & Regards