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.

Kari Payton avatar image Kari Payton commented ·

image below


power.png

0 Likes 0 ·
power.png (326.1 KiB)
Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

Hi @Kari Payton, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 Likes 0 ·

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.