I need design advice on how to handle stats for my game. Each level of the game has a target score that a player must reach to complete the level. The target score is not a set value but is calculated from the last N scores achieved by all players. (The exact math is not important here.)
So I need to maintain, for each level, a title-wide list of recent scores achieved by players. Clearly PlayFab title data is not meant to be updated this often, so that's not an option. I thought of using player stats and leaderboards, but unless I'm mistaken leaderboards only consider one value (the latest) for each player, and the results are sorted by value, not by datetime.
Is there another API that could help me maintain these frequently changing lists? I've never used CloudScript but I'm willing to dive in if someone can confirm that I can access some sort of global storage from CloudScript.