Analytical Results (Aggregate) - Standard

<< Click to Display Table of Contents >>

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

Analytical Results (Aggregate) - Standard

Report Name: Analytical Results (Aggregate) - Standard

 

Report Type: Standard Report    

 

Description: The Analytical Results (Aggregate) Report assumes that you have already saved an Analytical Results Report to the pick list.

 

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.

 

Click here for the latest version.

 

Report Dependencies: There are no dependencies for this report.

 

File Name: Contact support@earthsoft.com for a direct file link.

 

File Version: v5.5

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

Saved Analytical Results Report

Aggregate Results By

Aggregate Analytes By

30182-input.params.scrnsht

SYS_LOC_CODE, X_COORD, Y_COORD, Z_COORD, METHOD_ANALYTE_GROUP,
CAS_RN, CHEMICAL_NAME, COUNT, MINIMUM, AVERAGE, MAXIMUM, SUM, UNIT

 

Tables: ST_USER_REPORT

 

Database Type: SQL

 

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

 

Database Version: EQuIS 5.6+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: View the following example or download the attachment.

 

30182-ex.output

 

v54.analytical_result_aggregate