Forum Discussion

bskiran1711's avatar
bskiran1711
Regular Visitor
1 year ago

Overutilised Resources

I have the below sample data   Name Dt Total Worked Hours Alloted Production Hours A1 2/1/2025 75 70 A1 2/2/2025 80 85 A1 2/3/2025 95 90 A2 2/1/2025 65 60   A2 ...
bskiran1711's avatar
bskiran1711
Regular Visitor
1 year ago

Hi,

 

Would you be able to help me on this?

 

Thanks

Kiran

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Your new requirements are unclear for me. 
    Please show the expected outcome based on the sample data you provided.

    • bskiran1711's avatar
      bskiran1711
      Regular Visitor
      1 year ago

      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