Hello Is it possible to bucket per week, but starting on an arbitrary week day ?

You can do the offset first, then bucketing, then reverse the offset?

I'm can't seen to find how to do offsetting ?

something like

date_trunc(ts-3d, 'week') + 3d

From my testing, it seems this only works with floats (epoch) and the

d

is ignored, meaning that we are subtracting the multiplier (say

3

in whatever unit the epoch is) For example:

SELECT
    dateString AS original_datestring, 
    fromDateTime(dateString, 'yyyy-MM-dd') AS original_epoch, 
    toDateTime(fromDateTime(dateString, 'yyyy-MM-dd') -  '10d', 'yyyy-MM-dd') AS offset_datestring, 
    fromDateTime(dateString, 'yyyy-MM-dd') -  '10d' AS offset_epoch 
FROM table

Results in:

yeah, it’s 3 * 86400 * 1000 😛

Ah ! 😄 Thanks @Xiang Fu