Forum Discussion
Helper IMatrix Table Hierarchy Display Daily/Monthly/Yearly Result
Finally found the solution.
No joint was necessary.
Creating a measure to count the number of robots, modify the TotalUsed hours by amending theUtilizationRobot = DIVIDE([Utilization],[RobotCount])
By linking the relationship correctly and all work.
Again, thanks to ToddChitt for the great help! I have learnt a lot! 🙂
Super UserWhat is the formula for the New Utilization?
I get that the lines total to 5.44, but what is the (20 x 10H) portion?
If each DAY had 10 hours of availability, then the total DENOMINATOR is 5 days times 10 hours = 50. So the total utilization for the week should be 5.44 / 50 = 10.88 %.
What am I missing?
Helper IDENOMINATOR is 5 days times 10 hours = 50
Yeah, that's for ONE week. Every business day should be counted in one month. So, February 2023 there is 20 business days.
10 hours x 20 business day = 200 hours in total, so data shows 5.44H used for Feburary, so it should be 5.44 / 200 hours = 2.72% Utilization for February 2023
- ToddChitt
Ah, got it. But for the math to work out, you need to have a CONTIGUOUS Date table that has one row for every day regardless of if machines were used on that day.
Please show sample data for both the Duration data (Used and Idle) and your Date dimension.