<< 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 |
||||||
---|---|---|---|---|---|---|
|
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.
Copyright © 2023 EarthSoft, Inc • Modified: 17 Oct 2022