question

Kari Payton avatar image
0 Likes"
Kari Payton asked Jason Lightfoot commented

Identify exact time for max value of tracked variable

After a model run, I have a chart like this for a tracked variable. Is it possible to identify the run time (hours) where the maximum occurs? I output the CSV but the format is in a date:time format.


FlexSim 21.2.4
tracked variables
· 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.

1 Answer

Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered

You could use a calculated table to query the statistics collector table for the maximum value and the corresponding time. (If it's chart template, install its components so you can access the stats collector).

The query would look something like this:
SELECT * FROM TableName ORDER BY Value DESC LIMIT 1

5 |100000

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