Pro exercise
Count distinct users per day
An event log has many events per person. Report daily active users: distinct people per day, not events, after normalizing user IDs and leaving out rows that can't be attributed.
- aggregation
- distinct counts
- dates
Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.