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!