Version 2021

Setting the metric join type at the metric level

The join type selected for a metric determines the way in which data from joined columns is to be displayed. Setting the join here, at the metric level, determines how the metric is joined to other metrics. This setting affects the results for all reports using the metric. However, you can override this metric join setting for a particular report. For a description of the report-level metric join type, including examples and a reference on when to use an inner join vs. an outer join, and a procedure, see Setting the metric join type at the report level.

For a compound metric, you can set the join type at the formula level. For a description of how the different levels work together, see Setting join types for metrics.


This procedure assumes you have created a metric. For instructions, see Creating metrics.

To set the metric join type at the metric level

  1. Open the Metric Editor. (How?)

  2. From the Tools menu, choose Metric Join Type. The Metric Join Type dialog box opens.

  3. Select the join type to use from the following options:

    • Inner includes only the information common to all the elements of the metric.

    • Outer includes all the information from all the elements of the metric.

    • Default Settings level uses the default inherited value, which is an inner join.

  4. Click OK. You are returned to the Metric Editor.

  5. Click Save and Close to save the metric and close the Metric Editor.