Action Level Exceedance Crosstab - Adding Extra Rows
Copyright © 2018 EarthSoft, Inc • Modified: 23 Nov 2018
The Exceedance Flag field is not populated in the original Action Level Exceedance Report; therefore, only exceedances are returned in the report.
There are multiple action levels. The analyte sometimes exceeds only one action level, and sometimes two or more (see example below).
When the Action Level Exceedance Report is crosstabbed and the above crosstab is generated, two sets of results for a single analyte (in this case, Iron) are produced; those that exceed only action level A and those that exceed both A and B action levels.
The first set of results (that exceed only A) were not matched with action level B, because there was no such result in the Action Level Exceedance output (because they are not exceedances of action level B). Therefore, when the final crosstab is run, it creates two sets of row headers for Iron, the set of row headers that include results that exceed only action level A, and the set of row headers that include the results that exceed both A and B action levels.
The crosstab output shows only result values that are exceedances, because only exceedances were produced by the Action Level Exceedance Report.
The Action Level Exceedance II Reports now have the functionality to either display duplicate rows for multiple action levels or for only one row. This is possible by using the Flagging> Show Results report parameter of Show With Any Exceedance. This allows the crosstab to display a single column or row for each chemical instead of one column or row for the results that exceed one Action Level, and another column or row for the results that exceed both Action Levels.