Decision based on census

Question

question

Kathrin S asked Jul 19 2021 at 8:17 AM Eric M commented Jul 23 2021 at 10:25 PM

Decision based on census

Hello.

How can I send patients at a decision point based on the census to a different path? For example, patients should always take path 1 but if the census is over 15 then choose path 2.

In addition, it would be great if the census were only used for certain patients. I have assigned patients to their medical discipline as a label. Can the census only be given for two of these disciplines? For example, for patients in trauma surgery and urology.

Thanks a lot!

Software Version:

FlexSim 20.2.3

flexsim 20.2.3 decision points census

· 1

Eric M commented · Jul 23 2021 at 10:25 PM

Hi @Kathrin S, was Matthew Gillespie's answer helpful? If so, please click the red "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2021-07-19T17:55:15Z

Matthew Gillespie answered Jul 19 2021 at 5:55 PM

You can use the getcensus() command to get the current patient census in the whole model. You can also pass in a location group to get the census within that location group:

getcensus(Group("ExamTables"))

If you want to get the census of patients with a certain label value you'd need to query the Census History table with a query like this one that returns the census of patients with a PCI label of 2:

string query = "SELECT \
SUM([CensusHistory.StatisticsCollector].[InOut]) \
FROM[CensusHistory.StatisticsCollector]\
JOIN[PersonLabels.StatisticsCollector] ON [PersonLabels.StatisticsCollector].[PID] = [CensusHistory.StatisticsCollector].[PID]\
WHERE[PersonLabels.StatisticsCollector].[PCI] = 2";
 
Table result = Table.query(query);
if (result.numRows > 0)
    return result.executeCell(1,1);
else
    return 0;

question