topic Re: List entry count by age class in FlexSim Forum

List entry count by age class

anggoro_p — Wed, 27 Dec 2017 10:42:32 GMT

Hi, currently I have a list that tracks the age dynamically. I wonder if I can track how many items are in my list based on their age class. For example I defined age class A: 0-10 days; B: 10-20 days, and so on

I aware that normally we track the current status by using

getstat(getactivity(current, "List"), "Content", STAT_CURRENT, current)

So I expect that there is an extension for addressing my problem. Thanks

Re: List entry count by age class

anggoro_p — Wed, 27 Dec 2017 10:42:44 GMT

@Raja Sekaran

Re: List entry count by age class

joerg_vogel_HsH — Thu, 28 Dec 2017 09:57:14 GMT

I haven't done it, but perhaps you can make a statistic histogram with the statistic collector.

Re: List entry count by age class

raja_sekaran — Thu, 28 Dec 2017 14:03:18 GMT

Hi @Anggoro P

I am not sure if there is any direct way to track the number of items in List based on their age, But you can track the number of items using Query in Pull from List as shown in the pic below.

Then get the number of elements in an array using the length property. Check the labels associated with the token.

I have attached the sample model. I am not sure if this work for your situation.

listentrycount-support-6.fsm

Thanks.

Re: List entry count by age class

anggoro_p — Tue, 02 Jan 2018 07:35:49 GMT

Thanks @Raja Sekaran

Just to confirm. So, the idea is to use additional Pull From List activities to track age classes without actually pulling them from the list, isn't it? In other word, it would not affect my existing Pull From List activities for matching supply and demand right?

Re: List entry count by age class

raja_sekaran — Tue, 02 Jan 2018 07:48:00 GMT

@Anggoro P Yes, it won't affect your existing logic.

Re: List entry count by age class

anggoro_p — Mon, 08 Jan 2018 15:42:13 GMT

@Raja Sekaran

Is there any query to get the number of items with the oldest age?

Re: List entry count by age class

joerg_vogel_HsH — Mon, 08 Jan 2018 16:27:32 GMT

ORDER BY age DESC 
// ASC ascending, DESC descending

Re: List entry count by age class

anggoro_p — Mon, 08 Jan 2018 19:33:45 GMT

@Jörg Vogel unfortunately, what I intended was not making an order.

I want to know how many items from my list that have oldest age. So, the output should be a number of tokens that have the oldest age on that particular time.

I have tried this query, but I got an error message

SELECT MAX(age)

Re: List entry count by age class

joerg_vogel_HsH — Tue, 09 Jan 2018 00:59:56 GMT

You can pull the items from the list. They are assigned to the token label as an array. Then you get the number of items by the length of the array or token.pulled.length.

Re: List entry count by age class

anggoro_p — Tue, 09 Jan 2018 07:10:05 GMT

@Jörg Vogel

That is indeed what @Raja Sekaran has suggested. In order to do that, I need a specific query to pull items based on criteria that I have explained before. I have used MAX() function, but it didn't work

Re: List entry count by age class

joerg_vogel_HsH — Tue, 09 Jan 2018 09:20:33 GMT

The MAX() function returns the largest value of the selected column.

MIN (column name) and MAX( column name) from www.w3schools.com/sql/

The function does what it is intended for, not what you are assuming it does. If you want the oldest entries to be counted, you should try @Raja Sekaran's advice.

Maybe you have to make a Table.query in source code to get the full functionality:

Table myEval = Table.query("SELECT .. FROM listname .. WHERE..");

Re: List entry count by age class

joerg_vogel_HsH — Tue, 09 Jan 2018 14:46:41 GMT

Attached is a model that creates from the list a table query and from this query it computes a class column inserted in new table. The class is a possible filter to get the items belonging to an age interval. evallist.fsm