Used to place a summary of a variable (i.e. GAVG, GMAX, GMINZ functions) based on the report dates. |
|
Fields:
Variable: Sets the variable to summarize
Stat: Sets the summary statistic to use. Choose one from the following on the dropdown list:
Minimum |
Finds the minimum value |
Maximum |
Finds the maximum value |
Total |
Sum of all values found |
Average |
Sum all values and divide by the number of values found |
Avg Over Time |
Sum all values found, then divide by the number of data slots in the date range |
Avg Median |
Calculates the Average Median according to the California Average Median Rules |
Geo Mean (Ignore 0) |
Calculate the Geometric Mean ignoring Zeros |
Geo Mean (Convert 0 to 1) |
Zeros are converted to one (1) before geometric mean is calculated. |
Geo Mean (Add One to All) |
If any value is zero (0), one is added to each value in the set and then one is subtracted from the result. |
# of Daily Violations |
Counts the number of times the daily value is above the daily max limit or below the daily min limit. |
# Samples |
Counts the number of samples |
Median |
The median is the number in the middle of a set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less. |
Standard Deviation |
Calculates the standard deviation for the variable |
Range |
The difference between the max and min value |
First |
Finds the first value that exists in the date range for the variable |
Last |
Finds the last value that exists in the date range for the variable |
Average Difference |
Returns the average of the differences (i.e. the value minus the last value found) for all values in the date range. The difference is calculated based on the difference type setting (see below). |
Maximum Difference |
Returns the maximum of the differences (i.e. the value minus the last value found) for all values in the date range. The difference is calculated based on the difference type setting (see below). |
Minimum Difference |
Returns the minimum of the differences (i.e. the value minus the last value found) for all values in the date range. The difference is calculated based on the difference type setting (see below). |
Total Difference |
Returns the total of the differences (i.e. the value minus the last value found) for all values in the date range. The difference is calculated based on the difference type setting (see below). |
Conditional Count |
Returns the count of values that meet the condition specified by Condition and Limit. |
Place < or > Symbol with statistic: If the variables allow entry of data qualifiers (i.e. <, >, or ND) do you want the symbol to be placed with the calculated statistic. If checked and a statistic that does not find a particular value (i.e. Max, Min, First... find a value, Avg, GeoMean, Total do not) is chosen the following options will be given:
"if one value contains a < or >"
"if all values contain a < or >"
"if half the values are < or >"
"cascade all symbols"
Decimal Places: The number of digits to show behind the decimal point. This value will default to the number of decimal places defined in the description of the variable selected. See Also: Formatting with 'Not Fixed'
Place Start Date of Group: If checked, places the start date of the report beside the data.
Place End Date of Group: If checked, places the end date of the report beside the data.
Print ______ if not data found: Can only be used if placing data with the Place <,>, or ND Symbol with statistic option checked. Will print the specified string (no data, no samples...) if no values for the group are found.
Print the "Optional Print Value" if the Threshold Valve is crossed: If checked, the optional print value from system setup will be printed instead of the actual value when the threshold is crossed.
EXAMPLES:
Report run for June 2008:
Report run for 2007: