I have the date of a dataset savein in MySQL as YEARWEEK e.g. 202048. Now grafana complains that the data is out of range. Therefore I tried to filter by AND $__timeFilter(YW), but that does obviously not work.
The x column is selected OK by:
UNIX_TIMESTAMP(STR_TO_DATE(concat(YW, ‘Sunday’), ‘%X %V %W’)) as time
Using the excact same transformation on the timeFilter does result in a MySQL (5.7.32) error.
Is there a solution for this?