Apparently @lenster.lens completely hides code blocks 😅 Here's the query: SELECT COUNT(DISTINCT(SPLIT(publication_id, '-')[OFFSET(0)])) AS unique_users FROM `lens-public-data.polygon.public_publication_pointer` WHERE DATE(block_timestamp) = '2023-04-11';

0 Comments

8 Likes

1 Mirrors