Discussions
Saved search listing employees joining and leaving company by calendar month
Hi everybody,
In order to track employee turnover in our company, I'm trying to configure a saved search picking up the {hiredate} and {releasedate}, group them by calendar month, and sum up the respective joining or leaving employees' availability {custentity_emp_availability} as a positive amount when joining and a negative amount when leaving respectively. This is all pretty simple if I hardcoded the months into the individual columns. In that case, though, I would need to edit the saved search every now and then.
In order to make it dynamic and have the calendar month range extended, regardless of whether HR adds a new employee record with hire or release date two years into the future or five years in the past, I am facing the following two challenges.