Repository navigation
Enable more datetime generalization functions #455
Description
Having cast(extract(minute from ts) as integer)) supported, there are the following expressions which we can't bucket by at the moment (coming from from Metabase):
day:
CAST(last_seen AS date)
day of week:
CASE WHEN (((CAST(extract(dow from last_seen) AS integer) + 1) + 6) % 7) = 0 THEN 7 ELSE (((CAST(extract(dow from last_seen) AS integer) + 1) + 6) % 7) END
week of year:
ceil((CAST(extract(doy from CAST(date_trunc('week', last_seen) AS timestamp)) AS integer) / 7.0))
Activity