| Print Open PDF Version of Online Help

#### Creating Groups and Calculated Items You can create new column values using groups and calculated items. A group in Analytics is a static list of column values that you select, or a static or dynamic list that is generated by selection steps. A group is represented as a column value. All of the values that make up the group must be from the same column. Groups are always displayed at the bottom of the column list in the order in which they were added. Groups can contain column values or other groups. You can create a custom group and add the custom group to a column within a view. A calculated item is a calculation between column values that is represented as a single value. You can use a calculated item to override the default aggregation rule that is specified in the repository, and for an existing analysis, the aggregation rule chosen by the creator of the analysis. You can define a calculated item using a custom formula, which is the default method, or by combining selected column values with a function, for example, SUM. When you create a group or a calculated item, a selection step is automatically created. For more information about selection steps, see Creating Selection Steps. You can save the groups and calculated items that you create in the relevant subject area folder in the catalog, so that they can be reused. The following procedure describes how to create a group or calculated item from a view editor. To create a group or calculated item In the Results tab of the analysis editor, click the Edit View icon for the view for which you want to create a group or calculated item. In the view editor, click the New Group or New Calculated Item icon in the toolbar. NOTE: You can also create a group or calculated item from the Selection Steps pane. For more information, see Creating Selection Steps. In the New Group or New Calculated Item dialog box, specify the details for the group or calculated item. Click OK to close the dialog box. Click Done to return to the compound layout. If you want to save the group or calculated item in the catalog, then do the following: In the Selection Steps pane, click the link for the item that you want to save. Select the save option for the item. In the Save As dialog box, browse to the folder where you want to save the item. Click OK to close the dialog box.

Published 5/23/2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.