Skew() returns the skewness of expression over a number of records as defined by a group by clause.
Return data type: numeric
|expr||The expression or field containing the data to be measured.|
|DISTINCT||If the word distinct occurs before the expression, all duplicates will be disregarded.|
Examples and results:
Add the example script to your app and run it. Then build a straight table with Type and MySkew as dimensions.
crosstable LOAD recno() as ID, * inline [
25|2 ] (delimiter is '|');
Skew(Value) as MySkew
Resident Table1 Group By Type;
The results of the Skew() calculation in the data load script are: