How do I delete a row in a stat collector once it's finished?

Question

question

Ashlee W asked Jul 28 2022 at 1:48 PM Jeanette F commented Aug 02 2022 at 11:31 PM

How do I delete a row in a stat collector once it's finished?

Hi There,

How do I delete a row in a stat collector once it's finished? I only want the stat collector table to reflect patients who are currently in a location. Therefore once they leave I would like to delete the row from the table.

I tried the following in a custom code (below) for the "On Row Finished" trigger but I am getting an error saying it cannot delete the row.

collector.as(Table).deleteRow(rowNum)

How do I do this correctly?

Thanks!

Software Version:

FlexSim 22.1.2

healthcare statistics collector delete row

· 1

Answer 1 · 2022-07-28T15:34:14Z

Jason Lightfoot answered Jul 28 2022 at 3:34 PM Ashlee W commented Jul 28 2022 at 4:24 PM

That sounds more like you should be pushing and pulling from a List.

· 3

Ashlee W commented · Jul 28 2022 at 3:55 PM

Can you create dashboard elements from a list though? I think it has to be a stats collector.

0 ·

Felix Möhlmann Ashlee W commented · Jul 28 2022 at 4:05 PM

What you could do is add a column to the statistics collector that reflects whether the row is finished or not. Then you duplicate the collector's table in a calculated table while filtering for "open" rows. The calc. table then feeds the dashboard charts.

0 ·

Ashlee W Felix Möhlmann commented · Jul 28 2022 at 4:24 PM

Okay, that's doable I think. I was kind of assuming that there was some sort of functionality in the stats collector to do this. Thank you!

0 ·

question