question

I was looking at your example model and was able to get your calculated table to show the average wait times for the Exam Rooms based on provider. There were a few things that I needed to change to make it work correctly from what you had.

• On your Tables/Metric Tab of your Calculated Table, I first noticed there was an issue with your LocationGroups Join. It looks like you were trying to join the Location column with the PID column of your PersonWaitForLocationHistory table (PersonWaitForLocationHistory.PID). I changed this so the Location columns of both tables were used for the join.
• When you use a column to break up your data such as the Provider or Location, you do not need to include those columns as metrics. In the case of your model, you do not need to include them as Metrics on your Tables/Metrics Tab so I removed them.
• If you are trying to get a data point for every individual that you had to wait for the Exam Room, then what you currently have in as the Metric for WaitForTable is correct. This is what you would use if you wanted to make a boxplot or histogram. If you are just wanting the average time patients wait for an Exam Room, then I would change the Metric you currently have in there. You would want to use the Aggregated Time Span option found under Time Span Metrics. The attached model uses the method for getting the Average time.
• The next issue I ran into was on your Subsets Tab. It looks like you were trying to find a way to only get Exam Locations in the subset. Your filter was very creative and for a while I was not sure why it didn’t work, but then I realized that location fields are not strings. In fact, they are ids that display as the names of the objects when you look at them in tables. In order to isolate only exam tables, I had to delete that Subset and create a new one. I used the “Add subsets from HC Groups and Objects” option to only display the data for Exam Rooms. Since all your Exam Rooms were already in a group, I was able to just select that group from the list. If you hadn’t had a group, I would have created one because groups are an easy way to filter out information about locations you are not interested in. I have used this method in other models. In the attached model, I put in the new subset and just selected your ExamTables Group. If you want the Exam Tables to be grouped as a single statistic, you can select the “Each group as a whole” option for Include data for. If you want just the individual locations, you can select the “Each member of each group” option. If you want to see both, which I did in the attached model, you can select the “Each group and each member” option.
• Lastly and most important to your questions was how to display it by Provider. For this I added in a partition to your Partitions/Soring Tab. Partitioning is a way to break up data into unique groups. With Subsets, you can have data points belong to multiple Subsets. With Partitions, data point will belong to a single Partition. In our case, patients are only seeing one Provider so we can Partition based on a Patient Label and select our Provider label.
• I had the table Sort the Results based on Provider by checking the check box at the bottom of the Partitions/Sorting Tab.

25373-master-model-01-31-2020-edited-calculated-ta.fsm