5 Replies Latest reply: May 28, 2013 4:20 AM by Jasper Brosens RSS

    Sort issue with bar chart and display results in "=Day & ' - ' & Month"

      My default date format = DD-MMM-YYYY (01-Jan-2010.

       

      I Have a Calendermaster table with:

      %Calenderday (DD-MMM-YYYY)

      Year

      Month (Jan-Dec)

      Week

      Day

       

      Now i want to show my result in a bar chart with "=Day & ' - ' & Month" between a date. This is working so far. But now i have a problem with Sorting the results.

       

      On default i get these results:

      1.jpg

       

      i tried expression sorting on "=Day".

      This works when there is not a bigger timespan selected then 1 month. But when there are more months selected, you see the results like this

      2.jpg

       

      I also tried sorting on "=Day & ' - ' & Month" But then i get results like this

      3.jpg

       

      I even tried sorting on %Calenderday. But then the results look like this

      4.jpg

       

      Some advice is welcome here

       

      Thanks a lot!