Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleAnalysis


Accumulative Percentage

Displays a running percentage to total for the values in the field. A maximum of 100% will be displayed.

Accumulative Percentage Against ColumnDisplays the running total of a selected field as a percentage against running totals of other fields.
Accumulative Percentage with Cut-offDisplays 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 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 PreviousDisplays 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 TruncateDisplays the truncated difference between two metric columns.
Division By ColumnDisplays 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 ColumnsDisplays 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 TotalDisplays 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 TotalReturns the highest percentage of the specified field.
Growth TruncateDisplays 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 ZeroDisplays 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 ColumnDisplays 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 ColumnDisplays the percentage of change of the selected field against a value in another column.
Percentage of Initial ValueDisplays 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 AverageDisplays the window average of a certain time period.
Remove ValuesRemove values below above or below a defined threshold.
Sparkline Array Analytic FunctionCreates 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 TotalDisplay records that make up either the top or bottom N % of total.
Truncate Data SetRemoves N rows from either the top or bottom of the dataset.


...