question

bcallaghan avatar image
0 Likes"
bcallaghan asked bcallaghan commented

How to utilize Global Table data in a dashboard?

How do I use global table data in a dashboard? I have part numbers with their respective process times being populated into a global table as they reach a sink and want to utilize this data in a dashboard setting to visually understand process time variation between part numbers. Any thoughts on how to do this? Thanks.

FlexSim 21.2.4
global tabledashboards
5 |100000

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

1 Answer

·
Jeanette F avatar image
1 Like"
Jeanette F answered bcallaghan commented

Hello @bcallaghan,

You can use a calculated table to gather information from the global table. In my example I group the entries by type and average the time.

1701205986880.png

Calculated Table Group By.fsm

Let me know if you need help generating a statistic or have further questions.


· 3
5 |100000

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

bcallaghan avatar image bcallaghan commented ·

@Jeanette F , thanks for the start. Here's an example of the global table I'm pulling from, for some reason your SQL isn't working for me, even with my own labels. This global table is being continually built as flowitems reach a sink and write their data to this table. Could that be preventing the code from running properly?



0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ bcallaghan commented ·

Hello @bcallaghan, Can you reupload your image? Have you changed it to update always? Can you provide your model or an example model?

0 Likes 0 ·
bcallaghan avatar image bcallaghan Jeanette F ♦♦ commented ·
I was able to figure it out now using your help. Thanks a million!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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