Executes a predefined function and returns an aggregate for a set of values based on the function values.
Note: You can access aggregate functions through calculated categories, calculated measures and dimension calculations. You cannot access them through calculated columns.
| Aggregate | Description |
Converts numbers to their unsigned value. | |
Returns the average value. | |
Returns the difference over a linear series of categories by calculating the change between each pair of categories. | |
Returns the maximum value of selected data items. | |
Returns the minimum value of selected data items. | |
Returns the percent of the total value for selected data items. | |
| Percent-growth | Returns the growth over a linear series of categories by calculating the percentage change between each pair of categories. |
Returns the values of categories as a percent share of other target categories. |
Converts numbers to their unsigned value.
Use when you need positive numbers, or when you need to find the absolute difference between values in a list of positive and negative values.
absolute (numeric_exp)
absolute (-5.3)
Returns the result: 5.3
absolute (2)
Returns the result: 2
Returns the average value of selected data items.
Transformer supports the Average function with numeric data; the only parameters accepted are the numeric expressions and the auto component.
average (<numeric_exp)
average (Sales)
Returns the result: The average of all Sales values.
Returns the difference over a linear series of categories by calculating the change between each pair of categories. The order of pairs is based on the object ID of each category.
Note: This function is used for automatically generated relative time categories, such as year-to-date (YTD Change). It appears in the list of Available Components when you use the expression editor to create a calculated category.
Tip: To use ToolTip on the pop-up diagram to show the labels and object IDs of categories, select the Object Identifier check box in the Preferences properly sheet, (Titles tab).
change (cat_code, cat_code|set|level)
A dimension contains a level with Quarters Q1 to Q4. To create change categories for Q1-Q2, Q2-Q3, and Q3-Q4, use the function
change ("Quarter")Returns the maximum value of selected data items.
max (numeric_exp)
max (Sales)
Returns the maximum value of all Sales values.
Returns the minimum value of selected data items.
min (numeric_exp)
min (Sales)
Returns the minimum value of all Sales values.
Returns the percent of the total value for the selected data items.
Users can format the percentage data so that it reads as a ratio (for example: .25 vs. 25%).
percent (numeric_exp)
percent (sales 07)
Returns the percentage of the total sales for 2007 that is attributed to each sales representative.
Sales Rep | Sales 07 | Percentage |
Bill Gibbons | 60646 | 7.11% |
Bjorn Flertjan | 62523 | 7.35% |
Chris Cornel | 22396 | 2.63% |
Conrad Bergsteige | 13500 | 1.59% |
Returns the growth over a linear series of categories by calculating the percentage change between each pair of categories. The order of pairs is based on the object ID of each category.
Note: This function appears in the list of Available Components when you use the expression editor to create a calculated category.
Tip: To use ToolTip on the pop-up diagram to show the labels and object IDs of categories, select the Object Identifier check box in the Preferences properly sheet (Titles tab).
percent-growth (cat_code, cat_code|set|level)
A dimension contains a level with Quarters Q1 to Q4. To create growth categories for Q1-Q2, Q2-Q3, and Q3-Q4, use the function
percent-growth (Quarter)
Returns the values of categories as a percent share of other target categories.
share (cat_code,cat_code|set|cat_code, set|set|level)
A dimension contains the category Color with several descendant categories, such as Black and Chrome, which you define as a set. To create two share categories, representing each of Black and Chrome, as a percentage of share of the parent, use the function
share (set, Color)