Using DuckDB DATE types in a chart's x-axis shows incorrect values/spacing

[cbruno10]

Describe the bug
If I have data like 2024-12-05 in DuckDB's DATE type in an x-axis (from the datetrunc() function), the x-axis doesn't display properly

[MichaelBurgess]

@cbruno10 do you have a reference snapshot I can use to debug this please?

[MichaelBurgess]

The issue is that the default min interval between the time series points means the chart tries to render the missing bits between the 24hr period. We have three routes forward here:

1. Format the series column to be a string in the format you want
2. We add support for forcing a chart to use category series, even when it looks like time series
3. We add support for adjusting the min interval on a time series chart

Example of #2

Example of #3

@cbruno10 any preferences on a route forward?