cold-winter-14544
04/12/2023, 11:16 PM-- Last 90 days - Doctor List Metric
WITH
__metric as ( -- Metric (Doctor List)
SELECT
anonymous_id as anonymous_id,
1 as value,
m.timestamp as timestamp,
m.timestamp as conversion_start,
m.timestamp as conversion_end
FROM
(
SELECT
user_id,
$ amplitude_id as anonymous_id,
event_time as timestamp
FROM
$ events
WHERE
event_type = 'Doctor List'
) m
WHERE
m.timestamp >= from_iso8601_timestamp('2023-01-12T23:11:24.843Z')
AND m.timestamp <= from_iso8601_timestamp('2023-04-16T23:11:24.843Z')
),
.......
Line 14 (where the error is) is basically this: $ amplitude_id as anonymous_id,
SELECT
user_id,
$amplitude_id as anonymous_id,
event_time as timestamp
FROM
$events
WHERE
event_type = 'Doctor List'
fresh-football-47124
cold-winter-14544
04/12/2023, 11:45 PM