Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Cumulative Distinct Users

For each day return the number of distinct users seen up to and including that day. Order by day.

Table schema

Visits(day INT, user_id INT)

Sample data

day | user_id
1 | 1
1 | 2
2 | 2
2 | 3
3 | 1

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.