How can i do a dashboard from a global table?

Question

question

Maíra A asked Dec 4, '19 Maíra A commented Dec 9, '19

How can i do a dashboard from a global table?

I have a global table that is changing the values continuously and i would like to see this changes in a dashboard. How can i do that?

Software Version:

FlexSim 19.0.0

global table dashboards

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 · 2019-12-04T20:04:59Z

Jordan Johnson answered Dec 4, '19 Maíra A commented Dec 9, '19

You can use a calculated table with this query:

SELECT * FROM GlobalTable1

You should probably set the update mode to Always, so that the calculated table's values match the Global Table's values at all times.

Then you can make a chart using the Calculated Table.

· 3

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.

Maíra A commented · Dec 05, 2019 at 12:18 PM

@jordan.johnson I would like to make a time plot chart from this table, but i'm having difficults to configurate that. Can you give me some help?

table-chart.fsm

0 ·

table-chart.fsm (24.1 KiB)

Jordan Johnson ♦♦ Maíra A commented · Dec 05, 2019 at 03:10 PM

In your model, I see that you are writing to 3 values in the global table every 10 time units. If you want to see those values over time, you need to find a way to record those values over time. I did this with a Statistics Collector in the attached model:

table-chart-modified.fsm

The statistics collector adds a new row for each token that enters the Custom Code activity. Each row records the time. Each row also records the token's modelo label, and the token's tipo label. So every 10 seconds you get three rows. Then you can use the chart to plot tipo vs time, and split by the modelo values. That shows each modelo in a different color.

1 ·

table-chart-modified.fsm (25.5 KiB)

Maíra A Jordan Johnson ♦♦ commented · Dec 09, 2019 at 12:01 PM

Thank you so much @jordan.johnson!!

0 ·

Answer 2 · 2019-12-04T21:03:40Z

tannerp answered Dec 4, '19 Maíra A commented Dec 5, '19

Hi @Maíra A,

You can insert a Table object into a dashboard and then link it to the Global Table using the eyedropper tool.

1)

2)

dashboard-table.png (23.6 KiB)

dashboard-table.gif (155.4 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.

Maíra A commented · Dec 05, 2019 at 01:42 PM

This is also a good option! Thanks @tanner.p

0 ·

question