silreporting_avgTable

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

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);