Sum label value by item type in process flow for dashboard

Question

question

dougdurbin asked Jan 28 2021 at 2:41 AM dougdurbin commented Jan 31 2021 at 6:40 PM

Sum label value by item type in process flow for dashboard

In my process flow I have an activity that I want to get a metric on. As the token flows through the activity I want to create a table chart in the dashboard to sum the labels. In my model, I have tokens that get assigned a label (PartNumber) that can be 1014, 1012, 1011, etc. and need to sum all like-labels that flow through that activity. The table chart should have each label (1014, 1012, 1011, etc) as column headers with the sum of how many tokens with that label passed through that activity in the row below. I've tried the statistics collector with an event listening to On Entry but am having a problem building the table that sums the labels and instead is listing out each entry. Is there a way to provide a quick example of how this is done?

Software Version:

FlexSim 21.0.1

label charts flexsim 21.0.1

· 2

Answer 1 · 2021-01-28T14:57:59Z

Jason Lightfoot answered Jan 28 2021 at 2:57 PM dougdurbin commented Jan 31 2021 at 6:40 PM

Example attached.

The row value should be data.token.PartNumber

The column PartNumber should be data.rowValue

The column Sum should be set to increment

The event needs to know that updates should affect the "Sum" column.

SumPartNumbers.fsm

sumpartnumbers.fsm (36.9 KiB)

· 1

Answer 2 · 2021-01-28T04:32:44Z

Joerg Vogel answered Jan 28 2021 at 4:32 AM

I assume the label value is the column name. You check if the column name exists in your collectors table. If the answer is true you increment the cell value otherwise you add a column to the table With cell value by 1.

Alternatively you push the label value to a global list which stores only unique values. The list should sum up the values.

question