Create Query from two different datasets



  • Official comment
    Eugene Orman
    Zendesk Product Manager

    Hi everyone, 

    Thank you for sharing your feedback and use cases.

    The ability to join different types of data is different on our radar. We are looking into different ways to fit this functionality into Explore. However, active implementation of this functionality is not on our immediate roadmap. We will share more details as soon as we will be ready to start working on this feature.

    Please continue sharing your thoughts and vote for this feature if it is important for your team.

  • Kalle Windefalk


  • Alexey Krasnichenko

    I would love to see it too

  • Kalle Windefalk

    I would like to be able to report on linked article tickets where the link is private or public. 

  • Alina Lushnikova

    Strongly agree, joining datasets would solve so many problems for us! For example, we want to report on SLA by channel: emails (in-built SLAs), phone calls and chats (custom metrics built on the first reply time thresholds). Creating one query for all these metrics is easy and natural in Insights - and absolutely not possible in Explore. Would love to see an ETA on this.

  • Louis Evangelista

    Yes it would help in agent metrics and KPI for time tracking.

  • Justyna Pultowicz

    Absolutely, same here!

  • Franco Landa

    +1 This would be amazing to see for our Team Leaders who currently have to build multiple queries just to capture a few metrics from different datasets.

  • Nicole

    +1, agree with Alina!

  • Paul Strauss

    100% - this is critical for our reporting to get a full view of customer interactions across support, chat, and talk, and individual queries in a dashboard aren't enough to solve our use case.

  • Brecht Smit

    Same here.

    I select for each incoming call a reason why they contacted us... from a dropdown menu (custom ticket field created in Zendesk)

    The same i do for the emails we receive.

    Now i would like to see the percentages of all the reasons customers contact us; using both talk dataset and suppport dataset in one querry.
    Now i have to make two seperate querries, one using the call data; the other querry using only the email (support)dataset...

  • Qin Brian

    strongly agreed. For example to connect Chat and Tickets

  • Scot Sroka

    Agreed this would be very helpful! 

  • Sydney Neubauer

    We have a similar post that needs multiple datasets in order to get the data we need:

    Currently linking history and currently published articles are 2 datasets. In other words, you are not able to see the articles that have not been linked as it requires there to be previous linking to show up in the KCapp linking dataset. As well, the KCapp also shows ALL articles that were linked, which includes archived articles, or external articles.

    The ability to filter this data are in different datasets so we are only able to get a partial picture as to how helpful our knowledgebase is for our Agents

  • barbara


    This feature would be really helpful.

  • Mario Guisado

    Add me to the list that would like to see this happen.

  • Antonio

    +1!! This is not just something that would be nice to have. This is something that is absolutely necessary!! It's so basic that I can't comprehend how this is not possible to do right now, when it was so easy before when we had Insights!

  • Equipe Business Technology

    I agree, this is a critical feature that would be very useful.

  • Paul Jarman

    Totally agree, this is a critical feature and is preventing us from creating efficient reporting processes internally.  This coupled with no Explore API leaves us hand-tied to properly manage performance.  Unusual for an enterprise level tool such as this and not something we were made aware of when buying the tool!


Please sign in to leave a comment.

Powered by Zendesk