date sort

[#1]

I am not able to sort this chart-

I have tried every possible option but not able to do

[miguelbraga]

Hi Sesa Stone,

How do you want to sort?

Regards,

MB

[sunny_talwar]

try the following sort expression:

=Date#(YourDimensionName, 'D-MMM-YYYY')

[jonathandienst]

This is probably because the X- axis field is a string field and not a date field. With that date format, you cannot easily sort the strings.

Convert the field to a date field during the load:

     LOAD...

          myDatefield as strDateField,

          Date(Date#(myDatefield, 'd-MMM-yyyy')) As DateField,

          ...

Then use DateField  as the dimension and sort numerically. Change the field names to suit your document.