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_NAME | INCIDENT_COUNT |
|---|
| Library Information System | 63 |
| Sample Application One | 1 |
and the following graph:
Count of Incidents By Priority
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 priority across all projects:
select (case when INC.PRIORITY_NAME is null then '(none)' else INC.PRIORITY_NAME end) as PRIORITY_NAME, count(INC.INCIDENT_ID) as INCIDENT_COUNT
from SpiraTestEntities.R_Incidents as INC
where INC.IS_DELETED = False
group by INC.PRIORITY_NAME
order by INC.PRIORITY_NAME
That gives the following data grid:
| PRIORITY_NAME | INCIDENT_COUNT |
|---|
| (none) | 12 |
| 1 - Critical | 15 |
| 2 - High | 15 |
| 3 - Medium | 11 |
| 4 - Low | 11 |
and the following graph:
