Files
dataroom/lib/tinybird/endpoints/get_total_viewer_duration.pipe

13 lines
256 B
Plaintext

VERSION 1
NODE endpoint
SQL >
%
SELECT
SUM(duration) AS sum_duration
FROM
page_views__v3
WHERE
viewId IN splitByChar(',', {{ String(viewIds, required=true) }})
AND time >= {{ Int64(since, required=true) }}