Help & DocumentationCreating ContentDatasetsCreating Elements from DatasetsCreate a Metric from a Dataset View (prior to 5.1 release)

Create a Metric from a Dataset View (prior to 5.1 release)

Datasets offer a quick and highly automated way of building new Metrics. This article describes step-by-step process of creating a Metric out of the specific Dataset View.

Since Metrics always represent time series data, in order to create a Metric your Dataset View must contain a column with dates and a column containing values.

PREREQUISITES:

Newer releases have a simplified method of creating metrics from a Dataset. See  Create one or multiple Metrics from a Dataset View (Version 5.1x)

1. Open a Public Dataset View

Open a Public Dataset View
  1. Open the Dataset View that is to be the data source of the Metric.
  2. Make sure that your View includes a columns with dates and values
  3. At the top right corner of the screen, open the Actions menu
  4. Select the Build Metric option.
    1. If this Dataset View is Private, the system will offer to automatically make it Public and accessible to other users
    2. If at least one element (Report or Metric) has been built from this View, it can no longer be designated as private

You are redirected to the Metric Editor.

2. [Info tab] Define the basics

[Info tab] Define the basics
  1. Name: is populated automatically with the name of the Dataset View. You can change it to a unique and descriptive name of your choice.
  2. Optional settings:
    • Category: helps organizing tiles at the Homepage. You can grant access to elements through Categories.or more details refer to: Create a Category
    • Certified:  this setting serves to identify elements that have been approved as being valid and accurate. For more details refer to: Certifying an Element
    • Topics/Tags: relate elements to each other. For more details refer to: Create a Topic

3. [Data tab] Check Data Collection Configuration

[Data tab] Check Data Collection Configuration

All the fields that define the Data Collection process are populated automatically based on the selection made in Dataset View.

  1. Data Source: in this example a Dataset is the selected Data Source
  2. Data Collection Trigger: Set the Trigger to initiate updating information in the Metric
  3. Dataset & View: Select the combination of a Dataset and its View from the drop-down list
  4. Date / Value column: make sure that date and value columns display the expected data
  5. Include: specify whether you want to fetch all data, or rows after a certain date

3.1. Check for available data

Check for available data
  1. Click Check for data to see what records are available for collecting
  2. The number of available records  and an example of a first one is displayed in the results shown below
  3. Click Collect data to fetch rows for the Metric.

Enable and Publish the Metric.

Result

Result