1 Reply Latest reply on Jun 10, 2019 7:05 AM by Dan Cole

    Counting Number of Survey Responses after Pivot

    Dan Cole

      I'm working on analyzing some survey data, and because Tableau prefers "tall and thin" data, I've been using pivots to do the analysis. So rather than having 200 rows (one for each response) I have several thousand rows to account for the pivots. Everything works much better this way, with one exception: I can't figure out how to get a count of the number of people who answered a particular way on a question.

       

      We asked respondents to "select all that apply" on a question about which certifications they had. Based on the sample below, two respondents had the CISSP certification and one respondent had Security+. Using table calculations I can easily get the percent of responses correct (100% for CISSP and 50% for Security+), but I'd like the Tooltip to include the actual count of respondents. However, due to the pivoting, the numbers are obviously way off - it should be 2 and 1, but instead it's more like 24 and 12. Does anyone have any suggestions? I feel like I'm missing something simple, and there are several questions I need to do this for. Thanks!!!

       

      Respondent IDCertNameCertResponse
      10687920794CertCISSP1
      10687920794CertNetwork+
      10687920794CertSecurity+
      10687920794CertCISSP1
      10687920794CertNetwork+
      10687920794CertSecurity+
      10687920794CertCISSP1
      10687920794CertNetwork+
      10687920794CertSecurity+
      10687920794CertCISSP1
      10687920794CertNetwork+
      10687920794CertSecurity+
      10687981992CertCISSP1
      10687981992CertNetwork+
      10687981992CertSecurity+1
      10687981992CertCISSP1
      10687981992CertNetwork+
      10687981992CertSecurity+1
      10687981992CertCISSP1
      10687981992CertNetwork+
      10687981992CertSecurity+1
      10687981992CertCISSP1
      10687981992CertNetwork+
      10687981992CertSecurity+1
      10687981992CertCISSP1

       

      Message was edited by: Dan Cole. Removed a duplicate of the table.