Skip to content

Instantly share code, notes, and snippets.

@catgirlinspace

catgirlinspace/AveragePlayTime.kql

Last active September 19, 2021 18:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save catgirlinspace/105cf9823db5ee43b2124f64abbd2a5c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save catgirlinspace/105cf9823db5ee43b2124f64abbd2a5c to your computer and use it in GitHub Desktop.
Download ZIP
Roblox PlayFab Data Explorer Quieries
Raw
AveragePlayTime.kql
['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)
Raw
FirstSessionPlayTime.kql
['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
Raw
PlayTime.kql
['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
Copy Markdown

nikita-petko commented Mar 31, 2021

I also know SQL,

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

@catgirlinspace
Copy link
Copy Markdown
Author

catgirlinspace commented Apr 1, 2021

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