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

From Melissa Data Wiki
Jump to navigation Jump to search
 
Line 2: Line 2:
[[Profiler Object:Reference|← Profiler Object Reference]]
[[Profiler Object:Reference|← Profiler Object Reference]]


{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
{{ProfilerObjectNav
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
|ColumnBasedStatisticsCollapse=
|-
}}
| style="padding-right:220px;"|
|-
|[[Profiler Object:Initialization|Initialization]]
|-
|[[Profiler Object:Object Information|Object Information]]
|-
|[[Profiler Object:Enumeration Listing and Parsing|Enumeration Listing and Parsing]]
|-
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Initiate Profiling|Initiate Profiling]]
|-
|[[Profiler Object:Data Input|Data Input]]
|-
|[[Profiler Object:Profiling|Profiling]]
|-
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black; text-align:left;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|-
|[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
|-
|[[Profiler Object:Column-Based Numeric Statistics|Column-Based Numeric Statistics]]
|-
|[[Profiler Object:Column-Based Date/Time Statistics|Column-Based Date/Time Statistics]]
|-
|[[Profiler Object:Column-Based Name Statistics|Column-Based Name Statistics]]
|-
|[[Profiler Object:Column-Based State/Province Statistics|Column-Based State/Province Statistics]]
|-
|[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
|-
|[[Profiler Object:Column-Based Country Statistics|Column-Based Country Statistics]]
|-
|[[Profiler Object:Column-Based Email Statistics|Column-Based Email Statistics]]
|-
|[[Profiler Object:Column-Based Phone Statistics|Column-Based Phone Statistics]]
|-
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black; text-align:left;"|[[Profiler Object:Iterators|Iterators]]
|-
|[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
|-
|[[Profiler Object:Column-Based Value Length Frequency Table Iteration|Column-Based Value Length Frequency Table Iteration]]
|-
|[[Profiler Object:Column-Based Value Pattern Table Iteration|Column-Based Value Pattern Table Iteration]]
|-
|[[Profiler Object:Column-Based Value Date/Time Table Iteration|Column-Based Value Date/Time Table Iteration]]
|-
|[[Profiler Object:Column-Based Value SoundEx Table Iteration|Column-Based Value SoundEx Table Iteration]]
|-
|[[Profiler Object:Column-Based Word Table Iteration|Column-Based Word Table Iteration]]
|-
|[[Profiler Object:Column-Based Word Length Table Iteration|Column-Based Word Length Table Iteration]]
|-
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black; text-align:left;"|[[Profiler Object:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}




Line 103: Line 28:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnDateMaxValue(columnNameStr);
|Syntax=profiler->GetColumnDateMaxValue(columnNameStr);
|C=string = mdProfilerGetColumnDateMaxValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnDateMaxValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnDateMaxValue(columnNameStr);
|.Net=string = profiler.GetColumnDateMaxValue(columnNameStr);
}}
}}
Line 121: Line 46:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnDateMinValue(columnNameStr);
|Syntax=profiler->GetColumnDateMinValue(columnNameStr);
|C=string = mdProfilerGetColumnDateMinValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnDateMinValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnDateMinValue(columnNameStr);
|.Net=string = profiler.GetColumnDateMinValue(columnNameStr);
}}
}}
Line 138: Line 63:


{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnDateMinValue(columnNameStr);
|Syntax=profiler->GetColumnDateAvgValue(columnNameStr);
|C=string = mdProfilerGetColumnDateMinValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnDateAvgValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnDateMinValue(columnNameStr);
|.Net=string = profiler.GetColumnDateAvgValue(columnNameStr);
}}
}}


Line 157: Line 82:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnDateQ1Value(columnNameStr);
|Syntax=profiler->GetColumnDateQ1Value(columnNameStr);
|C=string = mdProfilerGetColumnDateQ1Value(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnDateQ1Value(profiler, columnNameStr);
|.Net=string = profiler.GetColumnDateQ1Value(columnNameStr);
|.Net=string = profiler.GetColumnDateQ1Value(columnNameStr);
}}
}}
Line 175: Line 100:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnDateMedValue(columnNameStr);
|Syntax=profiler->GetColumnDateMedValue(columnNameStr);
|C=string = mdProfilerGetColumnDateMedValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnDateMedValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnDateMedValue(columnNameStr);
|.Net=string = profiler.GetColumnDateMedValue(columnNameStr);
}}
}}
Line 193: Line 118:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnDateQ3Value(columnNameStr);
|Syntax=profiler->GetColumnDateQ3Value(columnNameStr);
|C=string = mdProfilerGetColumnDateQ3Value(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnDateQ3Value(profiler, columnNameStr);
|.Net=string = profiler.GetColumnDateQ3Value(columnNameStr);
|.Net=string = profiler.GetColumnDateQ3Value(columnNameStr);
}}
}}
Line 211: Line 136:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnTimeMaxValue(columnNameStr);
|Syntax=profiler->GetColumnTimeMaxValue(columnNameStr);
|C=string = mdProfilerGetColumnTimeMaxValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnTimeMaxValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnTimeMaxValue(columnNameStr);
|.Net=string = profiler.GetColumnTimeMaxValue(columnNameStr);
}}
}}
Line 229: Line 154:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnTimeMinValue(columnNameStr);
|Syntax=profiler->GetColumnTimeMinValue(columnNameStr);
|C=string = mdProfilerGetColumnTimeMinValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnTimeMinValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnTimeMinValue(columnNameStr);
|.Net=string = profiler.GetColumnTimeMinValue(columnNameStr);
}}
}}
Line 247: Line 172:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnTimeAvgValue(columnNameStr);
|Syntax=profiler->GetColumnTimeAvgValue(columnNameStr);
|C=string = mdProfilerGetColumnTimeAvgValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnTimeAvgValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnTimeAvgValue(columnNameStr);
|.Net=string = profiler.GetColumnTimeAvgValue(columnNameStr);
}}
}}
Line 265: Line 190:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnTimeQ1Value(columnNameStr);
|Syntax=profiler->GetColumnTimeQ1Value(columnNameStr);
|C=string = mdProfilerGetColumnTimeQ1Value(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnTimeQ1Value(profiler, columnNameStr);
|.Net=string = profiler.GetColumnTimeQ1Value(columnNameStr);
|.Net=string = profiler.GetColumnTimeQ1Value(columnNameStr);
}}
}}
Line 283: Line 208:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnTimeMedValue(columnNameStr);
|Syntax=profiler->GetColumnTimeMedValue(columnNameStr);
|C=string = mdProfilerGetColumnTimeMedValue(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnTimeMedValue(profiler, columnNameStr);
|.Net=string = profiler.GetColumnTimeMedValue(columnNameStr);
|.Net=string = profiler.GetColumnTimeMedValue(columnNameStr);
}}
}}
Line 301: Line 226:
{{ Object Syntax
{{ Object Syntax
|Syntax=profiler->GetColumnTimeQ3Value(columnNameStr);
|Syntax=profiler->GetColumnTimeQ3Value(columnNameStr);
|C=string = mdProfilerGetColumnTimeQ3Value(profiler, columnNameStr);
|C=const char* = mdProfilerGetColumnTimeQ3Value(profiler, columnNameStr);
|.Net=string = profiler.GetColumnTimeQ3Value(columnNameStr);
|.Net=string = profiler.GetColumnTimeQ3Value(columnNameStr);
}}
}}

Latest revision as of 22:05, 23 February 2015

← 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);
Retrieved from "http://wiki.melissadata.com/index.php?title=Profiler_Object:Column-Based_Date/Time_Statistics&oldid=7938"