2 Replies Latest reply on Jul 21, 2016 6:31 AM by cherillin.gritton

    Is there a way to create subqueries in Tableau on text data?

    Ao Zhou

      Dear All,

       

      Here is a simplified table describing group members and their gender:

       

      NameGroupGender
      AmberG1F

      Don

      G1M
      JimG1M
      JennG2F
      SteveG2M

       

      Now we would like to create a query in Tableau that:

      1. Selects all the female members, and
      2. Get the total number of members in each group

       

      NameGroupNumber of Group MembersGender
      AmberG13F
      JennG22F

       

      The only way I can think of is making a sub-query, count the number of members within each group first, and then make another selection based on this sub-query.

       

      However, I don't know how to make a sub-query in Tableau. Would you give me some hints please?

       

      Thank you!