Box and Whisker

<< Click to Display Table of Contents >>

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

Box and Whisker

Report Name: Box and Whisker (example)

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

Report Dependencies:        Analytical Results Trend Plot Report and Analytical Results II

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

 

Description: The Box and Whisker report uses Analytical Results II report source data to calculate statistic data and generate box and whisker charts.

 

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

 

Overview:

The basic statistic calculation equations from Excel used in the report can be found in the box_whisker_data worksheet of the output. It is encapsulated in the EarthSoft.Reports.Library.67219.dll. Since the Syncfusion of the current version (11.3040.0.30) has bugs in drawing Error-bar of a plot, an embedded Excel template with macro is used.

 

Input Parameters: A selection made to customize the output of a report. Note the report has all the parameters of the ARII Report, except the Additional Fields parameter. The input parameters in the table below are visible to users; all other parameters are hidden by default. Users can publish the report and make those hidden parameters visible in ST_REPORT_PARAMETER if necessary.  

 

Table Source FACILITY_ID, FACILITY_CODE, SYS_LOC_CODE, LOC_NAME, SAMPLE_ID, SYS_SAMPLE_CODE, SAMPLE_NAME, SAMPLE_DATE, SAMPLE_TYPE_CODE, START_DEPTH, END_DEPTH, DEPTH_UNIT, MATRIX_CODE, TASK_CODE, PARENT_SAMPLE_CODE, ANALYSIS_LOCATION, LAB_SAMPLE_ID, LAB_MATRIX_CODE, LAB_NAME_CODE, ANALYTIC_METHOD, ANALYSIS_DATE, COLUMN_NUMBER, FRACTION, TEST_TYPE, PREP_METHOD, LEACHATE_METHOD, LEACHATE_DATE, LAB_SDG, PERCENT_MOISTURE, DILUTION_FACTOR, TEST_ID, CAS_RN, CHEMICAL_NAME, ORGANIC_YN, REPORT_RESULT_TEXT, REPORT_RESULT_VALUE, REPORT_RESULT_UNIT, REPORT_RESULT_LIMIT, REPORTABLE_RESULT, DETECT_FLAG, INTERPRETED_QUALIFIERS,  VALIDATOR_QUALIFIERS, LAB_QUALIFIERS, QUANTITATION_LIMIT, METHOD_DETECTION_LIMIT, REPORTING_DETECTION_LIMIT, DETECTION_LIMIT_UNIT, APPROVAL_CODE, RESULT_TEXT, RESULT_NUMERIC, RESULT_UNIT, RESULT_TYPE_CODE, X_COORD, Y_COORD, Z_COORD_AVG, ZFROM, ZTO, LONGTITUDE, LATITUDE, LOC_GROUP_CODE, LOC_REPORT_ORDER

 

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.

The number of plots per print page

Select the number of plots per page.

Logo file name:

Logo file name to be used in left header.

 

 

Report Output

1. The plots worksheet with box and whisker charts.

2. The analytical_results_data worksheet with source data.

3. The box_whisker_data worksheet with statistics data.

 

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