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.

...

Overview


Styleclass
ClasstopLink

top37061042

Advanced Functions are used to transform results by applying post processing calculations to the initial query results. These functions are database independent as they are performed by Java code, rather than being part of the SQL query.

...

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 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 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.

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.

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 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.

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 sparkline charts in reports. 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.


...

Applying a Function


Styleclass
ClasstopLink

top37061042


Report Builder - Data Step

...

Applying Data Conversion


Styleclass
ClasstopLink

top37061042

Data in a field can be converted by completing the following:

...

horizontalrule

Styleclass
ClasstopLink

top37061042