Hi,
(I realise the below is quite complicated, but any help would be really appreciated!)
With the below tables, is it possible to create a pie chart that has the list of Runs in the 'Actual Runs' table, in the following segments:
GREEN - Actual Start Time is within 5 minutes of the Scheduled Start Time
AMBER - Actual Start Time is between 5 and 15 minutes of the Scheduled Start Time
RED - Actual Start Time is more than 15 minutes of the Scheduled Start Time
So in this example, by selecting Run1, we would see the chart split three ways, with: 1 green, 1 amber, 1 red. Run6 and Run7 would also not be selectable as they are not in the 'Scheduled Runs' table.
The format for the Time is as follows:
Start/End Time: HHMMSS
155712 = 15:57:12
1533 = 00:15:33
424 = 00:04:24
Scheduled Runs
|
| Run1 | ABC | 153000 | 153005 |
| Run2 | 123 | 235500 | 500 |
| Run3 | XYZ | 900 | 1500 |
| Run4 | 456 | 83000 | 83500 |
Actual Runs
|
| Run1 | C | 152712 | 152911 |
| Run1 | C | 153634 | 153728 |
| Run1 | F | 155034 | 155324 |
| Run2 | F | 235621 | 424 |
| Run2 | C | 1533 | 1756 |
| Run6 | C | 210002 | 210342 |
| Run7 | C | 5626 | 10126 |
Thanks and kind regards,
Tristan
