We are using Domo to visualize our manufacturing data. There are planned hrs based on the number of parts and the amount of time it should take to manufacture those parts. Then there are actual hrs, which is how long it actual takes to manufacture those parts. Efficiency is calculated by dividing the planned hrs by the Actual hrs. There is downtime daily which causes a loss in efficiency. Need to show how much impact that downtime is having to our efficiency. Need to be able to drill down on that loss from a Team→Station→Issue→Shift. For each level of calculation the plan hrs and act hrs needs to be stay the same. Due to downtime varying from team to team, day to day and shift to shift struggling to keep the plan hrs and act hrs consistent through all levels of the drill down.
This is what a dataset might look like over a few days. What is the most efficient way to aggregate the act hrs and planned hrs so they remain the same as you drill down?