Stats Collector: How to reference previous row data when adding a row

Question

question

Patrick Cloutier asked Aug 12, '21 Eric M answered Aug 12, '21

Stats Collector: How to reference previous row data when adding a row

In the very simple attached model I'm trying to calculate the time between part arrivals using a stats collector.

So 1st column is arrival time. 2nd column needs to be arrival of previous row. And then 3rd column will be 2nd column - 1st column.

But I can't figure out how to reference the previous row data in the "Row Add Value" field of the 2nd column.

Is that possible?

StatscollectorPC.fsm

Software Version:

FlexSim 21.1.5

flexsim 21.1.5 stats collector

statscollectorpc.fsm (566.4 KiB)

Answer 1 · 2021-08-12T16:01:21Z

Eric M answered Aug 12, '21

Hi @Patrick Cloutier, you can use the stats collector as a table which comes in handy. You can use code like this in the row add / event value to get the previous row's data:

collector.as(Table)[data.rowNum - 1]["desired column"]

You can do something similar to subtract the 2 columns from each other in your 3rd column.

statscollectorpc_1.fsm

statscollectorpc-1.fsm (567.5 KiB)

question