Labels advanced editor syntax

Column, row and axis calculations

These refer by default to column 1 or row 1 in your crosstab – note that you can work with lookup values to point to a particular column or row.

column calculations

Description

column.sum

Sums up the total of the column

column.avg

Calculates the average of the column

column.min

Returns the minimum value of the column

column.max

Returns the maximum value of the column

column.stdev

Retuns the standard deviation of the column

column.median

Returns the median of the column

column.percentile(pct)

E.g. column.percentile(0,25) returns 25% percentile

column.count

Returns number of values in the column

column.membercount

Returns numbers of members in the column

 

row calculations

Description

row.sum

Sums up the total of the row

row.avg

Calculates the average of the row

row.min

Returns the minimum value of the row

row.max

Returns the maximum value of the row

row.stdev

Retuns the standard deviation of the row

row.median

Returns the median of the row

row.percentile(pct)

E.g. row.percentile(0,25) returns 25% percentile

row.count

Returns number of values in the row

row.membercount

Returns numbers of members in the row

 

axis calculations

Description

axis.sum

Sums up the total of the axis

axis.avg

Calculates the average of the axis

axis.min

Returns the minimum value of the axis

axis.max

Returns the maximum value of the axis

axis.stdev

Retuns the standard deviation of the axis

axis.median

Returns the median of the axis

axis.percentile(pct)

E.g. axis.percentile(0,25) returns 25% percentile

axis.count

Returns number of values in the axis

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.