Statistics Collector - Previous row data replaced with NULL Value

Question

question

Francis Kwa asked Dec 11, '23 Francis Kwa commented Dec 11, '23

Statistics Collector - Previous row data replaced with NULL Value

Statistics Output by Type.fsm SC 2nd hour.jpg SC 3rd hour.jpg

Hello,

Attached model replicated the Statistics Collector Tutorial 2.9 - OUTPUT BY HOUR BY TYPE logic.

However, the replicated statistics collector logic in this model replaced the previous hourly row data with NULL value

Appreciate guidance to resolve this behavior.

Software Version:

FlexSim 23.2.2

statistics collectors

sc-2nd-hour.jpg (333.5 KiB)

sc-3rd-hour.jpg (305.6 KiB)

statistics-output-by-type.fsm (47.2 KiB)

Answer 1 · 2023-12-11T07:24:32Z

Felix Möhlmann answered Dec 11, '23 Francis Kwa commented Dec 11, '23

You put the fields of the "Output" column in the wrong order. In your model, when the "Finish" event fires, the column value is updated to None, rather than the current output.

You also need to uncheck the option to keep labels for finished rows. Otherwise the stored values will be cumulative rather than per hour.

1702279398155.png (3.8 KiB)

1702279418550.png (23.2 KiB)

· 1

Francis Kwa commented · Dec 11, 2023 at 02:34 PM

Thanks for the guidance.

0 ·

question