Scenario Chart - Including extra patients in milestone-milestone boxplot

Question

question

Lynn T2 asked Apr 28, '22 Lynn T2 commented May 2, '22

Scenario Chart - Including extra patients in milestone-milestone boxplot

Hello! I'm using 21.2.2 ---

I am working on a clinic model. I have 2 process flows (memory and neuropsych). My normal dashboards are giving me the appropriate results (Patient Wait for Exam Room boxplot -- on the "LOS and Wait for Room" dashboard -- is only including patients that pass through the milestones on the memory flow).

However, when I create a Scenario Chart referencing my Patient Wait for Exam Room boxplot (Scenario chart is titled "Wait for Intake" on the "Replications Dashboard"), the boxplots are including the 0s from all of the patients who do not go through the milestones. It is including a sample size of 140 (which includes the neurospych arrivals who are not using the memory process flow -10 per replication for 5 replications - as well as all memory patients - 18 per replication for 5 replications - even memory patients who do not pass through the milestones in the memory process flow).

Is there a step I am missing? If this was a bug that was fixed in a later version, is there a workaround I can do? (Other than exporting the data to analyze). My organization does not do timely updates of FlexSim so updating my software is not a simple fix at the moment.

Thank you!

Lynn Tamblyn

[email protected]

Software Version:

Other (please specify)

Software Version:

Other

milestone-milestone scenario chart boxplot

scenario-1-experiments.fsm (855.2 KiB)

5 |100000

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

Answer 1 · 2022-04-29T07:26:10Z

Felix Möhlmann answered Apr 29, '22 Lynn T2 commented May 2, '22

The actual box plot seems to automatically filter out NULL (empty) values. But the scenario chart does not.

You can however manually do this: Install the components of the source box plot chart (Properties -> Advanced -> Install). Make sure that the settings for the chart are all correct because this will disable some of the property options for the chart.

You should now find a calculated table "Wait for Exam Room CalculatedTable" in the toolbox. This table queries and stores the values that are displayed in the chart. If you run the model and have a look at the table that is generated (Calculations tab in the calc. tables properties), you will see that it contains many empty cells in the "MetricValue" column.

To get rid of these, navigate to the "Subsets" tab and add a new subset with a custom expression - "MetrivValue IS NOT NULL".

The table will now only look for rows with actual values, which should also be reflected in the scenario chart.

scenario-1-experiments-fm.fsm

1651216902149.png (5.9 KiB)

1651216949853.png (21.8 KiB)

1651217033871.png (9.6 KiB)

1651217085142.png (5.8 KiB)

scenario-1-experiments-fm.fsm (920.9 KiB)

· 1

5 |100000

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

Lynn T2 commented · May 02, 2022 at 06:53 PM

Felix,

Thank you so much - your answer was extremely helpful (& detailed) and solved my problem. Have a great week!

Lynn

0 ·

question