Hello, I’m using SQL Runner for the first time and am attempting to roll up a series of dates into their respective report weeks.
I’ve attempted using DATE_TRUNC(‘week’, column_name) but it won’t run in SQL Runner. I’ve tried looking up other work-arounds for Looker’s SQL Runner specifically and am at a loss. Any ideas? Thanks in advance!