Hi Looker team, I was looking forward to these new quarter timeframes, but they don’t work in MSSQL! The reason is that you guys are generating SQL that uses the CONCAT function, which doesn’t exist in MSSQL’s world - you just use +.
This is the error our database returns when I try to create looks using the new timeframes:
The Microsoft SQL Server database encountered an error while running this query.
‘CONCAT’ is not a recognized built-in function name.
Hope you can get this fixed soon 😞