5 Replies Latest reply: Oct 21, 2015 5:57 PM by Marco Wedel RSS

    Sorting a concatenated dimension

    ria Desai

      Hi,

       

      I want to sort a concatenated dimension in a line chart.

       

      eg:

       

      i have date and Id column which i have concatenated in the script as date-ID

      10/21/2015 - ABC345

      10/22/2015 - RTU123

      10/23/2015 - THYUNV

      and so on.

       

      When i display a line chart on x axis i have this date-ID column and some qty on y axis.

       

      I want the dates to be sorted from lowest to highest date-ID based on date values. How do I sort it?

       

      Any help is appreciated.

       

      Thanks