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

Thanks ToddChitt for the file! I got lost with so many joins and following your guide I didnt get to the same result, luckily your file make it clearer.

By looking at your result, I think we are spreading in every place... I am not even sure if we need to do the join to be honest.

The main goal is to get the utilization of the robots for day, month. Utilization group per city, region and country. The calculation should be easy enough easy:

Total Used / (Total Robots * 10hours * Working Day).

The Total Robots should be distinct count from table List "A PART"
We have to make sure that it is the Total Robots and not the number of working robot.
So, for Kyoto, I have 5 robots, Montreal 2, New York 3... Which I indicate in the table (top right).



If we follow that equation, we should get the correct result for all. My bad for all the confusion (I got confused myself). 

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 :).