Search Unity

  1. Welcome to the Unity Forums! Please take the time to read our Code of Conduct to familiarize yourself with the forum rules and how to post constructively.

Question How to plot data from UGS

Discussion in 'Unity Analytics' started by ZionDu, Jul 5, 2022.

  1. ZionDu

    ZionDu

    Joined:
    May 27, 2022
    Posts:
    3
    Hi there,

    I am trying to plot my data from UGS and I created custom events with parameters. However, I couldn't plot the data from the data explorer and SQL data explorer.
    upload_2022-7-5_13-26-23.png
    upload_2022-7-5_13-26-39.png

    I am wondering what SQL queries should be entered? Select parameters from our events? And EVENT_NAME = <custom event name>? Is there any tutorial for the data plotting? It's so difficult to use the current UGS comparing to the previous Legacy Analytics and we couldn't export our data as a json to plot ourself!
     
    ZionDu, Jul 5, 2022
    #1

  2. JeffDUnity3D

    JeffDUnity3D

    Unity Technologies

    Joined:
    May 2, 2017
    Posts:
    14,446
    You would wrap the event name literal in single quotes instead of double quotes. This query is working on my test project for example:

    select count(*) from EVENTS
    where EVENT_NAME = 'myLevelStart'

    Also I would encourage you to check out the documentation here https://docs.unity.com/analytics/SQLDataExplorer.html Have you successfully sent boxDestroyedV events recently? Do they show in Event Browser? It might be quickest if you sent me your Unity ProjectID in a private message, I'll take a look.
     
    JeffDUnity3D, Jul 5, 2022
    #2

  3. JeffDUnity3D

    JeffDUnity3D

    Unity Technologies

    Joined:
    May 2, 2017
    Posts:
    14,446
    Thank you for providing your ProjectID. You haven't yet sent any custom events, are you testing in the Editor? Can you place appropriate Debug.Log statements in your code to confirm that the event code you have is being executed?

    Debug.Log("Event boxDestoryedV sent");
     
    JeffDUnity3D, Jul 6, 2022
    #3