question

Anutt K avatar image
0 Likes"
Anutt K asked Anutt K commented

Find Min Max Avg value of cell data in GlobalTable.

1690884887241.png

In this model I assign value of cell data in Table2 from each token by each row in Table1 it will be increment. So, the value in cell of Table2 will be 10 at Min value, 200 at Max value and 105 at Avg value. Then I want to use Statistics Collector for collecting call value data for use to be Data Source for Table Chart in Dashboard. How can I Do this.

I has attached model here. Thank You.

Find Min Max Avg Value of Cell Data in GlobalTable.fsm

FlexSim 23.1.2
global tablestatistic collectortable value
· 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.

1 Answer

Joerg Vogel avatar image
1 Like"
Joerg Vogel answered Anutt K commented

with a conditional tracked variable init you get your desired results.

find-min-max-avg-value-of-cell-data-in-globaltable_trVar-JV.fsm


· 7
5 |100000

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

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

@Anutt K Consider placing the tracked variables as labels on objects rather than using table cell entries - this will likely scale better.

1 Like 1 ·
Joerg Vogel avatar image Joerg Vogel commented ·

@Anutt K, instead of an init, you can also reset the variable to a start value.

find-min-max-avg-value-of-cell-data-in-globaltable_trVar_reset-JV.fsm


1 Like 1 ·
Anutt K avatar image Anutt K commented ·

@Joerg Vogel @Jason Lightfoot From Joerg's exam model. I can see how Tracked Variable to be show cell data in Bar Chart that it work. But I try to find how to using Tracked Variable to get data from Table2. I has never used Tracked Variable. I has try to understand it in Tree but I can't and I try to find im FlexSim Docs but I still not understan because in FlexSim Docs don't tell how to use it. How can I using Tracked Variable. Thank You.

0 Likes 0 ·
Joerg Vogel avatar image Joerg Vogel Anutt K commented ·

@Anutt K, A tracked variable is an answer to: How can a change of a value fire an event in FlexSim? You can find it also under the keyword watch variable. Additionally you get data of history, this makes it easier to evaluate a tracked variable as a statistical element.

Tracked variables are a construct of FlexSim‘s past, when Lists and Process Flow haven’t existed.

0 Likes 0 ·
Anutt K avatar image Anutt K commented ·

1690902396348.png

At First. I can use this for set data to Tracked Variable. But I would like to know how you can use it at first time.

0 Likes 0 ·
1690902396348.png (264.9 KiB)
Joerg Vogel avatar image Joerg Vogel Anutt K commented ·

I think, I have shown in custom code to assign values for a table cell value also to a tracked variable. https://answers.flexsim.com/comments/147885/view.html. Please look into the file of this comment. You cannot evaluate a change of a table cell value. This feature belongs only to tracked variables. You will notice that I assign table cell value and tracked variable completely independently from another. And that I reset this tracked variable for first value to be assigned to same value as first value of this involved table cell..There are mechanisms that are documented that work as watch variable and those are coupled to tracked variables.

A different approach!

I would try to push the table cell node to a List With option only unique values. Then this list value is always the same and an evaluation of the cell node value should accumulate a field and result in a statistic of min, max and average. I need to test and verify this.

0 Likes 0 ·
Anutt K avatar image Anutt K Joerg Vogel commented ·
Thank You So much.
0 Likes 0 ·