Forum Discussion

skasper's avatar
skasper
Responsive 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.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

rl_evans I've done a bit of testing and this does seem to be the case

rl_evans's avatar
rl_evans
Helper II
7 years ago

Anonymous - That goes back to any visual that is counting active requisitions needs to be based on a calculation that can ignore the date context (when there is an active relationship between date and ApprovedDate.