question

Fernando Q3 avatar image
0 Likes"
Fernando Q3 asked Ben Wilson edited

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 !!!!

FlexSim 18.1.2
time in system
· 2
5 |100000

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

Joshua S avatar image Joshua S commented ·

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

0 Likes 0 ·
Fernando Q3 avatar image Fernando Q3 commented ·

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 Likes 0 ·

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered Ben Wilson edited

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

· 2
5 |100000

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

Fernando Q4 avatar image Fernando Q4 commented ·

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 Likes 0 ·
Ben Wilson avatar image Ben Wilson ♦♦ Fernando Q4 commented ·

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 Likes 0 ·