/
Opened vs Resolved Issues (Table Report)

Opened vs Resolved Issues (Table Report)

This particular example will generate a table report showing the number of opened issues vs number of resolved issues for a given list of projects. 

string [] projects = argv[ 0 ];
string [] resolvedIssues;
string [] openedIssues;
for (string p in projects) {
     resolvedIssues[p] += countIssues( "project = " + p  +  " AND status in (Done, Closed, Resolved)" );
     openedIssues[p] += countIssues( "project = " + p  +  " AND status not in (Done, Closed, Resolved)" );
}
 
SILReportingHeader [] headers;  // the hearders of the table
 
SILReportingHeader h1;
h1.name "Opened Issues" ;
h1.sortable =  "sortable" ;
h1.color =  "white" ;
h1.bgColor =  "#79aadb" ;
headers += h1;
     
SILReportingHeader h2;
h2.name "Resolved Issues" ;
h2.sortable =  "sortable" ;
h2.color =  "white" ;
h2.bgColor =  "#79aadb" ;
headers += h2;
 
string [][] rows;  // populating the rows
for (string p in projects){
     rows += {openedIssues[p], resolvedIssues[p]};
}
 
SILReportingTable table;
table.headers = headers;
table.rows = rows;
 
return table;

For more information about the predefined structures that comes in help for the table reports check the  predefined structure types  page.



Related content

Table Reports
Read with this
Opened vs Resolved Issues (Table Report)
Opened vs Resolved Issues (Table Report)
More like this
Predefined Structure Types for Power Dashboard
Predefined Structure Types for Power Dashboard
Read with this
Opened vs Resolved Issues Report Transposed
Opened vs Resolved Issues Report Transposed
More like this
Opened vs Resolved Issues Report Transposed
Opened vs Resolved Issues Report Transposed
More like this
silreporting_transposeTable
silreporting_transposeTable
More like this