Pattern Detection Configuration & Aesthetics

Funnel patterns can be displayed and formatted in this section.

Type of Change to Flag

This setting determines whether improvement and deterioration are both flagged, or only one of these directions are flagged. These apply across all the enabled patterns. The various options can be selected in the drop down menu:

Type of Change to Flag

  • Both - Both improvement and deterioration patterns are highlighted (default)
  • Improvement (Imp.) - Only improvement patterns are highlighted
  • Deterioration (Det.) - Only deterioration patterns are highlighted

To use these with the conditional formatting, the values must be set to only both, improvement and deterioration respectfully.

This setting should be used in conjunction with the Improvement Direction setting below. With a Neutral improvement direction there is no improvement or deterioration to choose between, so outliers on both sides are always highlighted.

Improvement Direction

This setting determines which direction is deemed to be the improvement direction for the measure. That is, the measure is getting better in this direction. The various options can be selected in the drop down menu:

Improvement Direction

  • Increase - The measure increasing is a favourable outcome, and signals improvement in the measure (default).
  • Neutral - There is no direction set, and the measure increasing or decreasing does not signal improvement or deterioration. This setting is used to detect any statistical variation.
  • Decrease - The measure decreasing is a favourable outcome, and signals improvement in the measure.

To use these with the conditional formatting, the values must be set to only increase, neutral and decrease respectfully.

This setting should be used in conjunction with the Type of Change to Flag setting above.

Pattern Options for Three and Two Sigma

This section covers the settings that are common across the three sigma and two sigma outliers. The below shows the example for three sigma outliers:

Pattern Common Options

Each pattern’s settings are listed under All Settings. The default colours are consistent with the NHS theme.

All Settings

General

Setting Description Default Values
Type of Change to Flag Which changes are flagged. Ignored when the improvement direction is neutral. Both • Both (both)
• Improvement (improvement)
• Deterioration (deterioration)
Improvement Direction Whether higher or lower values are better. Neutral flags both sides in the neutral colours. Increase • Increase (increase)
• Neutral (neutral)
• Decrease (decrease)

Three Sigma Outliers

Setting Description Default Values
Three Sigma Outliers Flags points beyond the 99.8% limits. Off On or Off
Imp. Three Sigma Colour Colour for three-sigma outliers that are an improvement. #00B0F0 Colour
Det. Three Sigma Colour Colour for three-sigma outliers that are a deterioration. #E46C0A Colour
Neutral (Low) Three Sigma Colour Colour for points below the lower 99.8% limit when the improvement direction is neutral. #490092 Colour
Neutral (High) Three Sigma Colour Colour for points above the upper 99.8% limit when the improvement direction is neutral. #490092 Colour

Two Sigma Outliers

Setting Description Default Values
Two Sigma Outliers Flags points beyond the 95% limits. Off On or Off
Imp. Two Sigma Colour Colour for two-sigma outliers that are an improvement. #00B0F0 Colour
Det. Two Sigma Colour Colour for two-sigma outliers that are a deterioration. #E46C0A Colour
Neutral (Low) Two Sigma Colour Colour for points below the lower 95% limit when the improvement direction is neutral. #490092 Colour
Neutral (High) Two Sigma Colour Colour for points above the upper 95% limit when the improvement direction is neutral. #490092 Colour