Hello community,
I am building a dashboard and I have challenges is getting the number of units per type in each rack. My simulation looks like the picture attached, where each color is a different type.
My dashboard would ideally contain the average stock, current stock by material type. I have been trying but not sure how to break it into different product type.
Hi @GRodea,
It's easier to help when we can look at your model. To receive a more accurate solution, please post your model or a sample model that demonstrates your question.
Proprietary models can be posted as a private question visible only to FlexSim U.S. support staff (you can toggle this question to private). You can also contact your local FlexSim distributor for phone or email help.
Hello Natalie,
Please find attached the model. I like when it is on a different scenario so I can learn the modifications while doing it.
Hi @GRodea,
You can achieve this by using a statistics collector. This article explains the logic behind statistics collectors: https://answers.flexsim.com/articles/105427/visualizing-the-logic-of-the-statistics-collector.html
And there are tutorials available here: https://docs.flexsim.com/en/23.1/Tutorials/AdditionalTools/Tutorial2StatsCollector/StatsCollectorOverview/StatsCollectorOverview.html
The statistics collector in the attached example listens to the entry and exit events of the storage system, with the condition that the storage object is a member of a group called Racks.
The Row Value field of the statistics collector requires double brackets in order to create rows for the different SKUs and different racks, like you described.
The Columns tab of the Statistic Collector Properties window is where you can add the columns for Content and AvgContent. The value for AvgContent is a little tricky, but you can cast the content as a tracked variable to access the average. This is done by setting the value to data.row.labels["Content"].as(TrackedVariable).average.
Dashboard 2 in the attached example contains a table and a bar chart with the information you requested. Let me know if you've got additional questions.
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.
