Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
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
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