If your query can run smoothly on the DB server, then it should work fine in Looker. for DATE_TRUNC , some DBs have that like : DATE_TRUNC( column_name, ‘week’) as weekIDalso you have to GROUP BY this field (weekID)