silreporting_avgTable
- Jonathan Muse
- Shane Smith
Owned by Jonathan Muse
Syntax
silreporting_avgTable(silTable)
Description
Calculates the average values per columns for a provided table.
Parameters
Parameter name | Type | Required | Description |
|---|---|---|---|
silTabel | SILReportingTable | Yes | The table. |
Return type
SILReportingTable
The table with the average calculated in the footer.
Example
In the fallowing example you can see the average values per columns for a table which contains the number of opened and resolved issues for a list of projects.
string [] projects = "TEST|FIBR|STEI|GRBI|HGES|RGIS";
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;
SILReportingHeader h1;
h1.name = "Opened Issues";
h1.sortable = "sortable";
headers += h1;
SILReportingHeader h2;
h2.name = "Resolved Issues";
h2.sortable = "sortable";
headers += h2;
string [][] rows;
for(string p in projects){
rows += {openedIssues[p], resolvedIssues[p]};
}
SILReportingTable table;
table.headers = headers;
table.rows = rows;
return silreporting_avgTable(table);