...
Average
Calculates the arithmetic average of the specified field for each customer. For customer 234, the Average of Amount = $42.40. This function is only available for numeric fields from your tables.
List
Returns the list of unique values for each row that matches the criteria of a specified field. For customer 234, the List of Product Number = CC010;CD040.
...
To Create a New Aggregate
After selecting a table, the Table Type prompt will appear to select what type of table you are choosing. You will have four options:
- One Row - This will list the table as a customer table and you will not be able to create aggregates with this option selected.
- More Than One Row - This will list the table as a transactional table and you will have the option of creating aggregates.
- I'm not sure, figure it out for me - based upon the selected table, the system will automatically choose what table type it believes to be the best option and it will set the table type for you.
- Cancel - It will exit out of the Table Type prompt and there will be no changes.
- Drag the New Aggregate item and drop it into the Criteria tree, where the Aggregate Function window will open.
- In the Aggregate section, you will select what Function and Object to be used.
- In the Group section, you will have three options to choose from:
- All Orders - The aggregate is put into an unfiltered, default group.
- New - Allows you to customize the Group name and add a Group filter.
- Select - Allows you to choose a group that already exists to place the aggregate in from the drop-down list.
- If you select New, click the Add Filter button (
). - In the New Group Filter section, drag and drop the field(s) into the criteria panel.
- Choose the appropriate condition(s) and value(s).
- Enter in your name for the filter and press OK to go back to the Aggregate Function window.
- In the Name section, you can either enter a name for the new aggregate or use the default name given.
- Click OK to save changes.
...