Skip to content

Instantly share code, notes, and snippets.

@catgirlinspace
Last active September 19, 2021 18:11
Show Gist options
  • Select an option

  • Save catgirlinspace/105cf9823db5ee43b2124f64abbd2a5c to your computer and use it in GitHub Desktop.

Select an option

Save catgirlinspace/105cf9823db5ee43b2124f64abbd2a5c to your computer and use it in GitHub Desktop.
Roblox PlayFab Data Explorer Quieries
['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)
['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
['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
@nikita-petko
Copy link

I also know SQL,

INSERT INTO `robloxaccounting`.`account` (`Id`) VALUES ('1');

@catgirlinspace
Copy link
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