How do I build line graph for defect data and custom data item possibly?
Okay, i've fought with this report long enough. Asking for some assistance.
How do I build a report , a line graph that shows total defects on Y axis. date for x axis and a series that will show request status: open, closed
Can someone help me by providing assistance with open and closed having each its own line on the line graph.
Lastly, I also need a third line to show total, which is the sum of what was both opened and closed on the third line. Would I need to create a data item and if so, how?I've tried googling to no avail. Also, what type of calculation involved for showing both statuses.
I have obtained the information I need I believe for filtering, well I pulled in total defects based on a canned report I found but it keeps showing me the total defects period not the total open or closed. So I need help with that too. Any help would be appreciated.
How do I build a report , a line graph that shows total defects on Y axis. date for x axis and a series that will show request status: open, closed
Can someone help me by providing assistance with open and closed having each its own line on the line graph.
Lastly, I also need a third line to show total, which is the sum of what was both opened and closed on the third line. Would I need to create a data item and if so, how?I've tried googling to no avail. Also, what type of calculation involved for showing both statuses.
I have obtained the information I need I believe for filtering, well I pulled in total defects based on a canned report I found but it keeps showing me the total defects period not the total open or closed. So I need help with that too. Any help would be appreciated.
One answer
Hi Brandy, Sorry for the late response. But have you tried the following two out of the box reports:
- Open vs Closed Work Items
- Cumulative Value Flow
Both sound similar to what you are looking for. If you want to really your own, I would suggest installing the RRDI optional component which comes with some Cognos based advanced report authoring tools.
- Open vs Closed Work Items
- Cumulative Value Flow
Both sound similar to what you are looking for. If you want to really your own, I would suggest installing the RRDI optional component which comes with some Cognos based advanced report authoring tools.