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.
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.
Let me know if you need help generating a statistic or have further questions.
@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?
Hello @bcallaghan, Can you reupload your image? Have you changed it to update always? Can you provide your model or an example model?
17 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
