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,