Skip to main content
Click any metric card to open its detail sheet. This is where a metric is run, scheduled, visualized, and retired. Opening a metric from the project’s Metrics page puts its ID in the URL, so you can share a link to it.

The Detail Sheet

From top to bottom:
  • State and visibility - The state pill (Active, Paused, Error, Draft) and the Shared/Private toggle
  • Name and description - Click the name to rename it inline
  • Add to catalog - Promotes the metric to the Metrics Catalog, so other projects can use the same definition
  • Run Now - Executes the metric immediately. Most runs finish within a minute. Slow ones keep running in the background
  • Current Value - The latest result, rendered per the metric’s visualization
  • Schedule - When the metric refreshes automatically
  • Historical Results - Up to 20 recent runs, expandable for table results
  • Used by - What reads the metric, shown when anything does, so the effect of a delete is visible before one is attempted
  • Query & Code - The sources and transformation behind the value
  • Delete - Removes the metric and its entire run history
The detail sheet for Denholm: Dark Org Units, outlined in red, over the Metrics page. From the top: state and visibility pills, name, Add to catalog, Run Now, Current Value, Schedule, Historical Results, Query & Code, and Delete Metric

A metric's detail sheet

Viewers see a reduced sheet: the current value and history, without the run, schedule, code, or delete controls. A metric linked to the Metrics Catalog takes its definition from the catalog. Its sheet has no rename, visibility, chart-saving, Add to catalog, or Delete controls. Select Edit it there to open the metric in the catalog.

Visualizing results

Numbers, percentages, and currency render as a large formatted value. Field sets render as tiles, with a layout editor for choosing fields, labels, and formats. Table results can offer these tabs:
  • Table: inspect the result’s rows
  • Chart: view a saved chart or a chart you are previewing
  • Profile: inspect column summaries, such as ranges, common values, and missing values, when a profile is available

Adding or changing a chart

When Add chart appears in the detail sheet:
  1. Select Add chart
  2. Choose one of the suggested chart types to preview it
  3. If Save as this metric’s chart appears, select it to use the chart on future runs. Cancel leaves the saved chart unchanged
Saving requires edit access. Catalog-linked metrics do not offer chart-saving controls in the project sheet. A saved chart can offer these controls:
  • Edit chart: open the chart editor, when supported
  • Change chart: preview another suggested chart, then save your choice
  • Remove chart: remove the saved chart without deleting the table result
Some older results use a chart-type toolbar with axis selectors and Save Visualization. Where Download table as CSV is available, it exports that result’s stored rows. For other changes, ask Orion in chat. For example, ask for different colors, titles, decimal places, prefixes, suffixes, or a threshold line at your SLA limit.

Scheduling

The Schedule section offers None, Hourly, Daily, Weekly, Monthly, and At times:
  • Hourly - Every 1, 2, 3, 4, 6, 8, or 12 hours, on the quarter hour you pick
  • Daily - Choose days of the week, including presets for every day, weekdays, or weekends
  • Monthly - A day of the month, 1st through 28th
  • At times - Up to five specific times per day
Times are shown in your local timezone and converted automatically. The next scheduled run shows at the top of the section.

When a data source is disabled

A Disabled pill on the schedule means a data source the metric uses is disabled. The schedule restarts once the source is enabled again. See Disabling a Data Source.

Run history

Historical Results lists recent runs with their values. Failed runs carry an error icon, and table results expand inline. Select enters a selection mode for deleting runs that are no longer needed.
Deleting run history is permanent, and so is deleting the metric itself.

Running catalog metrics

A catalog metric can reach a project as a Shared value or a Project copy. A Shared value uses the catalog’s run and result. It has no Run Now action in the project sheet. To run it:
  1. Select Edit it there to open the metric in the catalog
  2. Open its … actions menu and select Run now, if you have permission to manage the catalog metric
A Project copy has its own runs and results. Project members with edit access can still use Run Now in its project sheet.

Query & Code

The Query & Code section shows each data source with its variable name. SQL sources render with syntax highlighting, a plain-language summary of what the query does, and a diagram of how data flows through it. Looker sources show the query structure and link back to Looker. Sources and transformation code are read-only here. To change them, ask Orion in chat:
  • “Update the metric to exclude internal accounts”
  • “Fix this metric” (after a failed run, Orion repairs the code)
  • “Change the metric’s schedule to weekdays at 7am”
Orion dry-runs every change against real data before saving it.

Previews and Full Results

Large results open as a preview. Select Load full table to see more rows, up to 100,000. A view shows a preview and a summary of each column. To work with all of its rows, select Open in chat and tell Orion what to calculate. A stored as view badge means the result was too large for a table, so Orion saved it as a view.

Metrics in chat

  • @-mention a metric in any chat to bring it into the conversation
  • Ask “how is this metric calculated?” for its lineage: sources, transformation, and how data flows between them
  • Ask Orion to load a metric’s history into an analysis to chart it over time or build it into a deliverable
When Orion discusses a metric, it renders the live metric card in the chat. Click the card to open the full detail sheet. A metric whose result is a table or a view shows as a single row instead, whether the turn returns one result or several. Click the row to open the result in place, and select Collapse to return it to a row. A metric whose result is a single number keeps its card. A turn with several results groups them into one pane instead of a stack of cards. Open the pane to reach each result. To calculate over a saved table or view, ask Orion to load it into a notebook. See Save and Reuse a View.

Deleting a metric

Delete removes the metric and all of its run history, permanently. If a Workflow or notebook references the metric, deletion is blocked and Orion lists the dependents, so a scheduled Workflow cannot break silently. See Metrics as a source for how Workflows consume metrics.

Permissions

These permissions apply to metrics you can access. A private project metric is available to its creator and Tenant Admins. Project owners and Group Admins cannot open another member’s private metric through their project role alone.
  • Viewers: read shared metrics and browse their history
  • Analysts: run, rename, schedule, visualize, and delete accessible metrics. Sharing to the board is limited to metrics they created
  • Project owners: can also change visibility on metrics they can access
  • Tenant Admins: can also access private project metrics created by others and change their visibility
Catalog metrics follow the catalog’s access rules.