Forum Discussion

bskiran1711's avatar
bskiran1711
Regular Visitor
1 year ago

Overutilised Resources

I have the below sample data

 

NameDtTotal Worked HoursAlloted Production Hours
A12/1/20257570
A12/2/20258085
A12/3/20259590
A22/1/202565

60

 

A22/2/20257075
A22/3/20256865
A32/1/20257075
A32/2/20258085
A32/3/20259095

 

 

I need the below transformation of the data

 

Total Worked HoursAlloted Prod HoursResources Over UtilisedUnutilised Prodn HoursTotal Emp
693700273

 

I am stuck in calculating the Over utilised resources, the tricky part is there would be slicers as well. So while calculating Over utilised resources, Alloted Prod Hours needs to be aggregated along with Total Worked Hours for each Employee for the selected date. Then check how many employees are having efficiency more than 1. Efficiency is Total Worked Hours / Alloted Prodn Hours. Please help me in achieving the above result

11 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    What does "over utilized"  mean?  Worked more than allotted? Does that reset each day or is it cumulative?

     

     

    So A1 and A2 are overutilized by a cumulative 8 hrs and 3 is underutilized by 15  resulting in a total of 7 ?

     

     

     

    • bskiran1711's avatar
      bskiran1711
      Regular Visitor
      1 year ago

      Hi,

      Thanks for the reply, 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

      So A1 and A2 are overutilised. Hence 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, Hence overutilised is 0

       

      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