Last active
September 19, 2021 18:11
-
-
Save catgirlinspace/105cf9823db5ee43b2124f64abbd2a5c to your computer and use it in GitHub Desktop.
Roblox PlayFab Data Explorer Quieries
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ['events.all'] | |
| | where FullName_Name == "_Player_Leave" | |
| | where isnotnull(EventData.data.sessionTime) // older _Player_Leave events dont have this | |
| | summarize SessionTime = avg(todouble(EventData.data.sessionTime) * 1s) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ['events.all'] | |
| | where FullName_Name == "_Player_Leave" | |
| | where isnotnull(EventData.data.sessionTime) // older _Player_Leave events dont have this | |
| | summarize arg_min(Timestamp, *) by Entity_Id | |
| | summarize Sessions = count() by Time=bin(todouble(EventData.data.sessionTime) * 1s, 5s) | |
| | order by Time asc | |
| | render linechart |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ['events.all'] | |
| | where FullName_Name == "_Player_Leave" | |
| | where isnotnull(EventData.data.sessionTime) // older _Player_Leave events dont have this | |
| | summarize Sessions = count() by Time=bin(todouble(EventData.data.sessionTime) * 1s, 5s) | |
| | order by Time asc | |
| | render linechart |
Author
ok. I'm not sure how SQL is involved.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I also know SQL,