Hello, dear Playfab support team!
I'm reaching out because we need to change the size limits of all leaderboards in our game, and we haven't found a solution through the dashboard or API.
Can you appoint us the direction?
#Change the leaderboard size limit
warped ermine
radiant eagle
So, the API support was deployed recently but the documentation and SDK releases are still pending. How many leaderboards do you have (can you DM me the titleId)?
still jetty
Hi Rakesh, we are also looking to increase our SizeLimit and have one Leaderboard for all players scores across the lifetime of the game which we have in Leaderboards V1. But would like the multiple column functionality of Leaderboards V2 but can't use that at the moment due to the 10k limit of entries in a leaderboard.
radiant eagle
The UI for updating the sizelimit is now live, so you should be able to update it in game manager. Going beyong 10K requires a paid plan though. The multi column is somewhat orthogonal to the 10K limit right, why do you see one interfering with the other?
Ah, you have more than 10k entries on the leaderboards in v1 and you cant move those to v2.
still jetty
We will be moving to a paid plan so happy to increase the limit to let's say 1,000,000 if that is possible.
The design for the feature is for us to have an "All Time" leaderboard that tracks every players 'Total Score', 'Win Rate' and 'Total Games'. We then give the player the functionality to filter and view the leaderboard in 3 ways, by either sorting by 'Total Score', 'Total Games' or 'Win Rate'. Is this something that is possible with the V2 leaderboard API?
radiant eagle
Yes 1M is the limit for v2 leaderboards (and it gives accurate ranking vs the rank estimation in v1)
Unfortunately, we dont allowing filtering, so you would need 3 different leaderboards for that. Logically, it has to be 3 different rankings right? One player can be top of the leaderboard for totalGames vs another person for TotalScore
still jetty
That's correct, they would be different rankings. If you're top of TotalGames, you may not be top for TotalScore.
Is there a way to minic the filtering functionality? Could we show the TotalGames leaderboard of the top 20 players for example but we also show in the same view, their win rate and the total score of those players? Eg on each row of players they have the 3 values shown, but it would be ranked by on which leaderboard you're looking at?
Would this be solved by tracking the 3 values within a single statistic and then creating 3 new linked leaderboards to that new statistic value which ranks them based on how we set it up on the dashboard? The issue with this, is that TotalScore, TotalGames and WinRate would all be sums based on the previous value which I don't think is supported when including more than 1 value within a new statistic
radiant eagle
Yeah, we dont allow SUM in all columns of multi column stats because that can violate some aggregating principles. Stat calls are batched. If you have three different stats powering three different leaderboards, you might need to multiple queries to get the leaderboard entries (one for each leaderboard) and use GetStatisticsForEntities and get all 3 stats for the players. The second stat call is required because the top players on each leadeboard can differ (so you wouldnt have all 3 values for a given player from just the leaderboard score itself).
Alternatively, and this is very hacky, you can store all 3 values in the metadata property (if they fit). That way, you can achieve what you want, get the other 2 values from metadata in a given view/filter.
Neither of this unfortunately gives you enhanced tiebreaking though, unfortunately (if you wanted an "all time great" leaderboard where the first priority is for total score, then total wins, then total Games for example. We are looking into this for leaderboards where the soure columns can come from different stats and not just one which would help in the enhanced tie breaking here, but no ETA on that.
still jetty
Ok thank you for that, we're not too worried about the tie breaking so will go with the hacky solution you suggested. That would solve our issues as a work around. Thank you for the detailed response!
If we want 1,000,000 rows per leaderboard as the 'SizeLimit', is this something we need to do on creation of the leaderboard, or something we can change once the game is live and gathering users?
radiant eagle
you can update the size limit later on, you dont have to commit to it early on. However, note that decreasing the size limit will get rid of entries
still jetty
Ok, good to know, thanks!
still jetty
Am I right in thinking that the 'Reset Method' of a Linked Leaderboard is based of the Statistic rather then the leaderboard? Is it possible to have 1 statistic for 'Total Score' which is linked to 3 leaderboards, one leaderboard for daily, one for weekly and one for all time with each leaderboard having a separate 'Reset Time'?
Is the correct solution 9 statistics, 3 for daily reset, 3 for weekly and 3 for alltime. Each stat contains all 3 values?
radiant eagle
It is correct that the reset of a linked leaderboard is tied to the stat (if that's not what you are seeing, let us know it would be a bug). So, the 1 stat wouldnt work.
If you have 3 scores that need to be on 3 different leaderboards like we discussed earlier and they need to have 3 different reset schedules, that does become 9 stats unfortunately. And you can store the remaining 2 scores in the metadata.