Hey guys, I have a custom event like this:
{"PlayFabEnvironment": { "Application": "mainserver", "Vertical": "master", "Commit": "5ea788d", "Cloud": "main" }, "EventNamespace": "title.61DAC", "EntityType": "player", "SourceType": "GameClient", "Timestamp": "2020-04-18T11:53:31.0308461Z", "EventName": "levelLog", "EntityId": "93E58E63E772BDE", "TitleId": "61DAC", "EventId": "6de7995f9644448e93fb3f6bf4b9045e", "Source": "61DAC", "player_id": "93E58E63E772BDE", "result": "win", "level": 3, "hero" : 2, "try_count": 5 }If a player wins a level in the game, this event is sent to PlayFab.
I try to find the percentile 0.25 of try_count for each level and hero selected for this level where result is “win”.
The result will be like this, if we assume there are only 3 levels and 2 heroes in the game:
level hero try_count 1 1 1 2 1 2.5 3 1 8 1 2 2 2 2 1.5 3 2 6I tried my best but couldn’t get this query right. Could you please help me in this situation?Thanks in advance,Cagatay