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?