swift-alligator-40824
11/13/2023, 3:39 AMrhythmic-agent-34208
11/13/2023, 3:39 AMfresh-football-47124
rhythmic-agent-34208
11/15/2023, 12:08 AMswift-alligator-40824
11/20/2023, 10:10 AM__userMetricJoin as (
SELECT
d.variation AS variation,
d.dimension AS dimension,
d.anonymous_id AS anonymous_id,
(
CASE
WHEN m.timestamp >= DATETIME_SUB(d.timestamp, INTERVAL 5 MINUTE) AND m.session_id = d.session_id THEN m.value
WHEN m.timestamp >= d.timestamp THEN m.value
ELSE NULL
END
) as value
FROM
__distinctUsers d
LEFT JOIN __metric m ON (m.anonymous_id = d.anonymous_id)
),
fresh-football-47124
swift-alligator-40824
11/21/2023, 10:12 PMfuture-teacher-7046
SELECT
DATEADD(second, -1, timestamp) as timestamp
swift-alligator-40824
11/22/2023, 10:29 AM