I want to collect the data only for a certain period of time. For example, if I run my model 10000 seconds, I need to collect the data from 5000s to 7000s. Is this possible and if it is, how can I do it? Thank you!
@Marcos MNA If your data is already in a statistics collector you could also attach a calculated table and there write a query that only selects the data between 2 time periods. Then you have table with only the data you need.
In some cases you can also use the legacy graphs, see this post: how-can-i-create-state-pies-of-certain-time-period
Thank you for your answer
@steven.hamoen! Could you explain me more in detail how to do it? I have just read Calculated Table tutorial but it is not really clear for me...
In the Calculated Table I have created, I set my Statistics Collector as Primary Table but I do not know which Metrics I should define (I want to show the same as my Statistics Collector where I collect the time where the different processor are processing, in idle time, change over time...) and the query I need to write to collect the data between 2 time periods.
@Marcos MNA After you have selected the Statistics Collector as Primary table, you can go to the calculation tab page and select "Enable direct editing" then you get a query field and you can write something similar like: SELECT * FROM [Name Statistics Collector] WHERE [Field Name Time] > 5000 AND [Field Name Time] < 7000
That should give you a table with the data you want. Then you can take the graph type you want and try to connect it with this calculated table. Or you can copy the data to excel and do some post processing
I solved it with the Legacy Graphs option you mentioned in your first comment. Thank you very much!
14 People are following this question.
