cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Sorting Data error

SOLVED
Highlighted
Meteoroid

Hello.

 

I have a date column I want to sort. Using the sort option I mark it as sorting descending and it does sort the years, but not the month or day. any ideas why?

 Capture.JPG

 

Alteryx Certified Partner

Hey @SorinDiaconescu

 

It sorted fine for me when I did a quick test!

 

Can you share some data?

Meteoroid

Here is a small sample. I cant share more.

 

Thanks,
Sorin

Alteryx Certified Partner

Hey @SorinDiaconescu

 

It worked fine for me, i did notice that the sort is messed up if you have the "use dictionary order" button ticked

 

Sort.PNG

Meteoroid

So funny. I unticked the box and it sorted perfectly. thanks