Operator use % per period

Question

question

Pedro A5 asked Oct 2, '20 Ben Wilson commented Oct 12, '20

Operator use % per period

Hi

Im trying to know how busy are my operators, but splitting the analysis by period of 8 hours. Here I share my Statistics collector . The following code is not working:

SELECT Object,

Time,

(((TravelEmpty + TravelLoaded + Utilize+ OffsetTravelEmpty+OffsetTravelLoaded)-(LAGTravelEmpty + LAGTravelLoaded + LAGUtilize+ LAGOffsetTravelEmpty+ LAGOffsetTravelLoaded)) ) AS Useful,

idle AS Useless,

FROM StatisticsCollector3

Thanks

Software Version:

FlexSim 17.1.6

statistics collector flexsim 17.1.6 busy

1601647189444.png (32.8 KiB)

1601647220758.png (36.5 KiB)

· 1

5 |100000

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

Ben Wilson ♦♦ commented · Oct 12, 2020 at 08:08 PM

Hi @Pedro A5, was tannerp's answer helpful? If so, please click the red "Accept" button on 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 unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2020-10-07T00:11:40Z

tannerp answered Oct 7, '20

Hi @Pedro A5,

I recommend that you use a Calculated Table to aggregate the data as you've described. Have you used a Calculated Table before? It uses FlexSQL (based on SQL) to create tables exactly as you've described.

The syntax of the code you've written above would work well with a few tweaks. If you can upload the model you're working with, we'd be happy to help implement this.

1602029492482.png (28.4 KiB)

5 |100000

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

question