Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Close vs open WI along the last 2 years

Questions
Tags
Users
Badges
Shimon Lipiner Nir
(23●2●1●6) Feb 03 '23, 11:30 a.m.

 Hello


I am trying to build a report in JRS which will show Close vs open WIs of type story
I found a ready-to-copy report 
Shows a table or graph of the open and closed stories for a release with links to open defects.
that shows exactly what I wish but instead of creating the report per iteration, I wish to create it per month say along the last year. In other words replace the planned for by ?????
Any ideas ?

Thanks
Shimon

0 votes

Comments
David Honey
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Feb 03 '23, 12:14 p.m.
Is this against Data Warehouse or Lifecycle Query Engine? I think the OOTB report you refer to is not a trend report. It is a report based on current data (rather than historical metrics). When you say "per month", what do you mean? What does that date dimension represent? Creation date? Resolution datre? Something else? Are you trying to define a report based on historical trends?

Shimon Lipiner Nir
Feb 04 '23, 4:27 a.m.
Hi David, You can find the report in ready to copy . and YES this is   based on current data  against Data Warehouse. I would like of course to base it if possible on LQE but any solution is welcome. The reports I have defined such as stories along the year per each month in their Closed state were based on LQE and custom expression you helped me to define CONCAT(STR(YEAR($Story:Close Date$)),"-",STR(MONTH($Story:Close Date$))) Here, the issue is that I need to distinguish between stories closed (which is simple ) and group of stories that are in the new, in development etc... ie  are still opened. date means the date of the status.  Shimon

0 answers
3,541 views
0 votes

Be the first one to answer this question!

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,147
× 7,624
× 1,454
× 363

Question asked: Feb 03 '23, 11:30 a.m.

Question was seen: 3,541 times

Last updated: Feb 04 '23, 4:27 a.m.

Confirmation Cancel Confirm