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

The transposed table.

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