Admin at 22:05, 23 February 2015

2015-02-23T22:05:57Z

Admin at 18:51, 2 February 2015

2015-02-02T18:51:29Z

← Older revision		Revision as of 18:51, 2 February 2015
Line 27:		Line 27:
	{\| class="mw-collapsible" style="width:100%;"		{\| class="mw-collapsible" style="width:100%;"
	\|- align="left"		\|- align="left"
	! style="color:black;"\|[[Profiler Object:Column-Based Statistics\|Column-Based Statistics]]		! 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 String Statistics\|Column-Based String Statistics]]
Line 52:		Line 52:
	{\| class="mw-collapsible mw-collapsed" style="width:100%;"		{\| class="mw-collapsible mw-collapsed" style="width:100%;"
	\|- align="left"		\|- align="left"
	! style="color:black;"\|[[Profiler Object:Iterators\|Iterators]]		! 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 Frequency Table Iteration\|Column-Based Value Frequency Table Iteration]]
Line 73:		Line 73:
	{\| class="mw-collapsible mw-collapsed" style="width:100%;"		{\| class="mw-collapsible mw-collapsed" style="width:100%;"
	\|- align="left"		\|- align="left"
	! style="color:black;"\|[[Profiler Object:Result Codes\|Result Codes]]		! style="color:black; text-align:left;"\|[[Profiler Object:Result Codes\|Result Codes]]
	\|-		\|-
	\|[[Returned Result Codes:APIs#Profiler Object\|Returned Result Codes]]		\|[[Returned Result Codes:APIs#Profiler Object\|Returned Result Codes]]

Admin at 23:03, 8 January 2015

2015-01-08T23:03:17Z

← Older revision		Revision as of 23:03, 8 January 2015
Line 29:		Line 29:
	! style="color:black;"\|[[Profiler Object:Column-Based Statistics\|Column-Based Statistics]]		! style="color:black;"\|[[Profiler Object:Column-Based Statistics\|Column-Based Statistics]]
	\|-		\|-
	\|[[Profiler Object:Column-Based String Statistics\|C=String 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 Numeric Statistics\|Column-Based Numeric Statistics]]

Admin: Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..."

2015-01-08T22:10:51Z

Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..."

New page

[[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;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
|-
| 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;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|-
|[[Profiler Object:Column-Based String Statistics|C=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;"|[[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;"|[[Profiler Object:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

<div class="toclimit-2">{{CustomTOC}}</div>

Theses statistics should only be retrieved after calling the '''[[Profiler Object:Profiling#ProfileData|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s largest Date/Time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s smallest Date/Time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s average Date/Time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s first quartile Date/Time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s median Date/Time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s third quartile Date/Time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s largest time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s smallest time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s average time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s first quartile time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s median time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s third quartile time value.
}}

{{ Object Syntax
|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===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get number of records without century indicator.
}}

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

[[Category:Profiler Object]]

Profiler Object:Column-Based Date/Time Statistics - Revision history

Admin at 22:05, 23 February 2015

Admin at 18:51, 2 February 2015

Admin at 23:03, 8 January 2015

Admin: Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..."