Is it possible to get averaged out dashboards at the end of an experiment?
Thanks,
Jarek
Is it possible to get averaged out dashboards at the end of an experiment?
FlexSim 19.0.0
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.
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.
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
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.
@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
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.
12 People are following this question.
