Create Metric from Dataset View
Admins and Power Users have an ability to create one or multiple metrics from a Dataset View. This way the User can minimize the number of data entry fields that are usually required to create a Metric. This article describes how to create a Metric from Dataset View.
NOTE: Since Metrics always represent time series data, the source Dataset View must contain a date column and a column with values.
For prior Versions refer to Create a Metric from a Dataset View (prior to 5.1 release).
1. Open a Public Dataset View
- Open the Dataset View to be used as the Data Source of the Metric
- Ensure that the selected View has a date column and a column containing values. If your Dataset is a snapshot, the Snapshot date may serve as a date column. Refer to: Snapshot Datasets: Comparing Instances
- At the top right corner of the page, open the Actions menu
- Select the Build Metric option.
- If this Dataset View is Private, the system will automatically make it accessible to other users (Public)
- If at least one element (Report or Metric) has already been built from this View, it cannot be changed to private.
2. Define the Basic Settings
Define the basic settings for the Metric being created. This is accomplished by choosing the correct column name from the respective drop-down list. The list for each field is populated based on its Column Type; for example, the Date column drop-down list will only contain options representing date values. Since the Results table is always visible below, you see exactly what you are including in the Metric.
- Measurement Interval: Select the Measurement Interval that applies to the level of aggregation that you want in your result set
- Value column: Select the name of a numeric field containing values
- Date column: This may be either a date column from the Dataset or the Snapshot date, if applicable
- Name: Is populated automatically based on the selection made in the fields above, but you can change it to a unique and descriptive name of your choice
Dimension using this column: Optional. For creating dimensioned Metrics only. Dataset's text columns may serve to dimension the Metric, meaning creating a separate Chart per each Dimension Value. With a column used in this example (Country), separate Charts are created for each Dimension Value; e.g., France, Australia, Germany. This allows different sets of Alert Rules to be applied to each Chart and specific security Permissions to be granted to individual Users subscribed to the Alert.
- Map to Dimension in Metric Insights: If you already have a Dimension with values matching to those in the selected Dataset column, you can choose it from the drop-down list; otherwise, you can create one on the fly by clicking: "None - create new Dimension".
Click [Add Metric] to save these settings and preview the resulting Metric.
Settings such as Data Source (the method used to fetch the data) and Data Collection Trigger (how often this Metric is updated), and Category, are automatically inherited from the source Dataset.
3. Build Additional Metrics
- Each time you click Add Metric, the # Metrics defined displayed in the middle of the screen is incremented
Be aware, that these Metrics are just prepared, they are not built yet.
- Change the settings in the Add Metric section to build another element
- Preview any of the prepared Metrics by clicking the name of the Metric that is currently shown bolded in the Preview
- When ready to publish all Metrics, click [Build All Metrics].
The Metrics that have been built are available on the Homepage.