Create a Simple (Undimensioned) Metric

This introductory article describes how to define the basic settings for creating an Undimensioned Metric from your SQL statement.

PREREQUISITES:

  1. Prepare a SQL Statement: You need an SQL statement that returns a set of measurement times and values for your metric.  See Writing SQL for a simple Metric for more details.
  2. Data source: Metric Insights must have a working data source connection to your data source. If you have not yet configured a data source connection, see Connecting to Data Sources.

1. Access New > Metric

Define the basic Metric information:

  1. Measure of: identify what this Metric should measure (for example, Sales, Visitors, Website Activity, etc.). You can create Measures on-the-go by scrolling to the bottom of the drop-down list and choosing the Add New Measure options. Refer to Create a Measure for more details.
  2. Measured: select the measurement interval that applies to the level of aggregation that you want in your result set.
  3. Select Not Dimensioned
  4. Name: The system automatically generates name based on the values selected in the fields above, however, you can change it to a unique descriptive name of your choice.
  5. Select the Category of a new Metric. Categories are used to group tiles at the Homepage and quickly find required elements.

Next: define details

2. Define Data Collection parameters

  1. Data Source: select the repository which contains your data. For more info on data sources, refer to Understanding Data Sources. We are using a SQL Database for this example.
  2. Data Collection Trigger: select a trigger that will initiate your metric data collection process. To fully configure how data collection should be triggered, see: Automating the Collection of Data
  3. SQL Statement: Enter an SQL using the format explained in the Hint next to the text box. For more details, see: Write a SQL Statement for a Simple (Undimensioned) Metric
  4. Validate: click this button to verify that your SQL statement is valid.

2.1. Optional pop-up for parameter substitution

Optional pop-up for parameter substitution

NOTE: If you have specified  :last_measurement_time in your statement, you will be asked to select the date/time validating your statement.

3. When validation is successfully completed, click 'Collect Data'

  1. If your statement is valid, the statement box is green; if there are any errors, the box is colored in red and errors are explained below the statement box.
  2. The total number of found records and an example of first one are displayed  below the statement box.
  3. To proceed with fetching data, click Collect data
  4. Specify advanced options for collection of data

3.1. Select the beginning date for data collection

Select the beginning date for data collection

4. Enable & publish your Metric

  1. System returns last data collection date
  2. Optionally you can preview your metric
  3. Define whether this Metric should be available at the Homepage and click Enable & publish

5. You will be transferred to Metric Viewer

0 Comments

Add your comment

E-Mail me when someone replies to this comment