Metrics

Metrics are calculations based on data that aim to answer specific business questions.

Customize the columns using the icon in the header, or use the keyboard shortcut Cmd/Ctrl+F to open a search filter.

To add a new metric, click + New Doc -> Metric.

Name your metric.

You can create an empty metric, or search for a measure field that represents the metric.

Note: When you choose a Column/Fields to Represent a Metric, this Column will now display with a 'Metric' label:

Then click the 'Metric' label to see everywhere this Column represents a Metric:

Select Star can automatically detect dimensions that you may want to group or pivot on, but you can remove these if desired or search for others.

Save the metric to see new fields where you can provide a Description, Business Questions to Answer, and How it's Calculated as editable fields.

Type @ and then a few characters to create a clickable link to a specific data asset within your calculation or description.

The How it's calculated field is meant to give a high-level overview of the metric to business-oriented stakeholders.

If you have a SQL query which will show a more accurate representation to technical stakeholders, you can add it where you'd modify the Owners by clicking < > SQL.

You'll be able to edit or paste in a SQL query.

Stakeholders can also use the Discussion tab to ask questions or make comments about the metric.

The owners will be notified of any comments. By default, both the Business and Technical Owner of a metric are set to the person who created it. Data Managers and Admins can change the Owners as needed, and even apply Tags to metrics by clicking the 🏷 icon next to the title.