Accumulative Percentage | 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 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 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 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. |
Truncate Data Set | Removes N rows from either the top or bottom of the dataset. |