How to Calculate Running Headcount in Tableau with Start and End Date Fields

By: Eric Parker

Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can follow him on LinkedIn or sign up for a Tableau Office Hour to work with him directly!

Do you want to use Tableau to look at running headcount over time? For example, you work with employee level data which has Start Dates and End Dates and you'd like to be able to see how the total active headcount at the company has changed over the last 8 quarters.

That's something Tableau can do, but it isn't going to work out of the box. It's going to take some creative data structuring and calculations to get things working.

Check out this video to learn about a couple approaches you can take to visualize running headcount in Tableau!

Related Resources:

Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!

Data Dashboard Design Best Practices

Parameter-Driven Reference Lines in Tableau

0