topic Re: How can i do a dashboard from a global table? in FlexSim Forum

How can i do a dashboard from a global table?

maira_a — Wed, 04 Dec 2019 19:46:39 GMT

[ FlexSim 19.0.0 ]

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?

Re: How can i do a dashboard from a global table?

JordanLJohnson — Wed, 04 Dec 2019 20:04:59 GMT

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.

Re: How can i do a dashboard from a global table?

tanner_p — Wed, 04 Dec 2019 21:03:40 GMT

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.

Re: How can i do a dashboard from a global table?

maira_a — Thu, 05 Dec 2019 12:18:06 GMT

@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

Re: How can i do a dashboard from a global table?

maira_a — Thu, 05 Dec 2019 13:42:11 GMT

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

Re: How can i do a dashboard from a global table?

JordanLJohnson — Thu, 05 Dec 2019 15:10:15 GMT

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.

Re: How can i do a dashboard from a global table?

maira_a — Mon, 09 Dec 2019 12:01:43 GMT

Thank you so much @jordan.johnson!!