The SQL created on going a group by on date field by DAY in Graphic Editor is as follows.
CAST(DATE(`table.`column`) AS text) AS `column`
The datatype text is breaking this and, subsequently, much of our reports.
there are no reproduction steps
The SQL created on going a group by on date field by DAY in Graphic Editor is as follows.
CAST(DATE(`table.`column`) AS text) AS `column`
The datatype text is breaking this and, subsequently, much of our reports.
there are no reproduction steps