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

13 lines
265 B
Plaintext

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