Accumulative Percentage <=
/td>
| Displays a running percentage to total for th=
e values in the field. A maximum of 100% will be displayed. |
Accumulative Percentage Ag=
ainst Column |
Displays the running total o=
f a selected field as a percentage against running totals of other fields.<=
/span> |
Accumulative Percentage wi=
th Cut-off |
Displays a running percentage of t=
otal 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 i=
n the field. |
Ascending Rank |
Displays a rank based on the values in the fi=
eld. The highest value returned will be displayed as a 1. Used where the pr=
eferable result is a higher value. Eg. Profit. |
Bottom 10 Rank |
Displays a rank based on the values in the fi=
eld. 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=E2=80=94user is=
prompted to define number to return. |
Delta from Last |
Displays the calculated change between consec=
utive rows. |
Delta from Last N |
Displays the calculated change between the cu=
rrent 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 pr=
evious 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 diffe=
rence between two metric columns. |
Division By Column |
Displays the result of the divisio=
n 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 d=
ivision 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 f=
or the values in the field, where the percentages are either above or below=
a specified threshold depending on the direction defined. |
Grouped Percentage of Tota=
l |
Returns the highest percentage of =
the specified field. |
Growth Truncate=
td>
| Displays the truncated growt=
h between two metric fields as a percentage. |
Multiplication of Columns |
Displays the multiplication of two selected c=
olumns. |
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=
strong> |
Returns percentage of selected field accordin=
g to an absolute maximum value. |
Percentage Against Accumul=
ative 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=
p> |
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 Valu=
e |
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<=
/td>
| Displays the window average =
of a certain time period. |
Remove Values |
Remove values below above or below=
a defined threshold. |
Sparkline Array Analytic F=
unction |
Creates an array of the sele=
cted metric by aggregating data by a date field. Tip: Use this with the Sparkline Formatter to create a sparkline chart in a re=
port. Click here=
for a tutorial. |
Sum of Columns |
Returns the sum of two selected columns. <=
/td>
|
Top 10 Rank |
The top 10 values (highest) are returned. =
|
Top N Rank |
The top N values (highest) are returned =E2=
=80=93 user is prompted to define number to return. |
Top N With Ties |
Returns top values for the selected field wit=
h 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 eithe=
r the top or bottom N % of total. |
Truncate Data Set=
|
Removes N rows from either the top=
or bottom of the dataset. |