1 2 Previous Next 26 Replies Latest reply on Dec 17, 2016 2:34 AM by Kashish Chauhan

    Calculate total number of active people at end of every quarter

    Jesse Narang

      Hi Tableau community,

       

      I have a data source that contains the column called "Hire Date" which displays the hire date of a person. Using that and putting a count distinct on the ID, I was able to calculate the number of hires that were made every quarter. I also have a column called Active where 'Y' means the person is still active and 'N' means the person is not active anymore. I am trying to calculate the total number of active people at the end of every quarter.

      Can someone please help me with this ?

       

      I have attached the tableau workbook also(Version 9.3).

       

      Best Regards,

       

      Jesse

        1 2 Previous Next