I created a table that aggregates data by year and week of year and display this in a chart over time. As part of the query, I order by the year, then week columns. In the visualization on the query (in the SQL editor), I disabled the sort, because it's wrong. I then click add to dashboard, but then it displays the auto-sorting the visualization uses instead of my ORDER BY. How do I fix this?

Edit: I switched to using year-month, because the to_date can't handle week-of-year. When I did that, then it gets the dates in the right order and it looks fine in the query visualization, but it's completely screwed up in the dashboard. See added files.