Analytical Results (Aggregate) - Standard

<< Click to Display Table of Contents >>

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 produce balloons for each location.

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

 

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_CORD

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