Comment by @paulburke • Hey

Apparently @lenster.lens completely hides code blocks 😅 Here's the query: SELECT COUNT(DISTINCT(SPLIT(publication_id, '-')[OFFSET(0)])) AS unique_users