topic Re: How to find average value of an item label in FlexSim Forum

How to find average value of an item label

clinton_n — Wed, 20 Feb 2019 14:10:59 GMT

Hi,

I have a model in which after completing processing at a processor there is a 24% chance that the object will come back into the system. I want to find the average value for the number of times an object would be processed.

I created an item label named TimesProcessed at the source and gave it a value 0. On exiting the processor, the value gets incremented by one.

what im struggling with is how to display TimesProcessed average value on a dashboard.

Clinton

Re: How to find average value of an item label

jeff_nordgren — Wed, 20 Feb 2019 21:15:25 GMT

@Clinton N

Can you send in your model or a sample model so that we can see exactly what is happening in the model? It would be helpful to see what you are trying to do in the actual model.

Thanks.

Re: How to find average value of an item label

clinton_n — Wed, 20 Feb 2019 21:48:15 GMT

Hi,

I have attached the problem.

problem.fsm

thanks

Re: How to find average value of an item label

clinton_n — Wed, 20 Feb 2019 21:48:56 GMT

just incase this is a 2019 version file

Re: How to find average value of an item label

jing_chen — Thu, 21 Feb 2019 00:41:48 GMT

hi, @Clinton N

If I was you, I will use legacy dashboard charts. Before that I will add the all value of item label to sink's label "total", and it divide by the input of sink is the average value of "TimesProcessed".

You can find the custom charts statistics in the attached model average-label-processtimev19.fsm

P.S. You need to check "show legacy charts" to find legacy charts in dashboard-libary

legacy-charts.png

Re: How to find average value of an item label

clinton_n — Thu, 21 Feb 2019 16:49:42 GMT

Thank you very much it solves my problem. But just wanted to know is there any way to collect the data using statistics collector

Re: How to find average value of an item label

jing_chen — Fri, 22 Feb 2019 00:12:28 GMT

Glad to see your problem solved.

I am not quite familiar with Statistics Collector, you can try to ask @jordan.johnson help.

Re: How to find average value of an item label

joerg_vogel_HsH — Fri, 22 Feb 2019 16:11:59 GMT

The statistic collector and a calculated table will accomplish your request:

Statistic Collector: OnEntry Event of the sink let you get the value of a label of the item each time a row is added to the result table.

Calculated Table can query the average of the table column of the Statistic Collector.

SELECT AVG(StayTimeProcessor)  AS AvgStayTime FROM [cumulated staytime at processor]

cumulated-processtime-of-multiprocessed-item.fsm

Since you let process the items randomly multiple times at the processor, I increment the label "ProcessedTimes" each time on exit by the staytime of the item on the processor. The color of items depends on the item Type label which I increment on exit by 1 at the processor, too.

Re: How to find average value of an item label

JordanLJohnson — Fri, 22 Feb 2019 17:56:13 GMT

This is the solution I recommend, if you are looking to use the stats collector.

Re: How to find average value of an item label

clinton_n — Tue, 26 Feb 2019 17:09:10 GMT

@jing.chen

I was able to use Statistics Collector and get the same result. It uses a part of your solution like to increment total at sink. In the stats collector i divided it by the input at sink.

Im attaching the solved problem. Hope you are able to understand it.

times-processed-solved.fsm

Thanks a lot guys.