How to create a Defect State Report Month-wise and Week-wise in RRDI
Hi,
I am trying to create a report of a Defect State,when I select Month in prompt page.It should display the no of Defects and its state in each week of that month. Can any one suggest some inputs on this.
Example :
| Year | Month Name | Week of Month | Request State | Count |
| 2015 | March | 1 | Completed | 4 |
| 2015 | March | In Progress | 3 | |
| 2015 | March | Info not available | 3 | |
| 2015 | March | Inprogress | 1 | |
| 2015 | March | New | 37 | |
| 2015 | March | Resolved | 14 |
One answer
Not exactly same, but you can get month wise and week wise report by applying filter in Report Studio of RRDI.
Suppose the attribute you want the filter is on 'Creation_Date' of defect, then in RRDI, add a filter as 'Creation_Date'in_range?date?. So it will ask you from which date to which date you want the report.
Comments
Count feature is also available with 'Summation' sign in Report studio. Not sure if it can count based on request state.
Hi Shuchita,
I have done made this report, Sorry for the late response. I have created data item with the required logic and filtered on the same. My requirement (4 weeks before data and also present week) got satisfied with the logic.
Thankyou.