Question SQL Data Explorer Question

Hi, I am integrating an application with UGS Analytics service for a game and I have created a custom event for tracking how many times a specific level is completed. This custom event is called "Level" and I have also associated to it an int parameter called "Level_ID".

Using Data Explorer tool I retrieved the information that i wanted with this graph:



My question is: I would want to replicate the exact graph with SQL Data Explorer tool but I can't write the right query to use "Level_ID" as a parameter to re-create the same graph.

Can you help me? Very thanks

 

UP

 

UP please

 

Hello! I started following this post hoping to find an answer to a similar question. I'm not formally trained in SQL, but decided to try and teach myself the basics while referencing the SQL Cookbook that Unity has put out (https://github.com/Unity-Technologies/UGS-SQL-Cookbook)

Again, I am not formally trained in SQL, so apologies if this does not solve your issue. I figured I'd give it a go and try to help anyways! Let me know if this produces the result you're looking for - curious if my research has paid off!

WITH data AS (

    SELECT EVENT_NAME, EVENT_DATE, EVENT_JSON:Level_ID::STRING

    FROM EVENTS

    WHERE EVENT_NAME = 'level'

      and EVENT_DATE BETWEEN '2022-07-27' AND '2022-08-26'

)



SELECT *

FROM data

 

I found an old topic on this forum https://forum.unity.com/threads/how...t-of-data-collect-with-new-analytics.1297107/ that helps me to do what I wanted. Thank you.