question

London MT avatar image
0 Likes"
London MT asked London MT commented

Is it possible to get averaged out dashboards at the end of an experiment?

Is it possible to get averaged out dashboards at the end of an experiment?

Thanks,

Jarek

FlexSim 19.0.0
experimenter
· 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.

tannerp avatar image tannerp commented ·

I'm not sure that I quite understand what you mean by "averaged out" dashboard. Could you provide a bit more information on that?

If you're looking to calculate averages from the data you collect, it might be easier to do that in Excel.

Maybe you could provide an example of what you'd like and then we can find a way to do it through the stats collector or experimenter.

0 Likes 0 ·
London MT avatar image London MT commented ·

Hi @Tanner Poulton,

At this moment I have code being executed on the "End of Replication" trigger in the experimenter. The code exports the dashboard data in .csv format to a back-up file and a "mother file". The data is appended in the mother file to the rest of the data so I have all the dashboard data in that file at the end of the experiment.

Since my post gets blocked when I insert code (not the first?), I will post it in a user command in a model.

forum-dashboard-average.fsm

I'm having a lot of limitations with this procedure, so I wonder if you know a way how to have 1 dashboard per scenario with the average values over all replications after the experiment.

Hope this was clear,

Jarek

0 Likes 0 ·

1 Answer

·
Jordan Johnson avatar image
1 Like"
Jordan Johnson answered London MT commented

Right now, the process is fairly manual. If you use a Statistics Collector or Calculated Table to gather your data, and you also check the "Save Dashboard Data for Each Replication" checkbox, then you can another Calculated Table to query the experiment results:

SELECT * FROM Experiment.MyStatisticsCollector

When you query from Experiment.MyStatisticsCollector, you will get a UNION of the table from each replication, as well as two additional columns: Scenario and Replication. Currently, it is up to you to query that table in a way that makes sense. For example, you might use something like

SELECT Scenario, Object, AVG(MyValue) AS AvgValue 
FROM Experiment.MyStatisticsCollector 
GROUP BY Scenario, Object

Let me know if you have questions.

· 3
5 |100000

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

London MT avatar image London MT commented ·

@jordan.johnson thanks for this, but my dashboards consist of bar charts (listening to Object groups) and state pies (listening to Object groups). I made a statistics collector that listens to these Object groups and then I made a calculated table, I get a UNION table like you described. But Flexsim doesn't provide me with Connected Dashboard Charts, i.e. the list in the General tab is empty...

How do I continue from here to get the desired bar chart/state pie...?

Cheers

Jarek

0 Likes 0 ·
Jordan Johnson avatar image Jordan Johnson ♦♦ London MT commented ·

Once you have the experiment data present in a Calculated table, you can then drag out a chart (not a template) from the Charts section of the dashboard library. Then you can use the Calculated Table that contains the experiment data. If the data is formatted in a way that makes sense for the given chart, then the chart will draw the information in the Calculated Table.

0 Likes 0 ·
London MT avatar image London MT Jordan Johnson ♦♦ commented ·

Thanks.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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