question

fiz avatar image
0 Likes"
fiz asked Jeanette F commented

Statistic collector clean up

Hi, I have the following tables, table 1, 2 and 3 which display the duration for 3 different intervals.

1730278878975.png


This 3 tables compute tokens interval (duration) across 3 different milestone collector. These tokens can be identified by its token ID.

1730279152186.png


I would like to combine these 3 tables into 1 table identified by the OrderID, but also displaying the 3 intervals. How may i do this?

combine 3 tables.fsm

FlexSim 23.1.4
statistic collector
1730278878975.png (361.7 KiB)
1730279152186.png (33.2 KiB)
combine-3-tables.fsm (232.2 KiB)
· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @fiz, 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

All of your "Table X" collectors currently log the information of M1. (Hence all tables show the same durations.) You need to update what activity they listen to.

You can join the tables in a calculated table.

capture1.png

capture2.png


capture1.png (52.5 KiB)
capture2.png (40.9 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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