I feel like I'm missing something so hopefully someone can point me in the right direction. What we wanted to do is have some record to show for example the amount of time a player wandered around in an area. So in our game logic we can record when he enters and exits, let's say 3 minutes. We'd then want to be able to query this to find out how many players are spending > 3 minutes, who's taking 10 minutes etc. I had though I could use the WritePlayerEvent and add this to the Body portion, then filter it in a query, but it seems you can't directly access the body fields, you can just look for a string - which doesn't make any sense to me. So then I was thinking maybe it's a PlayerStatistic that I can update and query.
It seems like I'm thinking of this entirely wrong, using the wrong thing or this sort of stuff isn't available. How should I go about doing these types of things? the PlayStream/EventHistory seems to only show, number of events/Date... but we'd like to see a graph more like, NumberOfPlayers/TimeSpentInLocation... don't know how to get that event data from a json.. is there somethign I need to do to collate that all and then min eit something? I'd like to know what's out of the box with playfab for this type of querying
Cheers