Tutorial
📈 Lucid expert tip: Build a live headcount and vacancy tracker using org charts
Keeping track of open roles across a growing company can be a moving target. This video shows you how to combine org charts with dynamic shapes to create a live dashboard that counts filled versus vacant positions automatically.
What you’ll learn:
- How to use the
descendants of pageformula to capture data across your entire organizational hierarchy. - How to write
count ifformulas to dynamically filter and total roles based on their status. - How to visualize your headcount data using a dynamic donut shape that updates in real-time.
- How to pair your visual charts with interpolated text to display clear, numerical summaries of your organization's growth.
⚙️ A note on the UI
This video was produced around 2024. While the Lucid interface has been updated since then, the formula logic and dynamic shape functionality remain a powerful way to manage your data.
How are you tracking your team's growth? Share your favorite org chart hacks in the thread below!
Your privacy choices
