How to get Time in System statistic (all replications) by PFM?

Question

question

Fernando Q3 asked Feb 5, '19 Ben Wilson edited Sep 17, '19

How to get Time in System statistic (all replications) by PFM?

Hi, I am just trying to obtain in one report all replication values of the statistic "Time In System" of flowitems by using experimenter (performance measures, PFM). I figured out that PFM are only related with objects but not flowitems. I also tried with the composite time in dashboard and I can see the average of each replication but it does not report all of them in a whole report. I also tried to export dashboard statistics to Excel but it does not work out. Any help? thks !!!!

Software Version:

FlexSim 18.1.2

time in system

· 2

Joshua S commented · Feb 05, 2019 at 09:42 PM

What are you using to create that "Time in System" statistic?

0 ·

Fernando Q3 commented · Feb 06, 2019 at 01:14 AM

Hi Joshua, Time in System is already a tracked variable, but based on my experience in other simulation software, that statistic is coming by default in entities sumaries or reports generated. However, in Flexsim, it has not been easy to me to find out its replications values.

0 ·

Answer 1 · 2019-02-06T13:35:03Z

Jordan Johnson answered Feb 6, '19 Ben Wilson edited Sep 17, '19

First, you need to make a Performance Measure that records the value of the TrackedVariable:

TrackedVariable("TimeInSystem").average

I left the name of the Performance Measure "PFM1".

Then, run an experiment. After that, you can add a Calculated Table that has the following query:

SELECT Scenario, AVG(PFM1) AS AvgPFM1
FROM Experiment.PerformanceMeasures
GROUP BY Scenario

In the attached model, I did so, and added a chart that points at that table.

timeinsystembyscenario.fsm

The query above averages the value per scenario. To see all Performance Measures for all replications, you can use this query:

SELECT *
FROM Experiment.PerformanceMeasures

timeinsystembyscenario.fsm (84.7 KiB)

· 2

Fernando Q4 commented · Sep 17, 2019 at 02:33 PM

Hi, Jordan ....thanks for your previous help. ¿Can you help me now when I need to get the time in system by each item type?

0 ·

Ben Wilson ♦♦ Fernando Q4 commented · Sep 17, 2019 at 02:38 PM

Hi @Fernando Q4,

Please ask new questions as brand new, standalone questions.

This isn't a conversational-style community, where a conversation thread can continue indefinetely. Instead, this is a Question And Answer style site.

When an existing question already has an accepted answer, rather than tacking on an additional question months later, please post a new question instead.

See our Community Best Practices for more tips and information.

0 ·

question