Forum Discussion
Cumulative Distinct Employee Count with Multiple Filters
Hi, I have an employee snapshot taken monthly and I need to do get a distninct active employee count every month. I have seen several examples and still cannot get it to work correctly. My pro...
Here is one possible implementation. It uses a disconnected calendar table.
Active would employees that are not terminated and hired before a month. The key issue is that the graph is supposed to be rolling twelve months but I have many employees hired years ago. Thanks
| Employee | Contract | Hire Date | Termination Date | Cost Center | Unique ID |
| Bob | A | 4/1/2020 | Test | Bob-A | |
| Tom | B | 7/1/2021 | 6/1/2022 | One | Tom-B |
| John | C | 12/1/2021 | JW | John-C | |
| Mary | A | 5/1/2016 | HP | Mary -A | |
| Steve | C | 1/1/2022 | 4/1/2022 | SDS | Steve-C |
Here is one possible implementation. It uses a disconnected calendar table.