List entry count by age class

Question

question

Anggoro P asked Dec 27, '17 Joerg Vogel commented Jan 9, '18

List entry count by age class

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

Software Version:

Choose One

list getstat

· 2

5 |100000

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

Anggoro P commented · Dec 27, 2017 at 10:42 AM

@Raja Sekaran

0 ·

Joerg Vogel commented · Dec 28, 2017 at 09:57 AM

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

0 ·

Answer 1 · 2017-12-28T14:03:18Z

Raja Sekaran answered Dec 28, '17 Joerg Vogel commented Jan 9, '18

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.

support-listentry1.png (17.0 KiB)

support-listentry2.png (17.5 KiB)

listentrycount-support-6.fsm (20.4 KiB)

· 9

5 |100000

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

Anggoro P commented · Jan 02, 2018 at 07:35 AM

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?

0 ·

Raja Sekaran Anggoro P commented · Jan 02, 2018 at 07:48 AM

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

0 ·

Anggoro P commented · Jan 08, 2018 at 03:42 PM

@Raja Sekaran

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

0 ·

Joerg Vogel Anggoro P commented · Jan 09, 2018 at 02:46 PM

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

1 ·

evallist.fsm (20.4 KiB)

Joerg Vogel Anggoro P commented · Jan 08, 2018 at 04:27 PM

ORDER BY age DESC 
// ASC ascending, DESC descending

0 ·

Anggoro P Joerg Vogel commented · Jan 08, 2018 at 07:33 PM

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

0 ·

Show more comments

question