Box and Whisker

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Reports with Graphs >

Box and Whisker

Report Name: Box and Whisker

 

Report Type: Standard Report

 

Description: It uses the Analytical Results II (ARII) Report to retrieve the required source data, calculate their statistic data and generate box and whisker charts. 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.dl. 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.

 

Report Dependencies:        Analytical Results Trend Plot Report and ARII or EarthSoft.Reports.Library.50943.dll.

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection you make 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 below table are visible to users and all the other parameters are hidden by default. Users can publish the report and make those hidden parameters visible in st_report_parameter if necessary.  

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


Sample




Type(s)



Date Range




Start Date



End Date

Result




Analyte




Individual(s)



Group(s)

Plot




Plot group type



The number of plots per print page:



Logo file name:


Others    (Hidden)                                          

boxAndWhisker

1. The plots worksheet with box and whisker charts.

2. The analytical_resutls_data worksheet with source data.

3. The box_whisker_data worksheet with statistics data

 

Tables: 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

 

Databse Type: SQL

 

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

 

Database Version: EQuIS v6.5.0+

 

Data Requirements: N/A

 

Output Type: Excel

 

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

 

Box Whisker - Example

Box Whisker - Example