You are here: Processor Library > Profiling > Number Profiler

Number Profiler

The Number Profiler sorts numeric values in a Number attribute into user-defined bands.

Use

Use this profiler on numeric attributes to gain an understanding of the distribution of numbers, and to find any values which may be out of the expected range.

Configuration

Inputs

A single Number attribute.

Options

Option	Type	Purpose	Default Value
List of numeric bands, defined according to their minimum values	Reference Data (Number Bands Category)	To drive the bands into which numbers will be categorized.	*Number Bands

The default Number Bands Reference Data is intended as an example, and will not be suitable for most types of numeric data. It may be useful when analyzing a percentage value.

Note that any numbers that do not meet a specific band (that is, are either too low, or too high, for any of the bands) are categorized as Out of Range.

Outputs

Data attributes

None

Flags

Flag attribute	Purpose	Possible Values
BandName	Indicates in which band the number appears	The Number Bands defined in the Number Bands Reference Data, and 'Out of range'

Execution

Execution Mode	Supported
Batch	Yes
Real time Monitoring	Yes
Real time Response	Yes

Results Browsing

The Number Profiler presents the following summary statistics:

Statistic	Meaning
Band minimum value	The minimum value in the band
Band name	The name of the band, as defined in the Reference Data
Count	The number of records in that band

Note that numbers that were Out of Range - that is, numbers which were outside of the configured set of Number Bands in the Reference Data - appear in their own row in the Results Browser.

Example

In this example, the Number Profiler analyzes the values in a BALANCE attribute, and outputs the following summary results.

Note that the default *Number Bands Reference Data was used.

Summary View

Note above that the Number Profiler only outputs results for bands where at least one number in the data was found in the band. This allows you to use Reference Data with a large number of bands, but still see focused results.

Drill Down View