Filtering in the Data Explorer

I send an event every time the player finishes a level, we have 30 ranks. In the event I’m storing the finished level as well as time the player needed to finish the level. Now I would like to get the average time players need to finish each level. I could create a funnel for each level, but that feels pretty unefficient. is there any way, I can achieve an average calculation. I’m coming from GameAnalytics, and there this was possible.

This is possible with Raw Data Export, a Pro-only feature. There are KB articles describing how you might accomplish this here:

https://support.unity3d.com/hc/en-us/articles/115004052703

https://support.unity3d.com/hc/en-us/articles/115004688206

I see, I did play around with exporting the data, but it felt like a bad solution due to the fact that it takes some time to export as well as the limitation of 30 days as the maximum time length.
I didn’t know that I can grab the data with a rest interface, that sounds like a good solution, even though now I need to learn how to use couchbase.

Just for further improvements of analytics: Is there any filtering options planned? The web analytics tool makes a nice first impression, but as soon as I wanted to do some in depth analysis I hit limitations (that I didn’t encounter with GameAnalytics) really fast.

You don’t need Couchbase, it was just a suggestion. Any database that you are familiar with should provide text import.

Hi Jeff, thanks again for the answer. Sorry for being unclear on that one. I do understand that the api is not limited to couchbase, I just think that it is still pretty inconvenient to need another tool to do anything apart from the basics. Don’t get me wrong, it is awesome that you offer the rest interface, but I wish I would only need that when I want to do some crazy stuff.

To me filtering, like in the described case in my first post, does not feel like an unusual use case, therefore I hoped you would provide the possibility to do that in the web interface. I do understand that building such a service is a lot of work and I read up on your blog posts of how much work you put into uniting your services and repos, and it is great that you are working on the foundation of the services. And I guess that was your main priority in the last time, I still want to tell you as a user that I feel like the tool is missing a feature I would have expected from a unity analytics service.

Understood! Could you please post the idea on our feedback site:

http://feedback.unity3d.com/forums/unity/suggestions?category=analytics

We use that site to determine where we can best focus our resources to provide features that developers are most interested in. Every user receives 10 votes to use, and if there is a feature you REALLY care about you can vote for it up to three times.

For all others having that problem, there is already a suggestion thread there: https://feedback.unity3d.com/suggestions/custom-queries
(Right now the most upvoted one for all open analytics suggestions)