Pre-requisites - Read access to a replicator database
chain_events table to query the number
of ID_REGISTER events
and group by day.
Advanced
Counting signups by day
To count the number of signups by day, we can use the
Was this page helpful?
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
chain_events table to query the number
of ID_REGISTER events
and group by day.
SELECT DATE_TRUNC('day', created_at) AS day, COUNT(*) AS count
FROM chain_events
WHERE type = 3 -- ID_REGISTER (see event types reference page)
GROUP BY day
ORDER BY day desc;
Was this page helpful?