I'm displaying a histogram of user scores in my game. I'd need a way to display some aggregates for a leaderboard without retrieving all the entries.
Any thoughts on if (and how) I could achieve this with Playfab?
I looked at the docs but couldn't find any custom querying of leaderboards or global (collective) stats.
Currently, the leaderboard system only support GetLeaderboard, GetLeaderboardAroundUser and GetFriendLeaderboard. Custom querying is not supported. I'm not sure what aggregation you are looking for, you may try with Segment with which you can filter players based on the statistics value. If this can't meet your requirement, you may use some external services to store all the leaderboard data and perform querying against it. Besides, there will be a leaderboard upgrade in upcoming Q4 features:https://blog.playfab.com/blog/upcoming-roadmap-2018-q4-oct-dec-edition which might help you. You may look forward to it.
I looked at the upcoming changes in the roadmap but it doesn't look like it's addressing my issue. I need to perform a "select score, count(*) group by score" or something along those lines (get number of occurrences for each score).
Where can I find more info on the Azure Data Explorer that you mention @Brendan?
My apologies - it looks like it's not in public preview yet. You can expect it to show up soon, but you can read more about the Azure Data Explorer here:
https://azure.microsoft.com/en-us/services/data-explorer/
Right now, you could use the Snowflake integration to accomplish the same thing - query for the data, potentially using a local cron job, and update a data store with the aggregate info you need.
3 People are following this question.
