Calculated Table Update Interval

Question

question

GyeungRyul L asked Jan 28, '20 GyeungRyul L commented Jan 31, '20

Calculated Table Update Interval

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

Software Version:

FlexSim 20.0.0

calculated table update dashboard chart calculated table update

update-interval.fsm (56.9 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2020-01-30T16:55:56Z

Jordan Johnson answered Jan 30, '20 GyeungRyul L commented Jan 31, '20

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

update-interval-modified.fsm (577.0 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

GyeungRyul L commented · Jan 31, 2020 at 12:42 AM

Thanks you very much! :)))

0 ·

question