Displays a running percentage to total for the values in the field. A maximum of 100% will be displayed.
Accumulative Percentage Against Column
Displays the running total of a selected field as a percentage against running totals of other fields.
Accumulative Percentage with Cut-off
Displays a running percentage of total for the values in the field. A maximum % cut-off can be specified, or set to user prompt.
Accumulative Total
Displays out a running total for the values in the field.
Ascending Rank
Displays a rank based on the values in the field. The highest value returned will be displayed as a 1. Used where the preferable result is a higher value. Eg. Profit.
Bottom 10 Rank
Displays a rank based on the values in the field. The bottom 10 values (lowest) are returned.
Bottom N Rank
Displays a rank based on the values in the field. The bottom N values (lowest) are returned—user is prompted to define number to return.
Delta from Last
Displays the calculated change between consecutive rows.
Delta from Last N
Displays the calculated change between the current row and row - N.
Descending Rank
Displays a rank based on the values in the field. The lowest value returned will be displayed as a 1. Used where the preferable result is a lower value. Eg. Expenses.
Deviation From Previous
Displays the deviation from the previous value. The formula used is: (current value - previous value) / previous value.
Difference of Columns
Displays the result of the difference of two selected columns.
Difference Truncate
Displays the truncated difference between two metric columns.
Division By Column
Displays the result of the division of two selected columns, where the current column is the denominator and the numerator is defined in the setup.
Division of Columns
Displays the result of the division of two selected columns, where the current column is the numerator and the denominator is defined in the setup.
Filter Percentage of Total
Displays the percentage of total for the values in the field, where the percentages are either above or below a specified threshold depending on the direction defined.
Grouped Percentage of Total
Returns the highest percentage of the specified field.
Growth Truncate
Displays the truncated growth between two metric fields as a percentage.
Multiplication of Columns
Displays the multiplication of two selected columns.
Natural Logarithm
Gives the base e logarithm of the values of a given field.
Null To Zero
Displays all NULL values found in the field with zero (0).
Percentage Against Absolute Maximum
Returns percentage of selected field according to an absolute maximum value.
Percentage Against Accumulative Column
Displays the percentage of a selected field against running totals in other fields.
Percentage Against Column
Creates a percentage ratio 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 Change Against Column
Displays the percentage of change of the selected field against a value in another column.
Percentage of Initial Value
Displays the percentage of a value compared to the initial value in the column
Percentage of Segment
Calculates the percentage the chosen metric contributes to the subtotal for a selected dimension.
Percentage of Total
Returns the % of the attribute when compared to the total summed value of the attribute for the entire dataset.
Periodic Average
Displays the window average of a certain time period.
Remove Values
Remove values below above or below a defined threshold.
Sparkline Array Analytic Function
Creates an array of the selected metric by aggregating data by a date field. Tip: Use this with the Sparkline Formatter to create a sparkline chart in a report. Click here for a tutorial.
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.
Top/Bottom N Percentage of Total
Display records that make up either the top or bottom N % of total.
Top/Bottom N Rank
Returns the Top/Bottom values for the selected field. The user can specify how many items to display or set that as a user prompt. The direction - top or bottom, can also be configured, as well as how to handle values that do not meet the threshold, and whether to display the field as the rank or the actual value.
Truncate Data Set
Removes N rows from either the top or bottom of the dataset.