Analytical Results (Aggregate)

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics >

Analytical Results (Aggregate)

Report Name: Analytical Results (Aggregate) (example)

Stored Procedure: v54.analytical_result_aggregate

Report Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Standard Schema

Language: English

Output Type: Excel1

 

Description: The Analytical Results (Aggregate) Report assumes that you have already saved a User Report for Analytical Results.

 

Installation Instructions: This report is part of the EQuIS Schema and is created when the EQuIS database is created. No additional steps necessary.

 

Overview:

 

To create an aggregate report:

1.Open a saved analytical report to be aggregated.

2.Choose to aggregate:

a.by location (X, Y)

b.by location and elevation (X, Y, Z)

c.by individual analyte

d.by analyte group.

 

For Dot Plot:

Optionally include labels.

If geographic extent is defined in DT_FACILITY (x_min, x_max, etc.), it is used for axis scale when creating a dot plot.

 

For Google Earth:

Ensure that you have Lat/Long coordinates in VW_LOCATION.

Send the grid to Google Earth to produces balloons for each location.

Send the dot plot to Google Earth to produces 3D cylinders.

 

Report Parameters

Saved Analytical Results Report

Select a saved Analytical Results user report.

Aggregate Results By

Select how to aggregate the results: elevation, location group or location

Aggregate Analytes By

Select how to aggregate the analytes: individual or group

 

 

Report Output

SYS_LOC_CODE

X_COORD

Y_COORD

Z_COORD

METHOD_ANALYTE_GROUP

CAS_RN

CHEMICAL_NAME

COUNT

MINIMUM

AVERAGE

MAXIMUM

SUM

UNIT

 

1Excel report output requires a valid license of Microsoft Excel to view the output.