I have an application that shows hours broken down by Towers and by type. For example, I have Towers A-G. There are graphs that show time split in a variety of ways for each tower. For example, there is a graph that shows the Capital Hours % vs Operating Hours % and another graph that splits out the time between 4 different project 'worktypes'.
I need to reflect targets for each tower in my graphs like this:
Tower | Capex | Opex | Type 1 | Type 2 | Type 3 | Type 4 |
A | 21% | 79% | 7% | 8% | 82% | 3% |
B | 39% | 61% | 7% | 8% | 0% | 85% |
C | 43% | 57% | 7% | 8% | 17% | 68% |
D | 48% | 52% | 7% | 8% | 20% | 65% |
E | 11% | 89% | 7% | 8% | 71% | 14% |
F | 36% | 64% | 7% | 8% | 24% | 61% |
| | | | | | |
Combined | 38% | 62% | 7% | 8% | 32% | 53% |
I do not know where to even start without even thinking about what should be displayed if multiple towers are selected. I am open to suggestions!