Shortcut metrics are a quick way to add new metrics based on the existing metrics of a report.
Rank shortcut metrics apply a ranking number to the metric values for a given attribute. When you create a rank shortcut metric, you can determine break-by options for each attribute on the report. Use the rank function to show the relative position of a given value in relation to other values on a report.
To create a rank shortcut metric:
Run a report in either Grid view or Grid and Graph view.
Right-click the metric column(s) or row(s) to rank.
Select Insert Metric and point to Rank.
Select the break-by value from the list by selecting one of the Break by attribute name options. This determines the business attributes you are ranking.
Select either Ascending or Descending to determine the order in which values are ranked on the report. A new column of metric values is displayed on the report.
Creating a percent-to-total shortcut metric
Creating a transformation shortcut metric
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices