Statistics Collector on Event Create/Update

ana_pc2 — Mon, 13 Jul 2020 05:35:20 GMT

[ FlexSim 20.1.1 ]

Hello!

I want to create a Statistics Collector to keep track of the date of the entry and exit for a item on a processor, but the problem is that it is also possible that the item comes back to the same processor again for another process.

Right now it is updating the old record when the item reenters (because I need to update the exit date for the same name when the item enters. So it will do the same if the item comes back, it will update, not create a new row, only if it has a new item name), so I lose the previous record, and have an updated one...

Does anyone have an idea on how to do keep both records with same item name: update only for exit (EndTime) and create a new row only when the item enters (StartTime)? Could it be done with a custom code at the Row value on the statistics collector Events properties?

My Row Value on the Events properties is the Item Name (return data.item.Name), so it can find it at the Item Column and update the item for the EndTime Column.

Any help is appreciated, thanks for your time!

Re: Statistics Collector on Event Create/Update

mischa_spelt — Mon, 13 Jul 2020 07:58:34 GMT

Below where you set the Row Value, there is a checkbox "Finish involved rows after this event". If you check that for your Processor Exit event, the Statistics Collector will create a new row when the row value is ever seen again after that event.

See StatsCollectorFinishRow.fsm

Re: Statistics Collector on Event Create/Update

ana_pc2 — Mon, 13 Jul 2020 08:46:29 GMT

Oh, Thanks!! It was easier than I thought 😄

topic Statistics Collector on Event Create/Update in FlexSim Forum

Statistics Collector on Event Create/Update

Re: Statistics Collector on Event Create/Update

Re: Statistics Collector on Event Create/Update