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.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Expand
titleAnalysis

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.

HTML
Wiki Markup
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/ytmCeiVveA0?color=white" frameborder="0" allowfullscreen></iframe>{html}

Expand
titleDate & Time

Days Between Date

The days between the date selected and another date column on the report.

Days to Now

The days between the date selected and the current date. (age in days)

Months Between Date

The months between the date selected and another date column on the report.

Months to Now

The months between the date selected and the current date. (age in months)

Weeks Days Between

The week days between the date selected and another date column on the report.

Years Between Date

The years between the date selected and another date column on the report.

Years to Now

The years between the date selected and the current date. (age in years)

...