I have an interesting case here - let assume a table like this (values changed to not give you my actual data):
You’ll see some of those weeks are missing in my result because they had a 0 count of database items.
I’m doing a visualization of that, a bar chart with weeks as X, count as Y.
Now, if I put the X Axis into “datetime” scale (default), I only get the bars for the last 3 weeks in the set, as those are contiguous, but I’m missing all the data for weeks before the last “hole” in there. If I put the X Axis on category scale, it works, but when I get a lot of weeks in there, this will start looking weird, I’m sure - and it would be much nicer to have the X axis list dates.