(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.
