Is there any widget in ccm in which i can add 2 attributes or i can see the result on the basis of two attributes
Is there any widget in ccm in which i can add 2 attributes of workitem or i can see the result on the basis of two attributes of any workitem |
One answer
Hi Gagan,
You have a good question. This thread may be helpful. https://jazz.net/forum/questions/220337/jrs-can-you-provide-a-link-to-documentation-on-how-the-calculated-value-colums-work-on-a-jrs-report
It's possible to use JRS to report on calculated field.
You can then install the JRS report in your dashboard.
I'm sure that there may be more elegant and simple ways, but this is one way that I know of.
Have a great day.
swoo
Comments
Stephen Woo
commented Nov 18 '17, 1:05 p.m.
I could be wrong though. I just realized that you wanted the sum of two fields. Perhaps another user can offer a better solution..
Stephen Woo
commented Nov 18 '17, 2:34 p.m.
Hi Gagan,
6.0.3 does not support custom expression. The only way I think of an work-around is to export the JRS report to an Excel spreadsheet either as a static or dynamically refreshable Excel worksheet. You can then add the two attributes.
6.0.4 does support custom expression. Perhaps you can consult this note:
Have a good day.
swoo
Stephen Woo
commented Nov 18 '17, 3:04 p.m.
I hope that I am wrong. I played with 6.0.5 a little bit. It seems that a custom expression can involve only one attribute.
So perhaps the best answer will come from someone who has experience with SQL and use the Advanced section of the Report Builder to do something like this.
|
Your answer
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.
Comments
You will need to be much clearer or more explicit in your question.