topic Re: Show stock levels of different item types in different racks in a Dashboard in FlexSim Forum

Show stock levels of different item types in different racks in a Dashboard

GerardoRodea — Thu, 06 Jul 2023 14:08:20 GMT

[ FlexSim 23.1.2 ]

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.

Re: Show stock levels of different item types in different racks in a Dashboard

natalie_white — Thu, 06 Jul 2023 14:15:22 GMT

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.

Re: Show stock levels of different item types in different racks in a Dashboard

GerardoRodea — Thu, 06 Jul 2023 14:24:07 GMT

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.

Example.fsm

Re: Show stock levels of different item types in different racks in a Dashboard

natalie_white — Thu, 06 Jul 2023 19:46:27 GMT

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.

example_2.fsm