topic Re: Calculated Table Update Interval in FlexSim Forum

Calculated Table Update Interval

gyeungryul_l — Tue, 28 Jan 2020 06:45:51 GMT

[ FlexSim 20.0.0 ]

Hi,

I trying to draw my custom racks data to dashboard time plot using Calculated Table joins.

My problem is 'Calculated Table joins' update interval 'Always' is not working but only 'Manual' is working. i wanna use this 'Calculated Table joins' Table to calculate another data like throughput or some data, but i can't do that in this situations.

I try to use this code, but everytime it update calculated table's display format is reset

Object table1 = model().find("Tools/CalculatedTables/CalculatedTable1");
function_s(table1, "update",1);

how do i solve this problem.

update-interval.fsm

Re: Calculated Table Update Interval

JordanLJohnson — Thu, 30 Jan 2020 16:55:56 GMT

This looks like a bug in the query. I'll put it on the dev list.

However, you can get the table you wanted without using a calculated table. In fact, the model will run much faster if you don't use a Calculated Table to get this kind of data. I made a Statistics Collector that increments a Content column every time an object enters one of the Import group objects, and decrements every time something exits. Then I made a second collector that reports that first value every hour.

update-interval-modified.fsm

Re: Calculated Table Update Interval

gyeungryul_l — Fri, 31 Jan 2020 00:42:17 GMT

Thanks you very much! :)))