Creating measures

You can create measures when viewing, editing, or creating a report.

You can create the following types of measures:

  • Rule-based measure (the default): define filtering rules based on the selected parameter, an operator, parameter values, and scope.
  • Calculated measure: Derived by performing a math operation with two or more measures, such as views per session. Define a calculation using previously-defined measures, numbers, and arithmetic operations (/, *, +, -).

To create a measure and add it to a report:

  1. Place your cursor in the report table header and a plus icon is displayed in between each measure.
    Image of a report highlighting the plus icon between each measure
  2. Click the plus icon to open the measures dialog.

    Image of the measure select menu with the Create Measure button highlighted

  3. Click Create Measure. The New Measure dialog is displayed.

    Image of the New Measure dialog box with Calculated Measure not enabled.

  4. If you want to create a calculated measure, click Calculated Measure and then select a combination of existing measures, a mathematical operation, a number, and a display option.
  5. To create a rule-based measure, select parameters from the left and drag them onto the canvas on the right and then select a combination of operators, scope, and additional parameters to create one or more expressions.
  6. In the Display section, select values depending on whether you want to:
    • Display a count of events, sessions, or users.
    • Display the distinct count of values for a parameter.
    • Display the sum of values of a set of parameters that have a numerical data type, and select a format, such as decimal or integer.
  7. In the Measure Name box, enter a name for the measure that is unique within the current account.
  8. In the Description box, enter a description so that others can quickly understand the intent of your measure.
  9. Click Save. The measure is now available to be added to reports.

Related

Measures

Adding measures

Deleting measures from Oracle Infinity

creating measures, scope filter, calculated measures, rule-based measures