Forum Discussion
Advocate IHelp: Traffic Light Staff Capacity formula
Advocate IHi,
Thanks for that, it didnt work, but i think it might be because I need to link it to the indivdual/unique staff members.
ie bob is 37.5, sally is 20 hours, jane is 30 hours which is under the employee tab.
do you know how I can get the free time formula to filter on each of the staff members capacity and not the whole group?
thanks
kelz
Community SupportHi,
According to your description, I can roughly understand what you want to get. But I find it hard to create the test data based on your requirement details. Would you like to post some sample data in table form or pbix file(without sensitive data) and your expected result(like the chart you want to get and the correct measure value based on your sample data)?
Thanks very much!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Kelz
Hi,
Here is the table examples
Timesheet data
Date hours Employee Project 1/10/2021 4 Bob Project 1 1/10/2021 2 Sally Project 3 1/10/2021 4.5 Jo Project 5 1/10/2021 5 Randy Project 1 1/10/2021 3.75 Sandy Project 3 1/10/2021 3 Tina Project 5 1/10/2021 4 Tim Project 1 1/10/2021 4 Roger Project 3 1/10/2021 4 Bob Project 1 1/10/2021 2 Sally Project 3 1/10/2021 4.5 Jo Project 5 1/10/2021 5 Randy Project 1 1/10/2021 3.75 Sandy Project 3 1/10/2021 3 Tina Project 5 1/10/2021 4 Tim Project 1 1/10/2021 4 Roger Project 3 4/10/2021 4 Bob Project 1 4/10/2021 2 Sally Project 3 4/10/2021 4.5 Jo Project 5 4/10/2021 5 Randy Project 1 4/10/2021 3.75 Sandy Project 3 4/10/2021 3 Tina Project 5 4/10/2021 4 Tim Project 1 4/10/2021 4 Roger Project 3 staff table:
Employee Capacity Bob 40 Sally 20 Jo 45 Randy 50 Sandy 37.5 Tina 30 Tim 40 Roger 40 Thanks 🙂