Profiler Object:Column-Based Date/Time Statistics: Difference between revisions

From Melissa Data Wiki

Jump to navigation Jump to search

← Older edit Newer edit →

Revision as of 18:51, 2 February 2015

← Profiler Object Reference

Profiler Object Interface Navigation

Object Information

Enumeration Listing and Parsing

Column Specification

Initiate 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

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
Returned 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	string = 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	string = 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->GetColumnDateMinValue(columnNameStr);
C	string = mdProfilerGetColumnDateMinValue(profiler, columnNameStr);
.Net	string = profiler.GetColumnDateMinValue(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	string = 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	string = 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	string = 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	string = 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	string = 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	string = 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	string = 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	string = 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	string = 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);

Retrieved from "http://wiki.melissadata.com/index.php?title=Profiler_Object:Column-Based_Date/Time_Statistics&oldid=7579"

Profiler Object