What is the average number of players who play my game daily?
You want to know the average amount of daily active users on your app in a certain time period.
SELECT AVG(_users) AS DAU
FROM (
SELECT _day, COUNT(internal_user_id) AS _users
FROM (
SELECT date(event_time_ts) AS _day, internal_user_id
FROM cooladata
WHERE date_range(doc.date_range)
and doc.slicers
GROUP BY _day, internal_user_id
)
GROUP BY _day
)