How to find average value of an item label

Question

question

Clinton N asked Feb 20, '19 Clinton N commented Feb 26, '19

How to find average value of an item label

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

dashboards statistics

· 3

Jeff Nordgren commented · Feb 20, 2019 at 09:15 PM

@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.

0 ·

Clinton N commented · Feb 20, 2019 at 09:48 PM

Hi,

I have attached the problem.

problem.fsm

thanks

0 ·

problem.fsm (23.3 KiB)

Clinton N Clinton N commented · Feb 20, 2019 at 09:48 PM

just incase this is a 2019 version file

0 ·

Answer 1 · 2019-02-21T00:41:48Z

jing.c answered Feb 21, '19 Clinton N commented Feb 26, '19

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

legacy-charts.png (54.0 KiB)

average-label-processtimev19.fsm (22.8 KiB)

· 3

Clinton N commented · Feb 21, 2019 at 04:49 PM

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

0 ·

jing.c Clinton N commented · Feb 22, 2019 at 12:12 AM

Glad to see your problem solved.

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

0 ·

Clinton N jing.c commented · Feb 26, 2019 at 05:09 PM

@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.

1 ·

times-processed-solved.fsm (25.0 KiB)

Answer 2 · 2019-02-22T16:11:59Z

Joerg Vogel answered Feb 22, '19 Jordan Johnson commented Feb 22, '19

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.

cumulated-processtime-of-multiprocessed-item.fsm (34.1 KiB)

· 1

Jordan Johnson ♦♦ commented · Feb 22, 2019 at 05:56 PM

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

2 ·

question