11 Replies Latest reply on May 6, 2013 1:14 PM by Shawn Wallwork

    Counting string occurrences in a dimension

    Matthew Thomas

      Hello,

       

      I have data from a between groups experiment. Within the data source, I have a column called "Computer Use (Hours per week)". Participants were asked about about their weekly computer usage, and they had the following choices:

       

      • 20 or more hours
      • 10 to 15 hours
      • 5 to 10 hours
      • 1 to 5 hours
      • 1 hour or less

       

      When I transferred this from the survey to my spreadsheet, for simplicity, I captured answers as:

       

      • 20+
      • 10+
      • 5+
      • 1+
      • 1-

       

      So my question is this. Tableau interpreted this is a dimension. Which I assume is fine, but I need to compare the ranges of answers between groups. Any hints as to how I would go about this? Thanks in advance for any help you can provide.