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?
Please note that sometimes there is also some delay in Data Explorer, and you can refer to my testing query :
let activeplayer = toscalar(
['events.all']
| where FullName_Name == "player_added_title" and Timestamp > datetime(2023-08-17)and Timestamp < datetime(2023-08-18)
| join kind=inner
(
['events.all']
| where FullName_Name == "player_logged_in" and Timestamp > datetime(2023-08-18)and Timestamp < datetime(2023-08-19)
) on Entity_Id
| summarize dcount(Entity_Id)
);
let sumplayer = toscalar(
['events.all']
| where FullName_Name == "player_added_title" and Timestamp > datetime(2023-08-17)and Timestamp < datetime(2023-08-18)
| summarize dcount(Entity_Id)
);
print result = toreal(activeplayer) / toreal(sumplayer)
1 Person is following this question.
