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 need to calculate tenure in Tableau? You're probably looking for the DATEDIFF function! You indicate your date unit, a start date, an end date and let Tableau do it's thing. Simple as that, right?
Not necessarily!
What if someone started on January 1st and has been at your organization for 364 days. If you ask for a date difference in years, Tableau will say that person has been there 0 years!
Check out this video to learn how to calculate tenure using whole date units, fractional date units (e.g. 0.8 of a year) and how to create tenure buckets to display how many people have 0-1 years of experience, 3-5 years of experience or even 10+!
Access/download the Tableau Workbook from the demo here.
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!