The Trend chart doesn't work with previous week, just the current one.
Would be possible to make it works?
Would be possible to make it works?
I have a similar issue where certain days work and certain days don’t. I have casted the date column correctly as well.
@Luiggi any ideas?
Make sure the query is providing data for the dates & date ranges indicated. If your query has a date range of ‘last two weeks,’ it can’t tell you what was happening last month.
You may need to handle any missing data using COALESCE(), etc., to avoid any NULL values being returned from arithmetic.