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