LOCATION | FACILITY | WAITING TIME |
---|
LOCATION 1 | FACILITY 1 | 10 SECS |
LOCATION 1 | FACILITY 2 | 5 SECS |
LOCATION 1 | FACILITY 3 | 20 SECS |
LOCATION 2 | FACILITY 1 | 10 SECS |
LOCATION 2 | FACILITY 2 | 0 SEC |
LOCATION 2 | FACILITY 3 | 10 SECS |
| | |
I need to calculate the average waiting time and make it appear in a text box for both locations should be ( 9.2 SECS) average waiting time for location 1 should be (11.7 SECS) and location 2 should be (6.7 SECS) and also make the individual value appear as it gets filtered from the other tables.