How to create Utilization box plot per type of ressource and per day

Question

question

Nicolas Mbz asked Jul 05 2024 at 8:29 AM Nicolas Mbz commented Dec 20 2024 at 12:41 PM

How to create Utilization box plot per type of ressource and per day

Hi !
I would like to have an utilization rate indicator per group of type of ressource and per day.
1) Is there something existing ?

2) If not, I imagined something with a boxplot

Where each point is the utilization rate of one ressource per day (x split by Type, color split by day).

How to create the statistics collector for this blox plot ?

Thanks in advance

Here a model to try...

BasicProcessorsModel.fsm

Software Version:

FlexSim 23.2.3

statistics collector utilization box plots

1720167192907.png (218.9 KiB)

basicprocessorsmodel.fsm (44.4 KiB)

Answer 1 · 2024-07-05T11:09:11Z

Felix Möhlmann answered Jul 05 2024 at 11:09 AM Nicolas Mbz commented Dec 20 2024 at 12:41 PM

No there is nothing like this currently available as a premade chart in Flexsim.

You can build this yourself quite quickly if you start out with the Utilization vs. Time collector shown here. After adding it to the model and editing its labels to the correct values (group of objects, state table, one measurement per day), you only need to add columns to denote the type of the object and the week day.

basicprocessorsmodel-fm.fsm

basicprocessorsmodel-fm.fsm (643.2 KiB)

· 6

Nicolas Mbz commented · Jul 05 2024 at 2:51 PM

Hi @Felix Möhlmann , Thanks a lot for your answer. That's very clos that what I need.

Understanding this SC (and SC in general) is a catastroph for me. I tried to modify myself but without succes.

1) Model start at Monday 00:00:00 and finish Saturday 00:00:00 (5 exact days).

> How to do for having the measures from Monday to Friday ? (Without Sunday and with Friday)

2) Some points are at 0% while the gantt shows that no ressource is used at 0% (on Monday for exemple).

> Why ?

0 ·

Felix Möhlmann Nicolas Mbz commented · Jul 05 2024 at 3:24 PM

1) With how the collector is designed the initial event at time 0 has to happen to initialize the row label that keeps track of the total utilized time of the objects. So the "Sunday" data must be collected. But you can use a Calculated Table to filter them out later.

To include the Friday, other than running the model for a tiny amount of time past midnight, you can make the inital event non-repeating and add a copy of it that is which fires just ahead of midnight each day.

basicprocessorsmodel-fm_1.fsm

2) Your pictures didn't upload but I assume you are talking about these points?

I have no clue why they are there. They are not part of the collected data. And they only appear after the thursday measurement. So I guess it is some quirk/bug with the box plot chart. The same points appear in your example screenshot in the question.

0 ·

1720192799260.png (52.4 KiB)

1720193001367.png (26.0 KiB)

basicprocessorsmodel-fm-1.fsm (649.0 KiB)

Nicolas Mbz Felix Möhlmann commented · Jul 08 2024 at 11:49 AM

Hi @Felix Möhlmann

1) Ok that fits my need, thanks a lot

2) You're right, these points are showed but are not from de data. Is it a bug to fix @Jordan Johnson ?

Thanks !

0 ·

Show more comments

question