1 Reply Latest reply on Nov 15, 2018 12:15 PM by Shreyas Swamy

    Sorting Month/year Date format.

    Aloysius Goh
      Share:|

      Hi all,

       

      Currently facing an issue of sorting the date of Month/Year.

       

      What I have done is that I have concatenated the Month/Year field. I have sorted my month field to be in Calender order by listing January as A , February as B and so on..
      The problem now that i face is that after i concatenated the fields. December 2017 appears after January . Could anyone provide a solution for this? Thanks

      Best Regards,
      Aloysius

        • 1. Re: Sorting Month/year Date format.
          Shreyas Swamy

          1. Create a 'Year' calculated field of the desired date object using predefined function Year, ARJDBC and ensure it is a Metric (ex: 2018, 2017..)

          2. Create a 'Month' calculated field of the desired date object using predefined function Year, ARJDBC and ensure it is a Metric (ex: 11, 5...)

          3. Add these 2 calculated fields to the report columns and hide them if not required

          4. Go to Report Formatting --> Table Sort and select these 2 fields to sort the data set in required order.

          2 of 2 people found this helpful