11 Replies Latest reply on Mar 29, 2016 10:47 AM by swaroop.gantela

    How to create a table calculation to understand the evolution of a workforce in a career?

    ROGERIO FARIAS

      I am a researcher from Brazil and I am currently facing a problem. I have a list of 2444 workers who entered in a government department from 1930 to 2010. I have their admission dates, how they were promoted and when they were fired or quit.

       

      I wanted to do a simple are chart graphic with year in the horizontal axis and the total number of workers in the year in the vertical axis.

       

      In each year I wanted also to know how the workforce was divided in the several promotion levels the organization had.

       

      I have tried to do this in several different ways in tableau. Always ended in failure.

       

      Can someone please help me? I have attached the raw Excel file.