Profiler Object:Column-Based Date/Time Statistics

From Melissa Data Wiki
Jump to navigation Jump to search

← Profiler Object Reference

Profiler Object Interface Navigation
Initialization
Object Information
Enumeration Listing and Parsing
Column Specification
Initiate Profiling
Data Input
Profiling
Table-Based Statistics
Column-Based Statistics
Column-Based String Statistics
Column-Based Numeric Statistics
Column-Based Date/Time Statistics
Column-Based Name Statistics
Column-Based State/Province Statistics
Column-Based Zip/Postal Code Statistics
Column-Based Country Statistics
Column-Based Email Statistics
Column-Based Phone Statistics
Frequency Iterators
Column-Based Value Frequency Table Iteration
Column-Based Value Length Frequency Table Iteration
Column-Based Value Pattern Table Iteration
Column-Based Value Date/Time Table Iteration
Column-Based Value SoundEx Table Iteration
Column-Based Word Table Iteration
Column-Based Word Length Table Iteration
Result Codes
Profiler Object Result Codes
Result Codes


Theses statistics should only be retrieved after calling the ProfileData function. These values are all column-specific. Date/Time statistics are computed for all column types including non-date/time-based ones (such as strings, numeric, etc.)

Quartiles and Medians

A median value is the 'middle' value. That is, if one were to order a list of 100 values from lowest to highest (including duplicate values), the median value is the value of the 50th item. There are two quartile values: first and third. In the previous example, the first quartile would be the 25th value, and the third quartile would be the 75th value. In cases where the total number of records is not evenly divisible, the value closest to the quartile or median point is used.

GetColumnDateMaxValue

This function returns a column’s largest Date/Time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s largest Date/Time value.


Syntax profiler->GetColumnDateMaxValue(columnNameStr);
C const char* = mdProfilerGetColumnDateMaxValue(profiler, columnNameStr);
.Net string = profiler.GetColumnDateMaxValue(columnNameStr);


GetColumnDateMinValue

This function returns the column’s smallest Date/Time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s smallest Date/Time value.


Syntax profiler->GetColumnDateMinValue(columnNameStr);
C const char* = mdProfilerGetColumnDateMinValue(profiler, columnNameStr);
.Net string = profiler.GetColumnDateMinValue(columnNameStr);


GetColumnDateAvgValue

This function returns a column’s average Date/Time value. For date/time values, an average value is determined by averaging the Julian date and time (as a floating point number), and then taking the averaged result and converting it back to a date/time.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s average Date/Time value.


Syntax profiler->GetColumnDateAvgValue(columnNameStr);
C const char* = mdProfilerGetColumnDateAvgValue(profiler, columnNameStr);
.Net string = profiler.GetColumnDateAvgValue(columnNameStr);


GetColumnDateQ1Value

This function returns a column’s first quartile Date/Time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s first quartile Date/Time value.


Syntax profiler->GetColumnDateQ1Value(columnNameStr);
C const char* = mdProfilerGetColumnDateQ1Value(profiler, columnNameStr);
.Net string = profiler.GetColumnDateQ1Value(columnNameStr);


GetColumnDateMedValue

This function returns a column’s median Date/Time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s median Date/Time value.


Syntax profiler->GetColumnDateMedValue(columnNameStr);
C const char* = mdProfilerGetColumnDateMedValue(profiler, columnNameStr);
.Net string = profiler.GetColumnDateMedValue(columnNameStr);


GetColumnDateQ3Value

This function returns a column’s thrid quartile Date/Time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s third quartile Date/Time value.


Syntax profiler->GetColumnDateQ3Value(columnNameStr);
C const char* = mdProfilerGetColumnDateQ3Value(profiler, columnNameStr);
.Net string = profiler.GetColumnDateQ3Value(columnNameStr);


GetColumnTimeMaxValue

This function returns a column’s largest time value as sorted earliest to latest. This will not consider date for this calculation.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s largest time value.


Syntax profiler->GetColumnTimeMaxValue(columnNameStr);
C const char* = mdProfilerGetColumnTimeMaxValue(profiler, columnNameStr);
.Net string = profiler.GetColumnTimeMaxValue(columnNameStr);


GetColumnTimeMinValue

This function returns a column’s smallest time value. This will not consider date for this calculation.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s smallest time value.


Syntax profiler->GetColumnTimeMinValue(columnNameStr);
C const char* = mdProfilerGetColumnTimeMinValue(profiler, columnNameStr);
.Net string = profiler.GetColumnTimeMinValue(columnNameStr);


GetColumnTimeAvgValue

This function returns a column’s average time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s average time value.


Syntax profiler->GetColumnTimeAvgValue(columnNameStr);
C const char* = mdProfilerGetColumnTimeAvgValue(profiler, columnNameStr);
.Net string = profiler.GetColumnTimeAvgValue(columnNameStr);


GetColumnTimeQ1Value

This function returns a column’s first quartile time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s first quartile time value.


Syntax profiler->GetColumnTimeQ1Value(columnNameStr);
C const char* = mdProfilerGetColumnTimeQ1Value(profiler, columnNameStr);
.Net string = profiler.GetColumnTimeQ1Value(columnNameStr);


GetColumnTimeMedValue

This function returns a column’s median time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s median time value.


Syntax profiler->GetColumnTimeMedValue(columnNameStr);
C const char* = mdProfilerGetColumnTimeMedValue(profiler, columnNameStr);
.Net string = profiler.GetColumnTimeMedValue(columnNameStr);


GetColumnTimeQ3Value

This function returns a column’s third quartile time value.

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get the column’s third quartile time value.


Syntax profiler->GetColumnTimeQ3Value(columnNameStr);
C const char* = mdProfilerGetColumnTimeQ3Value(profiler, columnNameStr);
.Net string = profiler.GetColumnTimeQ3Value(columnNameStr);


GetColumnDateNoCenturyCount

This function returns a column’s number of records that contain no century indicator (i.e., a date formatted like 19-01-63 as opposed to a date with a century indicator like 19-01-1963.)

This function takes one parameter.

Parameters

Name Data Type Description
ColumnName String Column Name to get number of records without century indicator.


Syntax profiler->GetColumnDateNoCenturyCount(columnNameStr);
C integer = mdProfilerGetColumnDateNoCenturyCount(profiler, columnNameStr);
.Net integer = profiler.GetColumnDateNoCenturyCount(columnNameStr);