2 Replies Latest reply on Dec 27, 2016 7:49 PM by Luke Tan

    Dividing by arbitrary numbers for each group

    Luke Tan

      I have a dataset that looks like

       

       

      UserSchool
      JohnScience
      JaneMedical
      MaceScience
      PeterMedical
      SaceDental
      DaceChinese Studies

       

       

      I can easily use tableua to do a bar chart, pie chart to show number of users per school. But I want to also do a % of users per school.

       

      The issue is the number of users in each school is in another table

       

       

      Science10
      Medical15
      Dental21
      Chinese Studies10
      Sociology12

       

      How do I create a bar chart showing % of users per school? That is Science should be 2/10 , Chinese Studies 1/10 etc.

       

      I can change the shelf calculation so it divides count by a fixed number but I can't make it vary by the school.