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 |
Comments
If the minimum and maximum values for the key figure axis are set dynamically in the waterfall chart (e.g.: minimum: (min(abs(column.min),abs(column.max))*0.8), maximum: (max(abs(column.min),abs(column.max))*1.2), the error message "Invalid Number" occurs. If you use axis.min or axis.max instead, there is no error message, but the calculation of the maximum value is affected by the newly calculated minimum an so not reliable, if the minimum value is negativ.
Hi Markus,
The measure axis minimum and maximum settings can only work with the 'axis' calculations. The 'column' and 'row' calculations can be used for e.g. labels.
If you can elaborate a bit more on what you need to do (add screenshots?) I might be able to help you.
Best regards,
Ole
Please sign in to leave a comment.