Comment:
Migration of unmigrated content due to installation of a new plugin
...
Expand
title
Analysis
Accumulative Percentage
Will print a running percentage for the values returned. A maximum of 100% will be displayed.
Accumulative Total
Will print out a running total for the data returned.
Ascending Rank
The highest value returned will be displayed as a 1. Used where the preferable result is a higher value. Eg. Profit.
Bottom 10 Rank
The bottom 10 values (lowest) are returned.
Bottom N Rank
The bottom N values (lowest) are returned– user is prompted to define number to return.
Delta from Last
Calculate change between consecutive rows
Delta from Last N
Calculate change between the current row and row - N
Descending Rank
The lowest value returned will be displayed as a 1. Used where the preferable result is a lower value. Eg. Expenses.
Difference of Columns
Returns difference of two selected columns
Multiplication of Columns
Returns multiplication of two selected columns
Natural Logarithm
Gives the base e logarithm of the values of a given field.
Natural Logarithm
Gives the base e logarithm of the values in the field.
Percentage Against Absolute Maximum
Returns percentage of selected field according to an absolute maximum value.
Percentage Against Column
Creates a percentage ration of values in the selected column compared to another column.
Percentage Against Maximum
Returns the % of the attribute when compared to the maximum value of the attribute within the dataset.
Percentage of Total
Returns the % of the attribute when compared to the total summed value of the attribute for the entire dataset.
Sum of Columns
Returns the sum of two selected columns.
Top 10 Rank
The top 10 values (highest) are returned.
Top N Rank
The top N values (highest) are returned – user is prompted to define number to return.
Top N With Ties
Returns top values for the selected field with provision for tied values. This means that if there are multiple records per ranking it will restrict it to N total rankings.