Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

Track Response Rates in Tableau?

etower University of MinnesotaCommunity Member, XMPN Member Qubie ✭

Is it possible to import in-progress responses to Tableau, in addition to complete responses? I've used the API in the past to import survey data into Tableau for analysis, but now I want to use the integration to create a dashboard of response rates for open surveys. Unfortunately, when I connect Qualtrics and Tableau, only completed responses are being displayed. However, in the list of variables to select for import, "progress" and "duration" are both options. Has anyone used the Tableau integration / Qualtrics PI in this or a similar manner? If so, how did you make it work? Thanks!



  • JenCX
    JenCX Broomfield, COCommunity Member, XM Advocate, XMPN Member, Qualtrics Brand Admin Wizard ✭✭✭✭✭

    So you can't track in-progress responses, but you can track those that are incomplete but have been closed (which is when they're recorded). You can check what your survey is set to do with unfinished responses in the Survey Options. There's also a data field that is 'Finished', which is really easy to use to distinguish your complete and closed responses from your incomplete and closed responses in Tableau. Good luck!

  • etower
    etower University of MinnesotaCommunity Member, XMPN Member Qubie ✭

    That's not quite the direction I was going. Here is perhaps a better explanation of what I am trying to accomplish:

    I am attempting to join survey data from Qualtrics (via the web connector) with an Excel list consisting of all people invited to take the survey. My goal is to have all cases from the original survey contact list present within my Tableau data source, along with the survey data for all people who responded to the survey. I'm hoping to use this join to calculate response rates based on various categorizations which are present in the contact list. However, when I join the data using Left Join in Tableau, it is behaving as a Full Outer Join instead - and all people from the contact list who did not take the survey are being removed from the data source. Has anyone been successful in joining Qualtrics and Excel data in Tableau? Any ideas what may be going on here?