A customer of ours asked for a custom report / graph for displaying the count of incidents by project and by priority.

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:

Article Info
  • Last Updated: 10/30/2018
  • Article ID: KB400
  • Views: 85