question

Tee Hiett avatar image
1 Like"
Tee Hiett asked Tee Hiett commented

How do I get patient wait for Exam Room by provider?

2020-master-model-01-29-2020.fsm

I am trying to get time patients wait for exam room by provider (or preferably by the 5 groups of exam room locations). You can see my attempt in CalculatedTable1 in the attached model.

Thanks,

Tee

FlexSim 20.0.2
statistics collectorssubsetscalculated tables
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Brittany Evans avatar image
1 Like"
Brittany Evans answered Tee Hiett commented

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


· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Tee Hiett avatar image Tee Hiett commented ·

Thanks, Britany. This is really helpful.

Tee

0 Likes 0 ·
Cliff King avatar image
0 Likes"
Cliff King answered Tee Hiett commented

Can you use the standard "Avg Milestone-Milestone Times" bar chart (milestone RequestTable to GotTable times) and then partition by the "Provider" patient label like I've done in the attached model?

2020-master-model-01-29-2020-ck.fsm

· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Tee Hiett avatar image Tee Hiett commented ·

master-model-01-31-2020.fsm

Thanks, Cliff.

Sorry, I didn't ask the right question. I really wanted see how to get the wait time by Provider using the waiting line stay time. I'm using this model to learn about Flexsim 2020 rather than wait for questions about actual working models. If fact, the attached model was adapted from working model we used in a project last year. If you examine the dashboards in the attached model you will see some of the charts developed from milestones. We use these types of chart frequently to try to focus the practitioners attention on distributions rather than averages.

The Calculated Table I would like to learn how to use properly is the CalculatedTable1. I would appreciate any help you could provide.

Thanks,

Tee

master-model-01-31-2020.fsm

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.