Search Unity

Question Connection to Excel

Discussion in 'Unity Analytics' started by mariabrito17, Oct 27, 2022.

  1. mariabrito17

    mariabrito17

    Joined:
    Feb 23, 2021
    Posts:
    10
    Hello!

    I noticed it's not possible to create clustered columns on Unity Analytics, so I was wondering if it's possible to create a connection to Excel by using the link generated when we click on 'Share'.

    I tried but I'm not getting any of the data there.
     
    mariabrito17, Oct 27, 2022
    #1

  2. Laurie-Unity

    Laurie-Unity

    Unity Technologies

    Joined:
    Mar 5, 2020
    Posts:
    220
    Hi @mariabrito17,

    The Share button on the Data Explorer and SQL Data Explorer tool has an 'Export as CSV' option that can be used to export the displayed dataset as .csv file, that can be loaded into Excel.

    If you aren't seeing any data in the CSV file, please check that you have applied any metric and event selections and run the query. The csv should contain the same data as displayed in the results panel. If this isn't the case, please share a screenshot of your report configuration.

    For more in-depth analysis and visualizations, the Data Access option can be used to access your data in a Snowflake data share. You can then connect other 3rd party database and visualization tools directly to your data.


    I hope that helps,
     
    Laurie-Unity, Oct 30, 2022
    #2