I have to calculate the promotion percentage - promotion number/promotion headcount
The Key Logic
Numerator — Promotion Number:
- Count of promotions that happened in that year
- Broken down by Promotion Cycle (1st Jan, 1st July, Off-Cycle)
- Data Type = Promotion
Denominator — Headcount:
- NOT the headcount of the same year
- Instead it uses Dec 31 of the prior year as the snapshot
- So if you're viewing 2026 promotions → denominator = headcount on Dec 31, 2025
- If you're viewing 2025 promotions → denominator = headcount on Dec 31, 2024.
- Data Type = HC
I also have a date parameter, If I am selecting any date from the current year my view show the selected year and selected year -1. (eg - if I am selecting 6/1/2026, my view will show the headcount of 31st dec 2025 in 2026 years and 31st dec 2024 headcount in 2025 years).
Also I am calculating promotion cycle to see the percentage number .
In this image I am getting the promotion numbers correct for the selected year and selected year -1. but I am not able to get the headcount.
Can someone please help me here. Thanks in advance.
#Tableau Desktop & Web Authoring #Tableau #Desktop
Hi, @ANIMESH UTKARSH
I apologize for the misunderstanding.
Are you looking for something like the attached file? Please take a look.
(Slightly revised the post.)
<sample>
Are the following the HC you need?
