Page tree
Skip to end of metadata
Go to start of metadata

The What pane displays all of your project's metrics that you can use in your report (for details, see Creating New Reports in the Report Editor).

By default, metrics are organized by folder, but you can also use the View by drop-down to organize your metrics by tag.

In some cases, metrics are displayed in two categories:

  • Global Metrics
  • Report Specific Metrics
    Global metrics are available to add to any report within a given project

Editing a report-specific metric within another metric does not propagate all changes and can lead to unexpected behavior. We recommend that you do not use report-specific metrics within other metrics.

Global metrics are available for all of the project's reports, while report-specific metrics can only be used for the current report. The decision to keep a metric report-specific belongs to the metric author, who can always opt to globalize a local metric.

After a metric has been added to the global metrics, it can be edited only through the Manage page.

In the case where a user deletes a global metric that is being used in one or more report, the metric is removed from the list of global metrics but remains as a local metric within the reports in which it already appears.

Metric Details

The details of a selected metric appear in the right-most column. Details include the metric description (determined by the metric author), the MAQL definition that is used to select data relevant to the metric you have selected, and the current metric number format.

The View Detail button at the bottom of the details pane links to the Manage Page, where you can make global changes to the metric – affecting its settings wherever it appears in the project.

Simple Metric Editor - Adding New Metrics

You can create new metrics from the metrics column in the What pane. Click Add New Metric to access the Simple Metric Editor, or click (advanced) to access the Metric Editor dialog and create a metric using MAQL.

Clicking Add New Metric opens the Simple Metric Editor. Clicking (advanced) leads to the Custom Metric Editor

When you create or save a copy of a metric, report, or dashboard, it is unlocked for editing and visible only to you at first. When it is ready to share with other users in the project, you must publish the object.

Clicking Add New Metric in the metrics column opens a Simple Metric Editor in the right-most column of the What pane.

The simple metric editor allows you. to aggregate facts (and attribute values) into new metrics.

Begin by selecting which operation will aggregate data facts to form your new metric:

  • SUM – the sum total of all of a fact's values
  • MAX – the single largest fact value among a fact's set of values
  • MIN – the single smallest fact value among a fact's set of values
  • AVG – the mean of all of a fact's values
  • COUNT – number of unique values of a specified attribute
  • RUNSUM – running (cumulative) sum of report values
  • RUNMIN – running (cumulative) minimum of report values
  • RUNMAX – running (cumulative) maximum of report values
  • RUNAVG – running (cumulative) mean of report values
  • MEDIAN – the middle value of a set of values

Running total operations like RUNSUM, RUNMAX, RUNMIN, and RUNAVG are useful for creating metrics that, when broken down by one or more attributes in a report, display values that represent the cumulative total of the current and all prior metric values in the report. An example of a running sum is shown in the figure below.

Perform operation on: Choose a fact to aggregate.

Add to Global Metrics:  If you’d like your metric to be available for use in other reports within your project, select Add to Global Metrics. Once you select to make a metric global, you can use the dropdown that appears to add the metric to a metric folder of your choice, or create a new metric folder.

Administrators can also reorganize metrics into folders from the Manage Page.

After a metric has been added to the global metrics, it can be edited only through the Manage page.

Add global metrics to a folder so they are easy to locate later.

If you choose to keep your metric local it will only be available for use on the current report. For more information, see Create a Metric.

Once you have added your new metric, the What  button is updated to reflect the total number of metrics in your report.

  • No labels