redash icon indicating copy to clipboard operation
redash copied to clipboard

Datetime isn't shown on Y axis in any chart type

Open nisnevich opened this issue 5 months ago • 1 comments

Issue Summary

Run a python-based query and get 2 columns like so:

Image

Then I create a chart visualisation with that data (line, bar or any other type), and all data on Y axis equals to 0 (in fact if I change "Missing and NULL values" to "Do not display in chart", then the chart will disappear completely, as if something was wrong with the data):

Image

Initially I tried to use time objects (timedeltas) instead of datetime, and faced the same issue, but then I found this topic and switched to datetime hoping it would help, unluckily it didn't.

I'm using Firefox 134.0 on Manjaro linux Linux 6.11.11-1-MANJARO.

Steps to Reproduce

  1. Run a query with 2 columns in results - date and datetime
  2. Build a chart based on that data

Expected: chart is shown Actual: all values in chart are 0 (although in table data they are normal, see picture above)

Technical details:

  • Redash Version: 25.1.0 (d1c255b7)
  • Browser/OS: Firefox 134.0 on Manjaro linux Linux 6.11.11-1-MANJARO
  • How did you install Redash: via docker compose by running setup.sh

nisnevich avatar Jun 26 '25 04:06 nisnevich