Metrics are calculations based on data that aim to answer specific business questions.
You can see and create new metrics by clicking on All Documents in the left sidebar.
Metrics are ordered by the popularity of the measure they are based on. 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 -> + New Metric.
Name your metric.
You can create an empty metric, or search for a measure field which represents the metric.
Note: When you choose a Column 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.
The Metric page will automatically detect dashboards using the value in your Represented As field and order them by popularity.
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.