How to calculate average age of work items with respect to field against attribute in IBM RPE?
![]() Hi,
Can anyone please help in finding out the script or any other possible ways to calculate average age of the work items based on filed against attribute through RPE.
|
Accepted answer
![]() You can first store unique category values (workitem/workItem/category/name) in an array. Then iterate over each array element (using an Iteration element in RPE template). Within Iteration element, use a filter to get workitems filtered by category/name, get the indidual age using following Script Expression:
meghana kaddu selected this answer as the correct answer
Comments Hi Subramanya,
Thank you for the response, Can you please attach any reference dta file ? That will be a great help.
Thanks and Regards,
Meghana
Here is the sample template you can refer to.
|
2 other answers
![]() Publishing (formerly RPE) is used mainly for documentation purpose and it depends on application data. If application does not provide such value, there are some techniques that you might want to try:
1) Java scripting
2) Create hybrid document using JRS data within PUB. If you can create JRS report with calculation you are looking for, you can use JRS export to PUB option to get necessary PUB template details.
Hope this helps.
|
![]() Hi Fariz,
Thank you for the reply, I checked the possibilities through JRS. It is not possible so I am checking the way to do in rpe, whether it is possible to calculate average age of work item with respect to an attribute value in Rpe?
|