topic Re: Data table or dashboard. in FlexSim Forum

Data table or dashboard.

samuel_patarroyodiaz — Thu, 10 Apr 2025 19:38:59 GMT

[ FlexSim 25.0.2 ]

Hello!

I'm looking for a dashboard or a table that allows me to extract the stay time bar by processor, but by items.

I found this dashboard where I see the different states of the machine), but it only gives the total,

And I need something like this:

Is there any way to do it ?

Thank you !

Re: Data table or dashboard.

moehlmann_fe — Fri, 11 Apr 2025 07:30:53 GMT

Yes, you can build a custom Statistics Collector for this.

state-times-by-item.fsm

A label array denotes which state time should be tracked. Based on that a column set is created. When an item enters the processor, the collector stores the current total times in each state in a row label. When the item exits the state columns are updated with the difference between the totals at that point and the previously stored values.

In a combiner this will only work for the container item, since all other items will be placed in the container item immediately and thus not spend any time in the combiner itself. So you might want to restrict the Statistics Collector to only trigger for items entering through port 1.

state-times-by-item_1.fsm

Re: Data table or dashboard.

samuel_patarroyodiaz — Fri, 11 Apr 2025 19:06:12 GMT

Hello

Thanks @Felix Möhlmann

I did the same in my model, but the time column doesn't appear in the table

I haven't been able to configure the Label, i take (add Array Label)

I changed the group name in the code to set values.

but I'm not sure if I need to change anything else in the code.

Model2.fsmIf you can help me

Re: Data table or dashboard.

moehlmann_fe — Fri, 11 Apr 2025 21:26:49 GMT

Double click on the array value field and a window should open in which you can add entries to it. Use the script console to check the state numbers of various states through the defines (for example STATE_PROCESSING or STATE_SETUP which would return 2 and 21 respectively).

You need to define that the exit event should update the state columns.

And in your model you currently listen to the events of a separator. The Statistics Collector will only work for the first item properly since the others are created when the process time elapses. The state times for those items will always be 0. You can ignore them by only having the Stats Collector react to the On Exit event when a row for that item already exists (see the second model I attached in the answer).

Re: Data table or dashboard.

samuel_patarroyodiaz — Tue, 15 Apr 2025 12:43:17 GMT

@Felix Möhlmann Thanks, worsk great.