9 Replies Latest reply on Jun 23, 2016 7:32 AM by Rohan Malusare

    Creating a Population Pyramid by Career Band and Gender

    Nadia Garrett

      Hi Everyone,

       

      I'm trying to create a population pyramid split by career band and gender. I want it to basically look like this, but with career band instead of age:

       

       

       

      Below is an image of how far I can get (unfortunately I can't share the workbook as it contains confidential info). Pernr = the unique identifier.

       

       

      Creating a Population Pyramid | Tableau Software

       

      I read the walk through above, which I think will help, but my first hurdle is that I can't quite figure out how to convert my gender dimension (currently a string) to a number, so that male = 1 and female = 2.

       

      Any help would be much appreciated.

       

      Many thanks,

       

      Nadia