InetSoft Product Instructions: Reports Function Reference
This section presents functions for Table and Section operations.
average(column[, group[,condition]])
Calculates the average of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
average of all values in a group
Example
text = average("Quantity", "State", "field['Discount']>0");
concat(column[, group[,condition]])
Concatenates all values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
concatenation of all values in a group
Example
text = concat("Quantity", "State", "field['Discount']>0");
 |
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software. |
correlation(column, column2[, group[,condition]])
Calculates the correlation between two columns. This function is only available to elements within a Section.
Parameters
column column label of the primary column
column2 column label of the column to correlate
group column label of the group to summarize
condition condition on the group to summarize
Return
correlation between the two columns
Example
text = correlation('Quantity','total','State',
"field['Discount']>0");
count(column[, group[,condition]])
Calculates the number of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
number of values in a group
Example
text = count("Quantity", "State", "field['Discount']>0");
 |
Read what InetSoft customers and partners have said about their selection of Style Scope for their solution for dashboard reporting. |
countDistinct(column[, group[,condition]])
Calculates the number of distinct values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
number of distinct values in a group
Example
text = countDistinct("Quantity", "State",
"field['Discount']>0");
covariance(column, column2[, group[,condition]])
Calculate the covariance of two columns. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
column2 second column used in calculating covariance
group column label of the group to summarize
condition condition on the group to summarize
Return
covariance of the two columns
Example
text = covariance('Quantity','Total',"State",
"field['Discount']>0");
max(column[, group[,condition]])
Calculates the maximum of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
maximum of all values in a group
Example
text = max("Quantity", "State", "field['Discount']>0");
median(column[, group[,condition]])
Calculates the median number in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
median number of all values in a group
Example
text = median("Quantity", "State", "field['Discount']>0");
min(column[, group[,condition]])
Calculates the minimum of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
minimum of all values in a group
Example
text = min("Quantity", "State", "field['Discount']>0");
mode(column[, group[,condition]])
Calculates the mode of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
mode of all values in a group
Example
text = mode("Quantity", "State", "field['Discount']>0");