View filter effects on derived metrics

For most derived metrics, view filters have the same effects as they do on standard metrics created with the Metric Editor. When data is restricted from view, the derived metric values along with any related data is hidden from the view of the report. For example, if a view filter restricts data to the year 2027, then any derived metrics and standard metrics included on the report only display data for the year 2027.

However, derived metrics created with relative functions (OLAP functions and Rank and Ntile functions) are affected by the evaluation of view filters in a unique way.

A derived metric uses the data available on a report to calculate its values. Since view filter qualifications restrict the data displayed on the report, this can also restrict the data available for derived metrics depending on the evaluation order of the two objects. This restriction of data combined with derived metrics with relative functions that depend on other values on the report can effect the display of report results.

The view filter effects on derived metrics with relative functions depends on how view filters are used in such reports, as described below:

• Using view filters that affect derived metrics with relative functions: Derived metrics with relative functions such as RunningSum or Rank return values that are relative to other values on a report. When data is restricted by view filter qualifications on other objects of a report, you can allow the values of derived metrics with relative functions to calculate their relative values to the new view of report data.

• Using view filters on derived metrics with relative functions: Derived metrics with relative functions such as RunningSum or Rank return values that are relative to the data on a report. When data is restricted by view filter qualifications on derived metrics with relative functions, you can allow the relative values to reflect the new view of data or retain the relative values for all report data.

For information on the view filter effects on these types of derived metrics, see the In-memory Analytics Help.

Related Topics

• Best practices for creating derived metrics

• Creating derived metrics

• Example: Average profit per customer with transactions

• Using rank and percent-to-total metric analysis

• Editing derived metrics

• Formatting derived metrics

• Deleting derived metrics

• Derived element effects on derived metrics