Hi can anyone help in creating a custom report to show which release an incident was detected. I am trying to show the spread pattern to see when we are identifying incidents to see if our new quality measures are improving earlier detection times I saw a custom report that show an incident count by project, but i do not have the expertise to add releases to the list indented underneath and show a count by detected release Count of Incidents By Project The following Entity SQL command can be used in the Spira custom report (custom section) or Spira custom graph administration section to generate a graph of incidents by project: select INC.PROJECT_NAME, count(INC.INCIDENT_ID) as INCIDENT_COUNT from SpiraTestEntities.R_Incidents as INC where INC.IS_DELETED = False group by INC.PROJECT_NAME order by INC.PROJECT_NAME That gives the following data grid: PROJECT_NAMEINCIDENT_COUNT Library Information System63 Sample Application One1 Can anyone help? en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/2599.aspxthreadId=2599admin computacenter (spiratest.request@computacenter.com)custom report incident count by release Hi can anyone help in creating a custom report to show which release an incident was detected. I am trying to show the spread pattern to see when we are identifying incidents to see if our new quality measures are improving earlier detection times I saw a custom report that show an incident count by project, but i do not have the expertise to add releases to the list indented underneath and show a count by detected release Count of Incidents By Project The following Entity SQL command can be used in the Spira custom report (custom section) or Spira custom graph administration section to generate a graph of incidents by project: select INC.PROJECT_NAME, count(INC.INCIDENT_ID) as INCIDENT_COUNT from SpiraTestEntities.R_Incidents as INC where INC.IS_DELETED = False group by INC.PROJECT_NAME order by INC.PROJECT_NAME That gives the following data grid: PROJECT_NAMEINCIDENT_COUNT Library Information System63 Sample Application One1 Can anyone help? Tue, 12 Apr 2022 08:57:20 -04002022-04-13T04:31:57-04:00/Support/Forum/spirateam/reports/2599.aspxmessageId=5645David J (adam.sandman+support@inflectra.com) Please try this: select INC.PROJECT_NAME, INC.DETECTED_RELEASE_VERSION_NUMBER, count(INC.INCIDENT_ID) as INCIDENT_COUNT from SpiraTestEntities.R_Incidents as INC where INC.IS_DELETED = False group by INC.PROJECT_NAME, INC.DETECTED_RELEASE_VERSION_NUMBER order by INC.PROJECT_NAME Wed, 13 Apr 2022 04:31:57 -04002022-04-13T04:31:57-04:00/Support/Forum/spirateam/reports/2599.aspx#reply5645