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.