Hi Community,
I'm in need of help with the following. I have an employee dataset with their UID, hire date, and term date. I would like to see who was "active" the last 12 months, this would be rolling 12 months for future use, based of the most recent termination date. Any help with this would be greatly appreciated.
Cheers
Gelöst! Gehe zu Lösung.
Thanks for the solution, I was looking for the data to get "taller" not "wider" but I can take this data table and just "pivot" the data and that should solve my problem. Condense all those date columns to one column called "Active Date", and this would make the data "taller"
I'm gonna give that a shot now. Thanks for the help!