Forum Discussion

jaysoulz's avatar
jaysoulz
Icon for Helper I rankHelper I
3 years ago
Solved

Matrix Table Hierarchy Display Daily/Monthly/Yearly Result

I am facing an incorrect aggregate calculation to display the different levels of the hierarchy from the Matrix table.   I want to show the result daily, monthly and if possible yearly, but looks l...
Need Help
  • jaysoulz's avatar
    jaysoulz
    3 years ago

    Finally found the solution.

     

    No joint was necessary.

    Creating a measure to count the number of robots, modify the TotalUsed hours by amending the 

     

    UtilizationRobot = DIVIDE([Utilization],[RobotCount])

     

    By linking the relationship correctly and all work.

     

    Again, thanks to ToddChitt for the great help! I have learnt a lot! 🙂

     

jaysoulz's avatar
jaysoulz
Icon for Helper I rankHelper I
3 years ago

Finally found the solution.

 

No joint was necessary.

Creating a measure to count the number of robots, modify the TotalUsed hours by amending the 

 

UtilizationRobot = DIVIDE([Utilization],[RobotCount])

 

By linking the relationship correctly and all work.

 

Again, thanks to ToddChitt for the great help! I have learnt a lot! 🙂

 

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
3 years ago

jaysoulz Glad you figured it out, even if it was not my solution that worked in the end. But if I was that much help, kudos are greatly appreciated :).