question

mpj12 avatar image
0 Likes"
mpj12 asked mpj12 commented

Throughput rate per arbitrary unit of time

I have a process where the throughput is very slow and the template visualization of throughput per hour isn't useful. I am trying to get a table or visualization for throughput per week. Specifically I am trying to count the number of flow items with various label values per unit time. So "in week 1 we had x number of item with 'label1=a' label go through, and y number of items with label2='b' label, in week 2 etc..." The end result I want is a table that has a new row for every week, with a column for the count of every label value I am interested in.

What I have tried so far: I made a statistics collector which listens to processors at different stages of the process (the ones I am interested in), and they record the labels and model.time for every flow item on exit. That works fine.

When I try to use a calculated table however, I cannot seem to find the right options to aggregate the data such that I get a count of flow items with the right labels over a one-week period. I've tried using pure SQL but FlexSim seems to have a limited number of functions available and doesn't support FLOOR or timestamp functions. I know this is possible, any ideas?

FlexSim 23.2.2
calculated tablestatistic collectorthroughput per hour
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered mpj12 commented

Here's an example of how this could be done. I use a Statistics Collector with a column. If the label name/label value pair of an item matches, the respective column is incremented by 1, otherwise it keeps its previous value.

specific-label-throughput.fsm


· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

mpj12 avatar image mpj12 commented ·

Awesome, thanks!

0 Likes 0 ·