List entry count by age class

Question

question

Anggoro P asked Dec 27 2017 at 10:42 AM Joerg Vogel commented Jan 09 2018 at 2:46 PM

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

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

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

Raja Sekaran answered Dec 28 2017 at 2:03 PM Joerg Vogel commented Jan 09 2018 at 2:46 PM

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

Anggoro P commented · Jan 02 2018 at 7: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 7:48 AM

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

0 ·

Anggoro P commented · Jan 08 2018 at 3: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 2: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 4:27 PM

ORDER BY age DESC 
// ASC ascending, DESC descending

0 ·

Anggoro P Joerg Vogel commented · Jan 08 2018 at 7: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