Forum Discussion
calculate average wait time
I have 3 columns.
1. A column that has all the states
2. A column that has the wait times of patients who needed to see a doctor.
3. A column that has the Doctors who works in a particular network. N stands for in network and Y stands for out of network which I filtered out.
I’m trying to calculate the average wait time by state who's in network. looking for the correct measure to use. I need to display the average wait time in a line chart.
| Column1 | Column3 | Column4 |
| VT | 0:00:34 | N |
| VT | 0:00:59 | N |
| VT | 0:00:45 | N |
| VT | 0:00:37 | N |
| VT | 0:00:21 | N |
| VT | 0:00:17 | N |
| VT | 0:00:20 | N |
| VT | 0:01:09 | N |
| VT | 0:00:24 | N |
| VT | 0:05:57 | N |
| VT | 0:00:44 | N |
| VT | 0:01:55 | N |
| VT | 0:01:30 | N |
| VT | 0:02:00 | N |
| VT | 0:01:47 | N |
| VT | 0:00:28 | N |
| VT | 0:00:22 | N |
| VT | 0:00:47 | N |
| VT | 0:00:43 | N |
| VT | 0:02:31 | N |
| VT | 0:00:23 | N |
| VT | 0:00:10 | N |
| VT | 0:06:09 | N |
| VT | 0:02:02 | N |
| VT | 0:04:09 | N |
| VT | 0:01:36 | N |
| VT | 0:01:13 | N |
| VT | 0:03:27 | N |
| VT | 0:04:01 | N |
| VT | 0:02:36 | N |
| VT | 0:02:55 | N |
| VT | 0:07:21 | N |
| VT | 0:12:05 | N |
| VT | 0:06:59 | N |
| VT | 0:05:43 | N |
| VT | 0:01:03 | N |
| VT | 0:06:20 | N |
| VT | 0:04:30 | N |
| VT | 0:03:03 | N |
| VT | 0:06:19 | N |
| VT | 0:04:39 | N |
| VT | 0:03:46 | N |
| VT | 0:04:32 | N |
| VT | 0:02:10 | N |
| VT | 0:05:33 | N |
| VT | 0:02:58 | N |
| VT | 0:02:45 | N |
| VT | 0:17:54 | N |
| VT | 0:07:30 | N |
| VT | 0:04:12 | N |
| VT | 0:00:11 | N |
| VT | 0:07:50 | N |
| VT | 0:08:25 | N |
| VT | 0:16:33 | N |
| VT | 0:04:22 | N |
| VT | 0:06:34 | N |
| VT | 0:02:06 | N |
| VT | 0:06:15 | N |
| VT | 0:03:58 | N |
| VT | 0:01:25 | N |
| VT | 0:02:01 | N |
| VT | 0:00:41 | N |
3 Replies
Okay I will try those. I was under the assumption and average function would be used to calculate avg wait time
that didnt work out for me Greg_Deckler
