We want to be able to monitor D1 Retention in "real time" and be able to see on the data explorer on advanced mode the following: Players who signed up yesterday (only yesterday, not longer than yesterday, or past 24 hours). and players who logged in today (last 24 hours) in DISTINCT.
So the question is, what is the query that will allow that?