The default setting is to display totals according to the definition in the query. You can calculate with these values to display another result, for example the highest value for an area.
Option | Description |
---|---|
Minimum | The smallest value for the corresponding area is displayed as the result. |
Maximum | The highest value for the corresponding area is displayed as the result. |
Sum | The total of all values for the corresponding area is displayed as the result. |
Sum of Rounded Values | If you have set a scaling factor, it is useful to calculate the totals of rounded values locally since the totals can differ considerably (in particular with high scaling factors). |
Total Number of Detailed Values | The number of values for the corresponding area is displayed as the result. |
Total Number of Detailed Values that are Not Zero, Null or Error | The number of values for the corresponding area, excluding zeros, is displayed as the result. |
Standard Deviation | The
deviation of the values from its mean is displayed as the result. The more
spread out the data is, the higher the deviation. Standard deviation is
calculated as the square root of variance.
For example, the mean of the following two is the same: 15, 15, 15, 14, 16 and 2, 7, 14, 22, 30. However, the second is clearly more spread out. |
Average | The average (total divided by total number of values) of all values for the corresponding area is displayed as the result. |
Average of All Detailed Values that are Not Zero, Null or Error | The average (total divided by number) of all values for the corresponding area is displayed as the result, with the exception of zeros, meaning that values equal to zero are not counted. |
Median |
The system sorts the values internally by size and displays the mean value from the list as the result. For example, if there are five values in the list, the third value is displayed as the result. If the list has an even number of values (for example six), the system adds the two values in the middle of the list together (in this case, the third and fourth values) and divides the result by two. The resulting value is displayed as the result. |
Median of Detailed Values that are Not Zero, Null or Error |
Excluding the values that are equal to zero, the system sorts the values internally by size and displays the mean value from the list as the result. |
Variance |
The variance is calculated as the square of the standard deviation and displayed as the result. |
Hide | The result is not displayed. |
Default | With this setting, the results provided by the query are displayed. |
The totals are calculated according to your definition.