Papermark is the open-source DocSend alternative and secure data rooms with built-in analytics and custom domains.
VERSION 4
NODE endpoint
SQL >
%
SELECT
pageNumber,
SUM(duration) AS sum_duration
FROM
page_views__v3
WHERE
documentId = {{ String(documentId, required=True) }}
AND viewId = {{ String(viewId, required=True) }}
AND time >= {{ Int64(since, required=True) }}
GROUP BY
pageNumber
ORDER BY
pageNumber ASC