Dividend = Query only defect that we considered as valid (We have multiple type for defect, only few that considered as 'valid defect')

Divider = Query only test case execution record that has result with Pass and Fail (Test result can be Pass, Fail, NA, In-progress, Blocked. We want to sum only Pass and Fail)

Quotient = Defect Density as percentage

Now we use build the report to count the defect and TCER but we have to do an extra work to calculate it outside ELM.

============

Could you please give me an advise on how to achieve this.

I have told to use SQL Query in Advance option and given this link

"Data dictionary for test artifacts"

https://www.ibm.com/docs/en/elm/7.0.2?topic=reporting-quality-management-data-dictionary

I've looked at it and it really confusing, for example.

SQL Query in report builder.

WHERE T4.PROJECT_ID IN (0, 2) AND (T4.TESTPLAN_NAME = 'SIT_P2020-00269 E-Withholding Tax e-WHT' ) AND T4.ISSOFTDELETED = 0 AND (T4.EXECWORKITEM_ID <> -1 AND T4.EXECWORKITEM_ID IS NOT NULL)GROUP BY T4.TESTPLAN_NAME ) U1 ORDER BY U1.REQUEST_STATE asc, U1.CURRENT_RESULT_VERDICT asc

But in Data dictionary for Defect / Work item https://www.ibm.com/docs/en/elm/7.0.2?topic=dictionary-defect-work-item

They look completely difference.

How am I suppose to know how to edit my own report on SQL Query via this document?

============

Answer from this post https://jazz.net/forum/questions/237669/how-to-create-defect-density-report-in-jrs

is to ask IBM support

But I came here because IBM support told me and he link this post https://jazz.net/forum/questions/243369/custom-expressions-in-jazz-report-builder to use as a reference.

Regards,

Derm Phongninlarphon