Find Min Max Avg value of cell data in GlobalTable.

Question

question

Anutt K asked Aug 01 2023 at 10:24 AM Anutt K commented Aug 02 2023 at 2:01 AM

Find Min Max Avg value of cell data in GlobalTable.

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

Software Version:

FlexSim 23.1.2

global table statistic collector table value

1690884887241.png (97.3 KiB)

find-min-max-avg-value-of-cell-data-in-globaltable.fsm (31.2 KiB)

· 1

Answer 1 · 2023-08-01T11:11:39Z

Joerg Vogel answered Aug 01 2023 at 11:11 AM Anutt K commented Aug 02 2023 at 2:01 AM

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

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

find-min-max-avg-value-of-cell-data-in-globaltable.fsm (34.7 KiB)

· 7

Jason Lightfoot ♦♦ commented · Aug 01 2023 at 11:16 AM

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

1 ·

Joerg Vogel commented · Aug 01 2023 at 11:20 AM

@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 ·

find-min-max-avg-value-of-cell-data-in-globaltable.fsm (34.7 KiB)

Anutt K commented · Aug 01 2023 at 2:55 PM

@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 ·

Joerg Vogel Anutt K commented · Aug 01 2023 at 11:29 PM

@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 ·

Anutt K commented · Aug 01 2023 at 3:06 PM

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 ·

1690902396348.png (264.9 KiB)

Joerg Vogel Anutt K commented · Aug 01 2023 at 10:32 PM

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 ·

Anutt K Joerg Vogel commented · Aug 02 2023 at 2:01 AM

Thank You So much.

0 ·

question