question

Nicolas M6 avatar image
0 Likes"
Nicolas M6 asked Nicolas M6 answered

How to get People Tables statistics after an experimenter?

Hi, to get statistics from a statistics collector after an experimenter (thanks to @Jordan Johnson), I use in a calculated table:

SELECT * FROM Experiment.MyStatisticsCollector

.

Is there a such syntax to get the informations from a People Table like : PersonMileston?

FlexSim 20.1.1
experimenterstatistics collectorcalculated tablepeople
5 |100000

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

Nicolas M6 avatar image
1 Like"
Nicolas M6 answered

Thanks to @tanner.p for the answer ! It works !


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
0 Likes"
tannerp answered Nicolas M6 commented

@Nicolas M6,

The syntax that you're after looks like this:

SELECT * FROM [PersonMilestones.StatisticsCollector]

That should get you what you need.

You can also copy the internal stats collector for the PersonMilestones chart and access it like a normal Stats Collector. Let us know if you have any additional 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.

Nicolas M6 avatar image Nicolas M6 commented ·

Hi @tanner.p, thanks for your answer.

Sorry, my question was not specific enough. Maybe I clarify the question:

When we use this syntax,
SELECT * FROM Experiment.MyStatisticsCollector,
the calculated table displays the scenario and the replication, and that is the need.

Is there a such syntax to get all the informations from the People Tables (including Scenario and Replication) ?

(Or it's necessary to create another statistics collector from the people table ? - it would be a pity because of two stocks of data :) )

thanks in advance


0 Likes 0 ·
tannerp avatar image tannerp Nicolas M6 commented ·

@Nicolas M6,

I was able to get the Scenario and Replication columns using the syntax shown in the image below. Hope this helps!

0 Likes 0 ·
Nicolas M6 avatar image Nicolas M6 tannerp commented ·

it works ! Thanks a lot @tanner.p

0 Likes 0 ·