Date sorting in pivot tables is broken


#1

It looks like pivot tables first try to format the date (the format is hard coded somewhere btw) and then sort on the formatted version, which ends up looking something like the attached image. See how all Fridays are before all Mondays!


#2

It’s a very old issue, that never been prioritized enough to be fixed :frowning: You can follow this GitHub issue: https://github.com/getredash/redash/issues/216.


#3

You can solve this by using (at least in mysql) date_format(datefield,’%Y-%M-%D’)