I want to get the virtual currency balance of a user as a chart shown in 4h timestamp bin. What is the advanced query for this?
I want to get the virtual currency balance of a user as a chart shown in 4h timestamp bin. What is the advanced query for this?
If you want to get the virtual currency balance of a user as a chart shown in 4h timestamp, you can refer to my testing query below. For more information about Data Explorer query, you can also refer to Getting started with Data Explorer advanced mode - PlayFab | Microsoft Learn.
['events.all']
| where FullName_Name == 'player_virtual_currency_balance_changed'
| where Entity_Id == 'enter the entity ID of the player you want to query'
| where Timestamp > ago(4h)
| extend CurrencyType = tostring(EventData.VirtualCurrencyName), Balance = toint(EventData.VirtualCurrencyBalance)
| summarize Balance = sum(Balance) by Timestamp, CurrencyType
| render timechart
58 People are following this question.