How to calculate the average age of work item in IBM JRS
I am using JRS 6.0.5 and I was trying to fetch average age of each work item based on field against attribute.
In custom expression i used the below code,
<http://www.w3.org/2005/xpath-functions#months-from-duration>(now() - $Work Item:Creation Date$)30 + <http://www.w3.org/2005/xpath-functions#days-from-duration>(now() - $Work Item:Creation Date$)
I am able to fetch age of the work item.
But when I tried fetching with avg code,
avg(<http://www.w3.org/2005/xpath-functions#months-from-duration>(now() - $Work Item:Creation Date$)30 + <http://www.w3.org/2005/xpath-functions#days-from-duration>(now() - $Work Item:Creation Date$))
I am getting the following error:
CRRGW5503E An unexpected response was received from the data source: HTTP/1.1 400 Bad Request.
Is there any way of fetching the average value of work item?
|
Be the first one to answer this question!
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.