It's all about the answers!

Ask a question

Calculate defect density of project


Dastan Ali (1710) | asked Apr 01 '17, 5:22 a.m.

I want to calculate defect density of project. what i mean is I have to get count of all the defect type of work item in the project and count of total number of test case, divide total number of defects by total number of test cases. This gives me defect density of project. After I get this value I need to display it on the dashboard.
What would be the best way to achieve it. Any pointers/guidance is greatly appreciated.

2 answers



permanent link
Clara Forero (6212) | answered Apr 04 '17, 9:41 a.m.
JAZZ DEVELOPER

Hi Dastan,

By using Jazz Reporting Service, you could create a custom report.  You would have to use the Advanced SQL option to do this, calculate the totals for Defects, the totals for Test Cases and then combine them together for the final calculation.  If you require further assistance, you may contact IBM Support for guidance.

Kind regards,
Clara


Comments
Dastan Ali commented Apr 11 '17, 3:03 a.m.

Hi Clara,

It would be very handy if this is achieved using reporting, I was thinking about RTC extension and OSLC API to achieve this task. Thank you for the suggestion, I will definitely give it a try using Reporting,
Please look into below minor queries,
calculate the totals for Defects - Can I do it in the Advanced SQL option of JRS itself ?
calculate the totals for Test Cases - Can I do it in the Advanced SQL option of JRS itself ?

It would be very useful if you provide some pointers to get started with Advance SQL
section of JRS


permanent link
Clara Forero (6212) | answered Apr 11 '17, 9:53 a.m.
JAZZ DEVELOPER

Hi Dastan,

Those individual totals can be calculated using the UI in Report Builder (RB).  Select the artifact you want the totals of (Work Item, Test Case).  Add the conditions needed, if any (e.g. Creation Date, Iteration).  In the Format Results page add a calculated column that counts the total of artifacts.  At this point you can look at the Advanced SQL section and see the SQL generated by RB.  For your calculation, you will have to put together those two SQL statements and then do the division to calculate the density. 

In the Advanced SQL section you can enter any SELECT statement you need to query the data warehouse.  You can use the auto generated SQL statements to verify in which tables the data is, and see how some of the OOTB calculations are made.  If you require further assistance, please contact IBM Support.

Thank you,
Clara


Comments
Dastan Ali commented Apr 13 '17, 8:17 a.m.

 Hi Clara, 

Thank you for simplification towards solution of the issue, I will give it a try by myself. Will post the answer here after success

Your answer


Register or to post your answer.