Forum Discussion

hnam_2006's avatar
hnam_2006
Frequent Visitor
1 year ago

Calculate resource utilization

Hello all, i need help to write measure which shows resource utilization by taking into consideration only working days of the resource. Main reason to do so is to see if resources are under utilize...
Need Help
hnam_2006's avatar
hnam_2006
Frequent Visitor
1 year ago

bhanu_gautam Thanks for the response but i still am facing same problems.

You are suggesting i create seperate measures for each resource planned allocation, actual allocation and total available hours.

In this case, i need to create a seperate page for all resources

but i am looking also overall page and in this case, i am not sure how to get it to work

 

below you can see, 

Emily davis is working only monday and friday but hours planned and actual are splitting for all working days

 

  • hnam_2006's avatar
    hnam_2006
    Frequent Visitor
    1 year ago

    Could anyone throw light on this please? need to find a way for me to include , in calculation. only the working hours of a person and not the weekly working hours. A person works part time and another full time. How can i approch the solution here?
    Any help is appriciated 🙂 thanks