Understanding the Metric editor and components

The Metric editor features some familiar sections such as the Object Browser. It has two tabs, one named Formula and one Subtotals / Aggregation as shown in the next screenshot:

Displaying the two tabs, Formula and Subtotals/Aggregation

In the Formula tab, the developer will define the Metric. If the Metric is created using a Fact, it is a simple Metric. The Metric editor will display four components:

  • Formula: This is the f function and the Fact (it can also be an Attribute but with an f function that could be applied to a string, such as count).
  • Level (dimensionality): By default the Metric will aggregate at the Report level. This behavior can be modified in this section so that the Metric can be calculated at a higher or different level. This is particularly useful when creating percentage contribution Metrics. To change the dimensionality of a Metric, browse to locate the Attribute(s) into which the Metric will be aggregated.
  • Condition: To add a Filter to a Metric, use this section. The Filter condition can be added either to the one in the Report definition or treated separately; this is controlled in the condition section of the Metric.
  • Transformation: In this section, a Transformation is added to a Metric so that it calculates at the time Attribute defined in it.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.220.120.161