Metric Editor (Data, Stoplights, Alerting, Charting, Associations)
Settings availablr in the Metric Editor:
- Where is the data from? How often data is updated? - Data tab
- Are there any expectations for collected Values? Are higher or lower Values better? - Stoplights tab
- What Alert Rules are aplied to this Metric? Is there a History of Alerts sent from this Metric? - Alerting tab
- How the Chart and the Values on it should look? - Charting tab
- How is this Metric connected with other ones? Can I connect them for forther analysis? - Associations tab
For step-by-step instructions on creating a Metric, refer to one of the following articles depending on your Use Case:
- Create a Simple (Undimensioned) Metric
- Create a Simple Dimension + Dimensioned Metric (with a separate chart per each Dimension Value)
For creating Metrics and Reports sourced from the suppoted plugins, refer here:
- For Tableau-related resources: Tableau and Metric Insights - all you need to know
- For Qlik Sense, Qlik View, Sisense, Microstrategy and other Plugins: Connecting To Data Sources
via the Metric Preview / Viewer
via Content > Elements
- Access Content > Elements. The lyst of all types of elements available in Metric Insights is going to be opened.
- Filter the elements by keywords and other available paraemetrs.
- Find the element in the refind list and click its name. You are going to be redirected right to the editor.
- Measured: Select a Measurement Interval applied to this Metric. The chosen Measurement Interval instanltly applies a set of adjustments to the Metric's behaviour, Alert parameters, default naming conventions, Charting Intervals and Labels. These predefined settings are modifiable, for details refer to: Update Measurement Interval Settings
- Dimension it by: A dimensioned Metric includes a separate tile and Chart for each Dimension Value for which data has been collected. You can create a Dimension with either autmatically or manually collected Values on the go by clicking the Plus button or at Content > Dimensions. For details refer to: Creating Dimensions
- Collecting is: This setting defines whether this Metric is "active" and whether it is going to be updated upon a schedule set up in a Data > Data Collection Trigger.
- Make visible on Homepage: Define whether this Metric should be accessible via a tile on a Homepage or only at Content > Elements or via other element's Associations.
- Category: Category Membership is used to group elements in order to organize system content, enhance the process of giving acces to Users / Groups. A new Category can be created on the go by clicking the Plus button or at Content > Categories. For details refer to: Create a Category
- 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
This page is dynamic and it is going to have a different set of options depending on the selected Data Source.
The given example is for the Metric buit from a configurable Data Source (Plugin - Tableau).
- Data Source: Define the source of fetching data for this element. For details refer to: Understanding Data Sources
- Data Collection Trigger: Specify how often the data for this Metric should be recollected. A new Trigger can be created on the go by clicking the Plus button or at Admin > Data Collection Triggers. For details refer to: Create a Data Collection Trigger (Scheduled / Externally Triggered)
- Tableau Worksheet (This field is specific to the selected Plugin Data Source): When a Metric is sourced from a Plugin, this field is named with respect to how elements are called in a source system. The given example is for a Tableau and elements in Tableau are called "Worksheets"; for other systems this can be called a "Report", an "Object", etc. The main function of this field is to map Metric Insights to a specific element in the source system, so this is a so-called "path" for the systems with multi-level hierarchy.
- Filters (applicable for Tableau, Qlik, Sisense Data Sources only): are used to pre-filter data before sourcing it from the source limit. This functionality allows focusing on the exact slice of data that is required for analysis and exclude the data that is irrelevant for you and your research. For details refer to:
- Command (is applicable for configurable Data Sources: SQL or Plugin): Data for Metrics is extracted via a plugin command, consisting of parameters specifying what data should be fetched. The command can be entered manually or via the Visual Editor (if a plugin supports it).
- Values are additive across time periods: field will be set to 'yes' if, for example, the daily values can be aggregated to create weekly and monthly values.
- Omit current <Measurement Interval> from Chart: This setting depends on the Measuremnet Interval chosen for this Metric (day / month / year). If you set this fied to 'yes', current day / month/ year etc. is not going to be displayed on the Chart.
- Insert 0 for missing values: if this setting is enabled and upon data collection no data is found in the source, then missing data is replaced with a zero and a timestamp.
Setting up the options in this tab activates the Statistical View in the Metric Viewer.
A Stoplight is a visual indicator of how well a Metric is doing. A Metric can have a underperforming, performing, or outperforming depending on the conditions specifieed in this tab. The result is denoted by different background shading in the various Metric views over time. Stoplight bands are shown even if Metric is represented as a single data point.
For details refer to: Define a Metric's Stoplight.
- Alert History: Review all Alerts that have been generated for this Metric, who are subscribed to them, their preferred delivery method and whether the alert notification was delivered to them.
- Alert Rules associated with this Metric: This section lists all the Alert Rules (KPI and Global) assigned to this Metric. To add a new KPI Alert Rule, click [+ New KPI Alert Rule] button and create one on the go. Reference articles:
- Alert Rules Sending this Metric: This setting allows associating Alert Rules with this Metric, meaning, when the selected Alert is generated, the image from this Metric's Chart is going to be applied to a notification.
- This set of options helps to determine how the Metric's chart is supposed to look.
- Set Statistical view to _ stangdard deviation / Include a moving average of: The Moving Average and Standard Deviation always are calculated using trailing; i.e., historical) data. The period that is used for the calculation is determined in this field. We shift the Standard Deviation calculation back by one day so that sudden fluctuations can be compared against a stable historical data set. This is to avoid comparing a big fluctuation against a data set that includes the big fluctuation itself. Сurrent data point is excluded from the moving average calculation. EXAMPLE: The Moving Average for the data point on 8/1 would be based on the 30 days from 7/3 to 8/1, inclusive. The Moving Average for 8/1 would be based on the 30 days from 7/2 to 7/31, inclusive.
- Show summary: Define whether the statistics summary information should be displayed in the Metric Viewer.
Settings in this section influence the Value display on the Element's Tile on a Homepage:
- Override Display Mask: Metric's default Display Mask is defined at Metric Viewer > Overlay Metric (a button under the Chart) > Display Mask of Left Axis. To change the value display mask for Metric's tile only, choose another mask in this field.
- Units: type in the text that should be displayed above the element's current value.
- Show percent change from: Choose the period for calculating percent change.
Linking a Metric to an enabled Target activates the Target View in the Metric Viewer.
Targets allow analysis of performance related to organizational goals, such as a forecast or budget. For details refer to: Targets Overview.
Seting the Project future values field to 'yes', Setting up the options in this tab activates the Projection View in the Metric Viewer.
- Associations: Select Metrics to be included in the Measurement Interval drop box in the Viewer.
- Aggregate Metrics: you can create new aggregate Metrics for other intervals in a couple of clicks: Create Multiple Aggregates from a Single Metric
- Detail Reports / Further Amalysis: Reports added here are going to serve as Drill Path for more detailed analysis of a situation: Establish a Drill-Path from a Metric to another Element (Metric Associations)
Ownership & Access
- Business owner: Making either a Regular or a Power User the Business Owner of any Element provides NO View Access to the element or access to its Dimension/Values (if any).
- Technical owner: Power User designated as the Technical Owner receives Edit Access to the element. Regular User can not be a Technical Owner.
- This Metric is public / internal: If this Metric is "internal", it cannot be shared with users who have no account in Metric Insights. For details refer to: Sharing elements with users not registered in Metric Insights.
- Email URL override: When a user clicks on the metric link in a digest, he can be redirected to the external portal/application. Provide a link to the page where a user should be redirected in this field.
- Attach file to Digest: If you choose to attach this Metric's chart and info, define a file format from the drop-down list.
- Embed codes: Metroic Chart can be embedded into other web pages. For details refer to: Embedding Overview