JRS - Can you provide a link to documentation on how the "calculated value colums" work on a JRS report?
I am using RTC 6.0.1, and the Jazz Report Builder (JRS) within it.
I want to get a query of the Stories completed on March, and get the sum of the total story points calculated automatically.
I am able to set up the query very well, no problem, and I selected "complexity" as a calculated value. I am expecting to get the sum of All of the story points retrieved by my query.
But, it only got a new column with the story points for each story, not the total of all of them
Is that how it is designed to work?
Thanks!
I want to get a query of the Stories completed on March, and get the sum of the total story points calculated automatically.
I am able to set up the query very well, no problem, and I selected "complexity" as a calculated value. I am expecting to get the sum of All of the story points retrieved by my query.
But, it only got a new column with the story points for each story, not the total of all of them
Is that how it is designed to work?
Thanks!
Accepted answer
There is no additional documentation, except the online help which is pretty basic and the New&Noteworthy that I am aware of. On the other hand it is pretty self explanatory.
In the Format Results section, as mentioned on your previous question, Add a calculated value columns (this name will cause a huge amount of confusion in the forum, given the average immaturity of tagging and explaining the question background, it is just too close to calculated values in work item attributes).
In the calculation select "Complexity" as the attribute. So regardless what kind of complexity you use the report would work. Complexity is also the name of the complexity attribute configured in the process configuration source.
I tried this on the current RTC repository and it actually works with story points.
In the Format Results section, as mentioned on your previous question, Add a calculated value columns (this name will cause a huge amount of confusion in the forum, given the average immaturity of tagging and explaining the question background, it is just too close to calculated values in work item attributes).
In the calculation select "Complexity" as the attribute. So regardless what kind of complexity you use the report would work. Complexity is also the name of the complexity attribute configured in the process configuration source.
I tried this on the current RTC repository and it actually works with story points.
Comments
One other answer
What is wrong with the answer to the question from you around a similar topic here: https://jazz.net/forum/questions/216155/rtc-is-there-an-out-of-the-box-report-for-calculating-the-sum-of-the-values-from-an-integer-attribute . I have not tried story points as they are actually an enumeration.