Sfairadora

  • Reference Guide

Summary Exceptions

In the Column Properties window, or when inserting a column, you can force some elements of the column summary to contain other than standard values. This may be particularly useful if you need to display a summary for columns that usually don’t have summaries.
Summary exceptions are defined by a two-column table. The first column contains a summary statistic identifier. Items related to different columns with the same summary type identifier are displayed in one row. The following table lists standard summary statistic identifiers. If you use one of these identifiers, the defined exception replaces the respective standard summary statistic. If you use another identifier, a new summary row is created.
Summary Statistic Identifier
Description
Sum
Sum
sum2
Sum of squares
average
Mean
variance
Variance
deviation
Standard deviation
min
Minimum
max
Maximum
In the second column of the summary exceptions, you can specify the control that will be displayed in the summary. Most often you will probably need to display some computed value. This can be achieved either through the line editor, where you specify a getter function computing the requested value, or through the data provider, where you create a local computed variable computing the required value that will be displayed by a subordinate line editor. A summary data object is available under the summary identifier for the calculation of a summary value. It can be used to derive values of other types of summaries, etc.
A new summary statistic common to all columns in a table can be created in the table definition.