Two leavers mean different things in a team of four and a team of forty
Headcount reporting gives absolute numbers, and absolute numbers mislead at a small scale. Two leavers from a team of four are a serious matter. Two leavers from a team of forty are something that can happen in a single month.
Joiners and leavers in the same month can net to zero. That net figure hides a high amount of disruption.
Open roles belong in the same report, because they change how the figures read. A team that has lost two people and has two approved vacancies is in a different situation from a team that has lost two people and has no vacancies.
Time-to-fill is the figure hiring plans are based on. A plan that assumes six weeks when the real figure is fourteen weeks fails in a particular, foreseeable month.
How the ActionFlow runs on the canvas
A Start Scheduled node runs monthly and reads the current establishment, the people who joined and left during the month, and the open requisitions.
A Math node computes the figures that matter: headcount by team, with joiners and leavers given separately rather than combined, and leavers as a proportion of team size. That proportion is what makes a small team's numbers readable.
A Filter node suppresses the detailed breakdown by team when the team size is below a threshold, and reports those teams in a grouped category instead. The headcount for a team of three is individual information expressed as a statistic.
A Date node computes time-to-fill for roles that were closed this month. A second Math node then computes the rolling average.
A Generate Object node returns the summary as a structure, with the contextualized leaver figure as a field of its own, so it cannot be lost in the prose.
A Generate Text node writes the text for a leadership audience. A Create Excel node creates the table. A Notion node stores both the text and the table.
A Slack node notifies the named recipients. It does not send the figures into the channel.
Nodes this ActionFlow uses
- Start Scheduled: runs the summary monthly.
- PostgreSQL (Data): reads establishment, joiners, leavers, and open roles. Airtable fits the same slot.
- Math (Util): computes headcount by team and leavers as a proportion of team size.
- Filter (Data): suppresses per-team breakdown below a size threshold.
- Date (Util): computes time-to-fill on roles closed this month.
- Generate Object (AI Core): keeps the contextualized leaver figure as its own field.
- Create Excel (Data): produces the table. Notion archives it.
- Slack (Communication): notifies named recipients rather than broadcasting.
Frequently asked questions
Start building AI workflows
Create a free account, open a template or a blank canvas, and run your first ActionFlow.
Newsletter
Get product updates
New nodes, agents, and product notes. We send mail only when we have something worth opening.