Create a Dimensioned Metric
This article outlines the process of creating a Dimensioned Metric. Dimensioned Metrics should be used when you want to show a given Measure charted over time with a Dimension drop-down list. In this example, you'll see the process of building a Dimensioned Monthly Metric that measures sales by Sales Channel. This example uses the Metric Editor (rather than the Wizard) to build the new metric in order to have access to advanced options.
- Define your Dimension. For more information on creating and collecting data for a Dimension, see Create a Simple Dimension
- Construct a data fetch command that will return a data set with three columns:
- The Dimension Key Value
- The Measurement date/time
- A measurement value corresponding to the specific Dimension Value and Measurement date/time
1. Access New > Metric
Define the basic Metric information:
- Measured: select the measurement interval that applies to the level of aggregation that you want in your result set
- Since we are creating a dimensioned Metric select Dimension it by from the drop-down list below. Refer to Create a Simple Dimension for more details.
- 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
- Select the Category of a new Metric. Categories are used to group tiles at the Homepage and quickly find required elements.
- Next: define details to open Full Editor
1.1. Optionally, update additional fields
- [6.1.0] As of Release 6.1.0, it is possible to flag elements and then Migrate Content using our Export/Import Migration Scripts. Click for details: Scripted Migration via Category and Element Editors
- The Description field defaults from the Name, but if this is not sufficiently descriptive, you may change it
- Certified: Certification is a means for Admin and Power Users to identify elements that have been approved as being valid and accurate. For details refer to: Certifying an Element
- Tags (are referred to as Topics in Versions prior to 5.1): Tags / Topics are used to relate elements to each other for purposes of identifying similar Charts when the See Related drop-down list in the Metric Viewer is populated allowing a more in-depth analysis of trends. For details refer to: Create a Topic / Tag
Next: Access the Metrics to Chart tab
2. Define Data Collection parameters
- 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.
- 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
- 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 Dimensioned Metric
- Validate: click this button to verify that your SQL statement is valid.
2.1. Enter Last Measurement Time Value for Validation
NOTE: This pop-up only appears if you included ':last_measurement_time' in the SQL Statement field.
3. When validation is successfully completed, click 'Collect Data'
- 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.
- The total number of found records and an example of first one are displayed below the statement box.
- To proceed with fetching data, click Collect data
- Specify advanced options for collection of data
3.1. Select how far back to collect the data
4. Enable & publish your Metric
- System returns last data collection date
- Optionally you can preview your metric
- Define whether this Metric should be available at the Homepage and click Enable & publish
The Metric Chart is generated and you are redirected to the Viewer