You can create new metrics (called derived metrics) based on attributes that have already been added to a dashboard. For a more detailed description of derived metrics, see Creating a metric based on existing objects: Derived metrics.
You can create a derived metric from an existing attribute. The existing attribute is not deleted from the dashboard; it is duplicated and changed into a metric. The metric’s definition depends on the definition of the attribute:
If the attribute contains numeric values, the values of the metric are calculated based on the sum of the elements in the attribute.
For example, the Age attribute contains employee age data, as numeric values. You want to calculate the average age of employees in different departments. Create a derived metric from the Age attribute, which will aggregate all the employees’ ages. You can then average the Age metric for each department.
If the attribute does not contain numeric values, the metric is created as a count metric. The derived metric counts the number of attribute elements.
For example, the Region attribute contains text values: Northeast, Midwest, Southwest, and so on, for a total of 12 regions. You need the number of regions, so you create a derived metric from the Region attribute. The derived metric’s value is 12.
A derived metric created from an attribute is created on the dashboard. It is added to the list of dataset objects in the dashboard's Datasets panel, so that you can use the metric in visualizations, text fields, and so on.
You must have Edit Dashboard and Run Dashboard privileges
To create a new metric based on an attribute:
Click the name of the dashboard to run it.
From the Datasets panel, right-click the attribute to use to create the derived metric, then select Duplicate as Metric. The new metric is created and added to the dashboard.
The Duplicate as Metric option is not available for a derived attribute.
Creating a metric based on existing objects: Derived metrics
Editing or deleting derived metrics in a dashboard
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices