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

 

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_NAMEINCIDENT_COUNT
(none)12
1 - Critical15
2 - High15
3 - Medium11
4 - Low11

and the following graph: