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 Populate Y-Axis based on String in SQL Explorer.

Discussion in 'Unity Analytics' started by Denaton, Oct 29, 2022.

  1. Denaton

    Denaton

    Joined:
    Apr 6, 2011
    Posts:
    16
    Is it possible to populate an array of Y-Axis so i can have more than two based on a string.
    In the Data Explorer i can have multiply but its locked into dates, i have sections i wanna match against to see what enemy a player prefer at what point in the game.

    upload_2022-10-29_22-2-52.png

    upload_2022-10-29_22-3-34.png

    Since i have the data tables i can just look at them for now or use Excel or make my own tool for it, but is there something i have missed?
     
  2. Laurie-Unity

    Laurie-Unity

    Unity Technologies

    Joined:
    Mar 5, 2020
    Posts:
    175
    Hi @Denaton,

    The SQL Data Explorer can only plot against two Y-axis scales. You can often manipulate the shape of your results in the way you build your query, but might need to export the results as a .csv to peform more advanced vizualization or data pivots in something like Excel. (e.g. Take a look at using the CASE function to break different string values into columns)

    I'm not 100% clear on what you are trying to achieve from your screenshots, but if you can provide a little more detail on what you are wanting to see in your report, I may be able to give some more specific guidance.
     
  3. Denaton

    Denaton

    Joined:
    Apr 6, 2011
    Posts:
    16
    For now i have made my own graph with ChartJS

    But i was hoping to be able to have Node on the X axis and Number of encounter on the Y axis while each Unit is its own line.