We want to retrieve all employees active in 2025.
We are using the Year object under Time folder but if we use it all data seems lost, are we doing anythig wrong?
we tried also with Headcount metric
I do not have the instance handy, but can you see if Hire Date and Termination Date are available in the Subject Area and following logic can give you active employees in 2025
Hire Date <= '31-Dec-2025' AND (Termination Date IS NULL OR Termination Date >= '01-Jan-2025')
