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

[nisnevich]

Issue Summary

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

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):

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 (d1c255b)
• 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]

JFYI this is how I compose the datetime objects:

for day, deltas in reversed(timedelta_map.items()):
    avg_time = sum(deltas, timedelta()) / len(deltas)
    avg_datetime = datetime.combine(date.today(), datetime.min.time()) + avg_time
    result["rows"].append({"Date": day, "Avg response time": avg_datetime})