{{getMsg('Help_YouAreHere')}}:
/
{{page.title}}
{{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}}
{{helpModel.downloadHelpPdfDataStatus}}
Covariance
Returns the covariance value of the field which defines the measure of linear coherence of two field values.
Usage:
Covariance( fld1, fld2 ) Covariance( fld1, fld2, condFld ) Covariance( fld1, fld2, condFld, cond )
Parameters:
fld1 | The first of two fields needed for calculating the covariance. |
---|---|
fld2 | The second of two fields needed for calculating the covariance. |
condFld | The name of the field that groups the values of fld (if fld isn't an array). |
cond | A string declaring the type of grouping to be used on condFld. This only makes sense for groups based on Date, DateTime, Time, and Boolean fields. See Summary Field Conditions for a list of strings you can use here. |
Returns:
A fractional number.
Examples:
//calculates the coherence of the count of the average income and the average output. Covariance({Prod.income},{Prod.output})
//calculates the same coherence, but grouped by time Covariance({Prod.income},{Prod.output}, {Prod.messurment_time})
Notes:
-
If the values in fld should be grouped, a group based on condFld is needed. If the group does not exist in the report, you can add it using i-net Designer or using API method: Engine.addGroup.
-
An undefined covariance due to a variance of zero will result in a value of 1.