Analytical Results Trend Plot (Time Series)

Report Name: Analytical Results Trend Plot (Time Series) (example)

File Name: EarthSoft.Reports.Library.67219.dll

Report Dependencies: Analytical Results II and Water Levels II

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: The Analytical Results Trend Plot (Time Series) Report allows users to generate time series plots using the results of the Analytical Results II and the Water Levels II reports.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Note: If the Analytical Results Trend Plot (Time Series) Report has been published to the database, the configuration set in the AnalyticalResultsTrendPlot_default.txt file will be overridden in favor of the settings in the ST_REPORT_PARAMETER table.

Overview:

The main features of the report are:

1.Users can customize the user interface for input parameters.

2.Water level (DT_WATER_LEVEL.EXACT_ELEV, which is calculated based on the default input parameters of the Water Level II Report) can be added onto the Analytical Results plots.

3.If there are different units for a parameter, they are automatically converted to the first location's latest sample result's unit for that parameter and any results with failed unit conversions are removed to seamlessly generate plots.

4.The maximum and minimum values of X-axis can be adjusted over input parameters.

5.On the unit conversion from action level to analyte result, if there is a unit conversion error, the unit of action level of an analyte will not be converted and will be used as it is in charts for seamlessly charting. At the same time, an error message is written to the Errors worksheet.

6.There are several hidden parameters that are available for use once the report is published to the database. To see these hidden parameters, review the rows in ST_REPORT_PARAMETER associated with the Analytical Results Trend Plot ST_REPORT.REPORT_ID and change ST_REPORT_PARAMETER.VISIBILITY from 'N' to 'Y'. Be sure to save changes and then open a new instance of the report.

How to Customize User Interface for Input Parameters

When the report is run for the first time, it generates the AnalyticalResultsTrendPlot_default.txt file in the EQuIS working folder (e.g., C:\Users\USERNAME\Documents\My EQuIS Work\Springfield\Springfield Facility\). Many report parameters based on the Analytical Results II Report are hidden by default in this configuration. To show/hide a user input parameter, modify its visibility value (e.g., modify @sys_loc_codes,Y to @sys_loc_codes,N to hide the location_groups parameter). The AnalyticalResultsTrendPlot_default.txt file can be deleted at any time. The report will use its default user interface for input parameters when the AnalyticalResultsTrendPlot_default.txt file is not available.

Tables: All tables required by the Analytical Results II and the Water Levels II reports

Report Parameters *

Location

Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Sample

Date Range

Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events.

Result

Analyte

Section for selecting analytes and/or analyte groups.

Plot

Plot Group Type

Select how to group plots.

•none (one analyte-location per plot), all plots in one worksheet

•none (one analyte-location per plot), one worksheet per location

•none (one analyte-location per plot), one worksheet per analyte

•by location (analytes-location per plot), all plots in one worksheet

•by location (analytes-location per plot), one worksheet per location

•by analyte (location-analytes per plot), all plots in one worksheet

•by analyte (location-analytes per plot), one worksheet per analyte

The number of plots per print page

Select the number of plots per page.

Series chart type

Select the series chart type: Markers, straight line, straight line with markers, smooth line, smooth line with markers, or column.

Chart Layout

Section for defining chart layout.

Layout

Section for selecting layout1 or layout2.

Layout2

Section for defining layout2 with parameters for Chart Title, Left Y Axis Title, X Axis Title, and Legend Position.

Adjust X axis min/max

Section for defining day less than minimum date and days more than maximum date.

X axis date format

Date configuration options for the x axis.

Use logarithm to y axis

Select common logarithm (log) or natural logarithm (ln). Plotting water level and action level is ignored if using logarithm.

Water Level

Add water level as secondary Y axis

Select to water level as a secondary Y axis (True | False)

Series chart type

Select a secondary chart type: Same to Chemical, markers, straight line, straight line with markers, smooth line, smooth line with markers, column.

Horizontal axis crosses maximum axis value

Select for horizontal axis to cross maximum axis value (True | False)

Date Range

Section to select the water levels start date and end date.

Task(s)

Select one or more tasks

Reported Value

Parameter for selecting which water levels are reported: calculate, corrected_elevation, water_level_elev

Calculation

This section is available when selecting calculate in reported value.

Elevation

Elevation parameter used for calculated water levels: historical_reference_elev, measure_datum, surf_elev, or top_casing_elev

Depth

Depth parameter used for calculated water levels: calculate, corrected_depth, or water_level_depth

Datum

Measure Datum Type

MEASURE_DATUM

Numerical Formatting

Numerical Formatting Type

Decimal Places

Significant Figures

Number that displays Water level elevation (exact_level) as water_level in the selected significant figure format. Defaults to 6.

Decimal Places

Number that displays REFERENCE_ELEV, EXACT_ELEV, MEASURED_DEPTH_OF_WELL, LNAPL_DEPTH, LNAPL_THICKNESS, LNAPL_DENSITY, WATER_DEPTH, WATER_LEVEL_DEPTH and DNAPL_DEPTH with the number of decimal places set by the user. Defaults to 3.

