Highlight Detected Results in Crosstab

<< Click to Display Table of Contents >>

Navigation:  Professional > Reports > Crosstab Reports > Formatting >

Highlight Detected Results in Crosstab

Highlight Detected results in a Crosstab report, similar to highlighting Action Level Exceedances, on any report that outputs a DETECT_FLAG column.

 

Note: A Detected result is any result where the DETECT_FLAG value is "Y" or "TR".

 

To do this, add the DETECTED column from the available columns to either the Column Header(s) or Row Header(s) panels in the Crosstab Configuration Form, then apply Exceedance formatting. Since the DETECTED column will be empty (no values are associated with it), you will likely want to hide this column.

 

15501-HighlightDetectedResult

 

Notes:

 

You can add the DETECTED column once to each of the Row Header(s) and Column Header(s) panes to combine Exceedance formatting. Do not add it more than once to either pane.

To utilize this feature, whenever the report contains the DETECT_FLAG column, the DETECTED and DETECTED_FLAG column are added to the list of columns in the Crosstab configuration. The DETECTED column is an empty column. The DETECTED_FLAG column has a flagged value for every DETECT_FLAG "Y" or "TR" value, similar to action level flags. With the DETECTED column in a header pane, the Crosstab will use the DETECTED_FLAG column to determine which report values are detections based on the flag.