Glad you asked. Here's the end goal. I have a Company table and a People table. In the people table, I assign people to different Instantly email campaigns based on their attributes and their company's attributes. I wanna create a new email campaign that roughly says something like this:
Noticed that XYZ recently left the company. It sucks when that happens. Other [job function] people have to do ABC. You don't know when this would happen again. Use my services so you don't get impacted as badly next time it happens".
Now, to do this, I want to add a column in the Company table that lists the number of people with particular titles who left that company in the last 6 months. If we can't list, then count. So, it's very much like the Find Employee Headcount by Criteria except I want to Find Ex-Employee Headcount by Criteria
.png){kind=logo}
