Description

Returns item of statistics

Property type

A Variant value.  

Statistical item

Syntax

object.ItemStats(ItemIndex, [ReturnVarType])

The ItemStats Property syntax has these parts:

PartDescription
objectAn expression evaluating to an object of type McDataColumn.
ItemIndexRequired. A mcStatsTypes enumeration, as described in settings.

statistical parameter as enumStatsTypes

ReturnVarTypeOptional. A mcDVColVarTypes enumeration, as described in settings.

optional, type of the returned variable as enumDVColVarTypes, can be mcdvVarTypeNative - native variable type from database (time, double,...), default mcdvVarTypeDouble - double mcdvVarTypeString - string

Settings

The settings for ItemIndex are:

ConstantValueDescription
 mcStatsMean0

mean value


mean value

 mcStatsStDev1

standard deviation


standard deviation

 mcStatsMin2

minimum value


minimum value

 mcStatsMax3

maximum value


maximum value

 mcStatsRange4

range


range

 mcStatsSum5

sum


sum

 mcStatsIMin6

index of minimum


index of minimum

 mcStatsIMax7

index of maximum


index of maximum

 mcStatsNItems8

number of items


number of items

The settings for ReturnVarType are:

ConstantValueDescription
 mcdvVarTypeNative0

native variable (time, double,...)

 mcdvVarTypeDouble1

double

 mcdvVarTypeString2

string