topic Re: Convert Time Unit in Statistic Collector in FlexSim Forum

Convert Time Unit in Statistic Collector

patcharin_b2 — Mon, 19 Dec 2022 16:46:52 GMT

[ 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.

Re: Convert Time Unit in Statistic Collector

joerg_vogel_HsH — Mon, 19 Dec 2022 17:15:32 GMT

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

Re: Convert Time Unit in Statistic Collector

patcharin_b2 — Mon, 19 Dec 2022 17:27:22 GMT

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.

Re: Convert Time Unit in Statistic Collector

Jeanette_Fullmer — Mon, 19 Dec 2022 23:39:36 GMT

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.

Re: Convert Time Unit in Statistic Collector

patcharin_b2 — Tue, 20 Dec 2022 01:39:34 GMT

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.

Re: Convert Time Unit in Statistic Collector

Jeanette_Fullmer — Tue, 20 Dec 2022 04:33:35 GMT

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?

Re: Convert Time Unit in Statistic Collector

patcharin_b2 — Tue, 20 Dec 2022 04:55:45 GMT

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

Re: Convert Time Unit in Statistic Collector

jason_lightfoot_adsk — Tue, 27 Dec 2022 11:58:25 GMT

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

Re: Convert Time Unit in Statistic Collector

patcharin_b2 — Tue, 03 Jan 2023 04:41:52 GMT

OK I can do this. Thank You Somuch.