Skip to content

Instantly share code, notes, and snippets.

@lavender-sys

lavender-sys/AveragePlayTime.kql

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

  • Select an option

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

Select an option

Learn more about clone URLs
Save lavender-sys/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

nikita-petko commented Mar 31, 2021

Copy link
Copy Markdown

I also know SQL,

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

@lavender-sys

lavender-sys commented Apr 1, 2021

Copy link
Copy Markdown
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