cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate all Time Entry Attribute for specified users during a period of time?

ptc-4983088
1-Newbie

How to calculate all Time Entry Attribute for specified users during a period of time?

Hi,

I want to know the total hours that each user (who is a group member of "England") has entered into the MKS Integrity during each week.

I plan to create a new field for the computed value.

Do anybody know how to write the Computation Definition?

Thanks in advance.

Jason

1 REPLY 1

Hi Jason,

This may be possible with a computed field using the "sumTimeEntryByGroup()" (hours) or "sumTimeEntrySecsByGroup()" (seconds) functions.

With that said, placing those functions in a field on an item will operate against that item only.

For example, lets say that group "England" adds 40 hours on item 1 and 80 hours on item 2. The new field will have a value of "40" on item 1 and a value of "80" on item 2.

If instead you are looking for a single item holding "120" (which is the total time entered by group "England" across all items in our example), your calcualted field will become more complex as you will need to use aggregate functions such as Query() to return the list of items and then run a Sum of the SumTimeEntryByGroup. Big computations like this can be very slow but are possible.

I would recommend looking through the calculated fields section of the Server Admininstration guide for your version of Integrity to learn more about the functions available.

There are also some knowledgebase articles for running system-wide metrics which may also be useful if you are trying to capture the "120" instead of "40" on item 1 and "80" on item 2.

https://www.ptc.com/appserver/wcms/standards/ssl/freefull_cskdb.jsp??icg_dbkey=900&im_dbkey=147022

https://www.ptc.com/appserver/wcms/standards/ssl/freefull_cskdb.jsp??icg_dbkey=900&im_dbkey=141161

Hope that helps,

Matt

Announcements

Windchill RVS Users


Please take our

Windchill RV&S Authoring with Formula Editor Survey