Heatmap dates bug

Issue Summary

We are still having issues with our heatmap. Based on the helpful suggestions from our previous thread we went with year_week number, it worked for some weeks but not others, as you can see on the image where 2022-12 precedes 2022-8. On the y-axis these dates are categories, and are not recognized as datetime, or even weeks of the year.

As a result the timeflow is all messed up and not chronological on that heatmap that defies its purpose. Is there any way around it and when (if possible) this date bug will be fixed?

Technical details:

  • Redash Version: 10
  • Browser/OS: Chrome
  • How did you install Redash: self hosted on AWS

This is because Plotly sorts using an alphabetical sort where 12 naturally falls before 8. You can work around this by using an ORDER BY clause in your SQL query to sort the data chronologically and then disable the Sort option for the X-axis.

There is no timeline. Redash is a community effort. We are happy to review a pull request implementing a fix to this behaviour.

1 Like

Thank you very much for your reply.

1 Like