Working with datasets

Return to top
Have more questions? Submit a request

36 Comments

  • Elissa
    Zendesk Community Team

    Hello Lohith S

    In Explore, all of the user data is housed in the Support datasets. You can see details on all of those datasets as well as what metrics and attributes are available in them by following these links: 

    For example the Tickets dataset has information on an agent's last login:

    I hope that helps!

    0
  • Lohith S

    Thanks Elissa

    Do we have a User/Agent creation date as well like in Insights ?

    Thanks

    Lohith S

    0
  • Elissa
    Zendesk Community Team

    Hello Lohith S

    I did a lot of digging and unfortunately it does seem as if the user creation date data is not available in Explore at this time. I would strongly encourage you to create a product feedback post to point out the discrepancy between what is available in Insights and what is available in Explore on this topic, to get that on the radar of our Product team as we move forward with migrating everyone over!

    In the meantime, I was able to find an API solution, if you're interested in pulling that information to create your own reports in google sheets or another program you can definitely do that. More information here: https://developer.zendesk.com/rest_api/docs/support/users#list-users. I also found this, which is only tangentially related but thought you might find it useful: How do I generate a user's last login date list?

    I hope that helps!

    0
  • Antonio Rodríguez Rasero

    Any update on the feature to join multiple datasets, or at least the ability to use more than one dataset when building a query? It would be really helpful for us, as we had a few queries in Insights that did not have this restriction, and we can't really replicate them in Explore the way we want to.

    0
  • Spencer Little

    Second the ability to join multiple data sets, especially now with the guide data set. We are unable to calculate a self-service score without requestor data. Thanks! 

    0
  • Mary Paez

    @Spencer, What are you trying to measure in your report.  Can you explain more about the self-service score? and requestor data?

    0

Please sign in to leave a comment.

Powered by Zendesk