question

Pedro A5 avatar image
0 Likes"
Pedro A5 asked Ben Wilson commented

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



FlexSim 17.1.6
statistics collectorflexsim 17.1.6busy
1601647189444.png (32.8 KiB)
1601647220758.png (36.5 KiB)
· 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.

Ben Wilson avatar image Ben Wilson ♦♦ commented ·

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 Likes 0 ·

1 Answer

tannerp avatar image
1 Like"
tannerp answered

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

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