Forum Discussion
Count New Hire Per Month
Hi, I have a table of Headcount that has below fileds and I need to count the new hired per month: Table = Headcount Fields = Report Effective Date (which is the monthly report date, that change...
That would be great.
Okay. First thing is to find out what the first hiring date is in your dataset. Once you know that, go to the "Modeling" tab, and click "New Table." For example, if the first date in the dataset for “Hire Date” is 09/05/2005 then that is the first date you will need to use.
In the formula bar you'll type in Dates = CALENDAR(“09/05/2005”, TODAY())
After you hit the enter key a dates table should be generated that ranges from the first date in the dataset to the current day date.
From here you will want to go to the “Model” view by selecting it on the left-hand side of the screen. Then create a relationship between the “Dates” table and “Hire Date” in the original dataset.