Other Metric Set Tools

This applies to: Managed Dashboards, Managed Reports

Metric sets include many more tools to help with your analysis, which are detailed in separate articles.

In the toolbar, you can find:

• States for calling attention to some data, or displaying it differently based on conditions.
• Period over period or slicer comparisons for viewing data from different time periods or filter values, or using it for state conditions or formulas.
• Formulas for adding a new measure or an entirely new metric set based on a formula or script.
• Contextual measures for inputting values to compare against your data, such as goals or targets.

The context menu provides you with additional options when you right-click or long-tap data:

• Group members: for grouping together the items of your choice into a single item.
• Measure corrections/data annotations: for correcting or updating data for public viewing, or for what-if scenarios for your own analysis.

The metric set has overall settings you can access by clicking the Edit icon in the Data Analysis Panel.

• Transpose Result: A transposed metric set swaps the rows with the columns in the result, including displaying a different measure in each row instead of a separate column for each measure. This can be used to display a single column or chart series comparing different measure values, whereas each measure is normally a separate column or series.
  
  
  

• Top/Bottom Items and Other Group: you can filter the metric to display only the top or bottom 'N' items of some number, or group together the smallest items into a single item (or use other criteria).

See also:

• Video: Introduction to Metric Set Designer
• Video: Using The Data Analysis Panel
• Video: Configuring Metric Sets
• Walkthrough: Create a metric set and add a filter
• Add a count measure to a metric set
• Create a time dimension
• Automatic joins and hierarchies
• Sorting a table visualization