# Metrics

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

Customize the columns using the ![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-4985d930fba0d0d037f5efc60a2c93406c66b353%2Fscreen-shot-2021-08-24-at-10.53.40-am%20\(2\)%20\(1\).png?alt=media\&token=6bc56b4c-f087-4635-8471-1d67e852b718) icon in the header, or use the keyboard shortcut `Cmd/Ctrl+F` to open a search filter.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-8d140f691b10bc7096e4bc1b4f79e131ff29da18%2FScreenshot%202025-02-26%20at%209.39.03%E2%80%AFAM.png?alt=media" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-583f2905f2c7b9b8ceb6f66d8063eaa690da24ea%2FScreenshot%202025-02-26%20at%209.32.50%E2%80%AFAM.png?alt=media" alt="" width="375"><figcaption></figcaption></figure>

{% hint style="info" %}
Note: When you choose a Column/Fields to Represent a Metric, this Column will now display with a 'Metric' label:
{% endhint %}

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-38dadeeac74d35bb83671acd3f271871b075fc80%2FScreenshot%202025-02-26%20at%209.41.57%E2%80%AFAM.png?alt=media" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-b6431faee5962fe817e4fa35d5ce9af8adf98a07%2FScreenshot%202025-02-26%20at%209.43.24%E2%80%AFAM.png?alt=media" alt="" width="563"><figcaption></figcaption></figure>

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.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-789a6f092442a847ceddcb2037bd3d8aa8ed316a%2FScreenshot%202025-02-26%20at%209.34.22%E2%80%AFAM.png?alt=media" alt="" width="375"><figcaption></figcaption></figure>

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.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-d0582cd189d57ca6d892baae885edb2aa4b486c3%2FScreenshot%202025-02-26%20at%209.53.01%E2%80%AFAM.png?alt=media" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Type `@` and then a few characters to create a clickable link to a specific data asset within your calculation or description.
{% endhint %}

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](https://docs.selectstar.com/data-management/data-ownership) by clicking **< > SQL**.

<figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-e7ee5fc39b5b46374c85c4d63080e9b70c6c9098%2FScreenshot%202025-02-26%20at%209.53.52%E2%80%AFAM.png?alt=media" alt=""><figcaption></figcaption></figure>

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

![](https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-a6c57a44e3b6bf0c8be97e8ef10c1e6b03e46fa9%2FScreen%20Shot%202021-08-30%20at%204.14.01%20PM.png?alt=media\&token=3cb317c7-a5ac-4259-809f-b6c42923ea9c)

Stakeholders can also use the [Discussion](https://docs.selectstar.com/features/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](https://docs.selectstar.com/user-management/user-roles) can change the Owners as needed, and even apply [Tags](https://docs.selectstar.com/features/tags) to metrics by clicking the 🏷 icon next to the title.