Analytical Results II - Statistics (80823)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics Reports >

Analytical Results II - Statistics (80823)

Report Name: Analytical Results II - Statistics (80823)

previously called (Beta) Analytical Results - Statistics

 

Report Type: Standard Report

 

Description: The Analytical Results II - Statistics Report is a report similar to the Analytical Results - Statistics Report. However, it has been adapted to use the Analytical Results Report to make parameter selections. The report is used to compute various statistical functions.

 

Report Dependencies: Analytical Results II

previously called (Beta) Analytical Results

 

File Name: EarthSoft.Reports.Library.80823

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Aggregate




Aggregate Results By



Aggregate Analytes By



Process multiple non-detect limits of an analyte at a location


Location




Individual(s)



Group(s)




Start Date



End Date


Matrix(es)



Task(s)



Delivery Group(s)



Depth




Minimum
Start Depth



Maximum
Start Depth



Unit

Test




Method(s)



Fraction(s)



Column Number(s)



Type(s)



Lab Matrix(es)



Prep Methods


Result




Analyte




Individual(s)



Group(s)


Unit



Type(s)



Detect Flag(s)



Non-Detect Multiplier



Non-Detect Symbol



Reportable



Reporting Limit


Additional Fields






                                               

30185-beta. ar

Contact
support@earthsoft.com
for more information.

 

 

 

In this report is is also possible to filter by additional fields. Learn how here.

 

Tables:
 

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

SAMPLE_ID

SYS_SAMPLE_CODE

SAMPLE_NAME

SAMPLE_DATE

SAMPLE_TYPE_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

TASK_CODE

PARENT_SAMPLE_CODE

ANALYSIS_LOCATION

LAB_SAMPLE_ID

LAB_MATRIX_CODE

LAB_NAME_CODE

ANALYTIC_METHOD

ANALYSIS_DATE

COLUMN_NUMBER

FRACTION

TEST_TYPE

PREP_METHOD

LEACHATE_METHOD

LEACHATE_DATE

LAB_SDG

PERCENT_MOISTURE

DILUTION_FACTOR

TEST_ID

CAS_RN

CHEMICAL_NAME

ORGANIC_YN

REPORT_RESULT_TEXT

REPORT_RESULT_VALUE

REPORT_RESULT_UNIT

REPORT_RESULT_LIMIT

REPORTABLE_RESULT

DETECT_FLAG

INTERPRETED_QUALIFIERS

VALIDATOR_QUALIFIERS

LAB_QUALIFIERS

QUANTITATION_LIMIT

METHOD_DETECTION_LIMIT

REPORTING_DETECTION_LIMIT

DETECTION_LIMIT_UNIT

APPROVAL_CODE

RESULT_TEXT

RESULT_NUMERIC

RESULT_UNIT

RESULT_TYPE_CODE

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM, ZTO

LONGTITUDE

LATITUDE

LOC_GROUP_CODE

LOC_REPORT_ORDER

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 5.4.3+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: IGrid

 

Revision History:

 

In EQuIS 7 when the Max or Min of the "Process multiple non-detect limits of an analyte at a location:" parameter is selected and there are multiple non-detects per analyte/location (e.g. 11 and 2), the report may not correctly process the maximum or minimum non-detect (e.g. it picks 11 as minimum or 2 as maximum). This issue is fixed (Case 139612).

 

Example Output: When the "Aggregate Results By" parameter is selected as loc_group and the "Location - Group(s)" is selected as MONITWELLS, the result is:

 

30185-output

 

Revision History:

 

In version 6.6, the revisions below have been completed.

1.If the "Aggregate Results By" parameter is selected as loc_group and the "Location - Group(s)" is selected, Analytical Results II - Statistics of prior to v6.6 fails to generate results or displays the error message, "Object reference not set to an instance of an object error". The similar issue occurs to the situation where the "Aggregate Analytes By" parameter is selected as group and the "Result/Analyte/Group(s)" is not selected. The issues are fixed. In addition, the report will display an easily understandable message if the parameters are not selected appropriately (Case 131911).