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

Question

question

GRodea asked Jul 6, '23 Natalie White answered Jul 6, '23

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

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.

Software Version:

FlexSim 23.1.2

dashboards rack item type classification

1688646079573.png (437.5 KiB)

· 2

Natalie White commented · Jul 06, 2023 at 02:15 PM

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.

0 ·

GRodea Natalie White commented · Jul 06, 2023 at 02:24 PM

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

0 ·

example.fsm (297.1 KiB)

Answer 1 · 2023-07-06T19:46:27Z

Natalie White answered Jul 6, '23

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

1688672306075.png (101.7 KiB)

example-2.fsm (301.1 KiB)

question