Forum Discussion

skasper's avatar
skasper
Icon for Responsive Resident rankResponsive Resident
9 years ago
Solved

Active Employees per Period

Hi,   struggling with what should be simple. I have two tables ('crm_employees' and 'DimDates'). There exists a relationship between them (see picture below). What I am trying to calculate i...
Need Help
  • skasper's avatar
    skasper
    9 years ago

    Thank you for the advice. I tried it and do not get the correct result, either. What I do get is the number of employees, who left in a specific period (e.g. month).

     

    As I have to deliver the report today, I resolved to take a different approach, showing the number of joiners, leavers and overall evolution of active personnel as in the chart below.

     

rl_evans's avatar
rl_evans
Icon for Helper II rankHelper II
7 years ago

mtomlinson - The difference with your formula is that it won't include the requisitions that opened prior to the minimun date and are still open.  This may or may not be relevant in your solution.  When counting all active employees within a specified date range, those with a hired date before the date range (and are still active) need to be included.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

rl_evans Actually, I don't see why that would matter - if an employee had a date before the minDate, it would still meet the criteria to be counted...

 

Am I missing something?