2 Replies Latest reply: Jan 24, 2018 1:45 PM by Jeremy Schmitt RSS

    Order by/Sort by Problems

    Jeremy Schmitt

      I am trying to get two fields in the YYYY-MMM formatting to sort newest to oldest without any luck. I format them as Date(MyDate,'YYYY-MMM')  but when I display it in a chat with a simple count of the data it duplicates the Year/Months...

       

      I also tried year(MyDate)&'-'&month(MyDateafter doing an "Order By' in the table below.... this works... but I have two dates I am doing this for. It of course only orders by the first one I list.

       

      Is there a sort expression I can use in the chart itself to sort by a date field? Sort By---> Expression----> Desc----> and maybe =MyDate or something?