Creating Groups and Calculated ItemsYou 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
|
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |