In the Alteryx Gallery Collections the Workflow Upload Date doesn't sort properly. Instead of sorting chronologically (ex: Jan first Dec last) it sorts by number (Dec goes before April because Dec starts with a 1 while April starts with a 4), see attached for an example.
it flips back and forth between 2022 and 2021
In the example November and December are first because the month starts with a 1. Then April follows because it starts with a 4. Then it starts to get messy because it does this:
- 12/16/2021
- 4/04/2022
- 4/26/2021
- 5/02/2021
That 2022 is in the middle purely because 4 < 5, that's not right.
I tried exploring the settings to see if I could change this but I didn't find an option to do so.
Two potential solutions:
- Change the format of the date to YYYYMMDD, then if it sorts numerically it will still work
- Don't sort numerically and instead sort chronologically, ex: April goes before December
As collections get big sorting for the most recent workflow becomes a nightmare with the current improper sorting mechanism.
If I'm mistaken and this option already exists please let me know.
Thanks!
Chris