question

Tommy Heyser avatar image
1 Like"
Tommy Heyser asked Alexander M7 commented

Calculating percentiles for experiment

Is there a way to customise the performance measure report to include calculated percentiles, e.g. P10, P50, P90, from the results of an experiment?

The current plan is to take the dataset, e.g. average throughput for each replication in an experiment, and calculate the percentiles separately, but I'm wondering if the performance measure report can do that automatically.

Is the template that FlexSim uses to create the performance measure report something that I can customise? In particular, I'd like to include the percentiles in the summary table.

FlexSim 20.0.3
percentiles
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Jordan Johnson avatar image
1 Like"
Jordan Johnson answered Alexander M7 commented

In FlexSim you can query the Performance Measures Table:

SELECT * FROM Experiment.PerformanceMeasures

You can then export this table to Excel, and work with in there.

Within FlexSim, you can use window functions such as NTILE() to put pfms into buckets:

SELECT PFM1, NTILE(10) OVER (ORDER BY PFM1) AS Buckets 
FROM Experiment.PerformanceMeasures
ORDER BY PFM1
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Braydn T avatar image Braydn T commented ·

@Tommy Heyser

Did Jordans answer help you? If it did, could you please click accept? If it didn't, could you tell us what else we can do to help you?

0 Likes 0 ·
Alexander M7 avatar image Alexander M7 commented ·

@Jordan Johnson Is it possible to provide a file to demonstrate this solution? I seek to display 95th Percentile values in the Experimenter/Optquest as well! =)

0 Likes 0 ·