Convert Time Unit in Statistic Collector

[patcharin_b2]

[ FlexSim 22.2.2 ]

Hello. I want to convert stay time in from second to minute.

From picture I crate "Entry Lift Waiting" Table Chart by ZONE in process flow then pin Stay Time of Zone to Dashboard and install Statistic Collector for convert second to minute by /60 in avg. and max. column.

So, If I use /60 the time will be normal number. How can I convert time in normal number to time in time number. Such as from 90 second = 1.50 minute convert to 90 second = 1.30 minute.

Thank You.

[joerg_vogel_HsH]

Please do it in the display Unit of each Chart in Dashboard.

[patcharin_b2]

This Table Chart is come from ZONE in process flow. It are not Time Unit field. So I has create Statistic Collector by install from advance of this chart.

And although stay time chart will has Time Unit field, when select unit to minute it will be normal number (0-99).

How can I convert time unit to time number (0-59). Such as 1.50 minute convert to 1.30 minute.

[Jeanette_Fullmer]

Hello @Patcharin B2,

You can add a label to the statistics collector that is for the conversion.

Then for each of the statistics apply the conversion. So I wanted to convert from the model units of seconds to minutes so I used 60 for the conversion and then divided by the conversion.

[patcharin_b2]

Thank You for reply. This way to solve this is at like before, that I use divided by 60 directly at Value. Yes, a time are convert from second to minute but it will be in Red Circle it be 0.93 minute. From this case in this picture. Example in this case how can I convert from 0.93 to 1.63 minute.

[Jeanette_Fullmer]

How does .93 minute convert to 1.63 minutes? .93 minute is 55.8 seconds. So if it is .93 minute do you want it to display 0.55?

[patcharin_b2]

Yes that right. I want to display 0.93 minute to 0.55 minute.

[jason_lightfootVL7B4 · Accepted solution]

Install the stats collector and the for each of the time fields/columns wrap the expression for the time value (without the divisor) like this:

DateTime(<expression>).toString("%H:%M:%S")

so in the attached example the original expression was:

getstat(data.rowValue, "Staytime", STAT_AVERAGE, instance) / collector.TimeDivisor

while the new column is

DateTime(getstat(data.rowValue, "Staytime", STAT_AVERAGE, instance) ).toString("%H:%M:%S")

StatsCollectorTimeFormatting.fsm

[patcharin_b2]

OK I can do this. Thank You Somuch.