Databricks dashboard removing order, incorrectly sorted.

Mr__E — Fri, 15 Apr 2022 21:24:00 GMT

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.

Re: Databricks dashboard removing order, incorrectly sorted.

Anonymous — Thu, 19 May 2022 14:01:51 GMT

Hi @Mr. E (Customer) , did you get a chance to check Kaniz's previous comments ? is this issue resolved or do you need any further help here ?

topic Re: Databricks dashboard removing order, incorrectly sorted. in Data Engineering

Databricks dashboard removing order, incorrectly sorted.

Re: Databricks dashboard removing order, incorrectly sorted.