Daily active users
For every day that has at least one event, count the number of distinct users who did anything that day.
activity_date is a date, dau is the user count.
output columns
activity_datedauuses
ctrl + enter to run on the sample data · ctrl + shift + enter to submit
run your query to see the output here. Submit checks it against the sample data, hidden test cases, random data and a large dataset.