Forum Discussion
Overutilised Resources
That is not clear from the sample data. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Hi,
My sincere apologies.
If 2/1/2025 is selected in Slicer,
A1 has worked for 5 hours more,
A2 has worked for 5 hours more
A3 has worked for 5 hours less
A4 has worked for 5 hours more
So A1 , A2 and A4 are overutilised. Since A1 is Mgmt resource and should not be counted as Production resource, Overutilised resources are 2.
Similarly if 2/1/2025 and 2/2/2025 is selected
For A1, A2 and A3 have not worked for more than Alloted Production hours,A4 has worked 8 hours more, hence overutilised is 1
Thanks
Kiran
How does this impact the other metrics you need? Will "Unutilized Production Hours" and "Total Employees" now be calculated differently too?
Ideally they should change, but our Leadership team wants to see Mgmt resources Production Hours to be aded in Aggregate.