Question Event parameter operations for numeric (sum, avg) are not available in the new data explorer

We had a custom event that was sent anytime the user change scene with a parameter that contains the time in seconds the player has been in the scene. With the sum operation available in the legacy Analytics we were able to sum all that values and see which is the most visited scene. How is that supposed to be calculated no? Is it going to be implemented?

 

Hi Laurie, the problem is that we now have to give the client the project with the legacy analytics until you add that feature to the new data explorer, so its very frustrating. Also, what happens with the custom events sent to in the legacy backend when we migrate to the new analytics system? Are they lost?

 

Ok Laurie, thanks for your fast answer. Do you have any ETA about the aggregated measures?

 

I am in a similar boat here. I am sending out runtime performance data as custom events (frame rate as specific game events). My sample size is very low <500 events in this alpha test. While it would be great to get graph plotting at the parameter level of the custom events. I really just need the ability to export all events of the specific custom event type.

I submitted a support request to get this data as directed by https://docs.unity.com/analytics/FAQ.html
----------
Can I export data
This is not self-serve and you'll need to contact customer support for more information.
----------

any help with getting an export of these events would be greatly appreciated

 

Hi @Laurie-Unity, @Pierre-Unity

Could anyone please update me on where we are at implementing the aggregated parameters in Data Explorer?
If this is already done, kindly direct me as I'm not able to find it.

I believe this is a very basic feature any analytics dashboard should have. Any events that record durations or count any in-game parameters go useless without this feature.

 

Bump. There seems to be no way to aggregate on parameter values in Data Explorer. To my short understanding this basically renders numeric parameters useless unless we'd opt in using SQL Data Explorer. If I'm wrong about this please shed me a light and let me know.

Edit: Found an article regarding this issue. Apparently UA got out of beta without this feature... I'd really appreciate if someone has any info about road map or planned release date.

https://forum.unity.com/threads/ugs...er-functions-gone-from-data-explorer.1248586/

 

After finally deciding to start using the UGS rather then competitors (Azure, GPGS etc...) I was baffled that this basic feature is not available. We set-up every event, designed their properties just to realize there is no way to do anything useful with time values. I would also love to see a road-map as this is really an extremely basic feature for metrics/analytics..

 

So I found out you can write SQL queries!
Yesterday evening I quickly put up a dashboard and could achieve what I wanted.

(Average time is calculated from a specific event's property)

However for a simple query like this I already hit the fair usage limit...

Code (CSharp):

1. SELECT avg(matchTime) AS "Average match time", avg(timeSpentHiding) AS "Average hiding time", avg(timeSpentAlive) AS "Average alive time", EVENT_DATE AS "Day"
2. FROM (SELECT EVENT_JSON:matchTime::FLOAT AS matchTime, EVENT_JSON:timeSpentHiding::FLOAT AS timeSpentHiding, EVENT_JSON:timeSpentAlive::FLOAT AS timeSpentAlive, EVENT_DATE
3. FROM EVENTS
4. WHERE EVENT_NAME = 'GameSession_Competitive_Duel_Ended' AND EVENT_DATE>current_date-30
5. )
6. GROUP BY EVENT_DATE

Also with two custom events I'm already at 1.3% with 2 MAU. (The two customer events are for game session start and end for 18 game sessiona cross the two test users)