User-estimated product density

If provided, this value will be used instead of the specific gravity.

Default Specific Gravity

The default specific gravity that will be used if no product density is specified and RT_ANALYTE_DETAIL.SPECIFIC_GRAVITY is null. Default = 0.8.

Water

Reportable

Selections of ‘Null/Blank’, ‘N’, and ‘Y’

Action Level

Action Levels

Select one or more action levels.

Use the most conservative action level

Select to use the most conservative action level (True | False)

Logo file name:

Logo file name to be used in left header.

* This report includes the following hidden parameter(s) that could affect the output of the report:

•location

•Individual(s)-Facilities

•sample

•Geologic Unit(s)

•result

•Use Non-Detect Multiplier to Report_Result_Value Only

•chart layout

•Differ point

•symbols of detect from non-detect (a non-functional parameter)

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

Location | Individual(s)-facilities – A multi-select parameter that lists locations alongside their facilities. This can be useful if running the report while logged into a facility group. If selected, this overrides selections from the standard Location | Individual(s) parameter.

Plot

Plot | Plot Group Type – Plots can be grouped in several ways and placed in one or multiple worksheets by either analyte or location:

•none (one analyte-location per plot), all plots in one worksheet

•none (one analyte-location per plot), one worksheet per location

•none (one analyte-location per plot), one worksheet per analyte

•by location (analytes-location per plot), all plots in one worksheet

•by location (analytes-location per plot), one worksheet per location

•by analyte (locations-analyte per plot), all plots in one worksheet

•by analyte (locations-analyte per plot), one worksheet per analyte

Plot | The number of plots per print page – The number of plots per Excel print page can be defined as 1, 2, 3, 4, or 6.

Plot | Series chart type – The following chart types are available.The column chart type for analyte can be used together with a different chart type for water level (e.g., plotting analytes in a column), and water level in a smooth line:

•markers

•straight line

•straight line with markers

•smooth line

•smooth line with markers

•column

Plot | Chart Layout | Layout – Select the default Layout1 or toggle on the customizable Layout2.

Plot | Chart Layout | Layout | Layout 2 – Set the following options:

•Chart Title

•Left Y Axis Title – Defaults to "Concentration(&unit)" for the primary y-axis for analytical results, auto-populating the concentration unit.

•Right Y Axis Title – Defaults to "Water Level(&unit)" for the secondary y-axis for water levels, auto-populating the water level unit.

•X Axis Title – Defaults to "Sample Date" for the x-axis.

•Legend Position – Can select Top or Right.

Plot | Differ Point symbols of detect from non-detect – Choose whether symbols of results where the DETECT_FLAG = "N" should be differentiated from results where the DETECT_FLAG = "Y".

Plot | Adjust X axis min/max | Days less than minimum date, Days more than maximum date – Set the lower and upper bounds of the date range for the x-axis. Setting these values > 0 ensures that range uses is optimized for charts with only one sample or with different date ranges for analytical results and water levels.

Plot | X axis date format – Set the date format for the x axis as specified, where:

•d is a one-digit day (e.g., 2), expandable to two digits as needed (e.g., 21).

•dd is a two-digit day, displaying a zero in front of any single-digit values (e.g., 02).

•M is the numerical one-digit day (e.g., 3 for March), expandable to two digits as needed (e.g., 10 for October).

•MM is the numerical two-digit month (e.g., 03).

•MMM is the abbreviated three-letter text for the month (e.g., Mar for March).

•yy is a two-digit year (e.g., 20).

•yyyy is a four-digit year (e.g., 2026).

If the report is published, it is possible for a user with the Admin role to add additional configurations of the above options in the data_source for the @x_date_format parameter for the report in ST_REPORT_PARAMETER by adding a pipe character ("|") to the end of the data_source field and then adding the custom configuration. For example:

Note: Not all possible configurations have been tested, and different separators may not work.

Plot | Use logarithm to Y axis – Sets a logarithmic scale for the Y axis for analyte plotting. Plotting water levels and action levels is ignored if this setting is turned on.

Water Level

Water Level | Add water level as secondary Y axis – If turned on, water levels will plot on a secondary y-axis.

Water Level | Series chart type – Same as the Plot | Series chart type, except with a default option to use the same chart type as for chemical plotting.

Water Level | Horizontal axis crosses maximum axis value – Option for the x-axis to cross the top of the chart, rather than the bottom.

Action Level

Action Level | Action Levels – Multi-select for Action Levels to add to chart.

Action Level | Use the most conservative action level – If more than one action level is selected and the check box "Use the most conservative action level" is checked, only one or the most conservative action level is plotted. If more than one action level is selected and the check box "Use the most conservative action level" is not checked, the selected action levels are plotted.

Logo file name – If a logo file (default name within the report is artp_logo.jpg) is uploaded to the DT_FILE table, the logo will be in the Excel output file in the left header.

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