fancy-candle-92347
05/19/2022, 4:50 PMvarient=0 and value=1
2062596
varient=0 and value=2
2061
varient=1 and value=1
2062117
varient=0 and value=2
2067
future-teacher-7046
value
dimension?fancy-candle-92347
05/19/2022, 5:23 PMfuture-teacher-7046
fancy-candle-92347
05/19/2022, 5:30 PMwhere value=2
)value=2
.substr(0, 10)
however the index position for first character starts from 1.
__distinctUsers as (
-- One row per user/dimension
SELECT
e.user_id,
substr(
to_iso8601(date_trunc('day', e.conversion_start)),
0,
10
) as dimension,
(
CASE
WHEN count(distinct e.variation) > 1 THEN '__multiple__'
ELSE max(e.variation) END
) as variation,
MIN(e.conversion_start) as conversion_start,
MIN(e.conversion_end) as conversion_end
FROM
__experiment e
GROUP BY
dimension,
e.user_id
),
future-teacher-7046
fancy-candle-92347
05/20/2022, 4:13 PM