I am using this formula to calculate terminated employees:
COUNT(DISTINCT CASE WHEN `WD Event Type`= 'Termination' AND `WD Record Type`= 'Activity' THEN `WD Employee ID` END)
I need to modify it so it will include a number for the PREVIOUS MONTH each time that I use it.
End goal: I plan to use this count in a drill path table to present ONLY terminated employees from last month. If you have a better idea on how to go about it I would greatly appreciate it!
Thank you in advance!
