Skip to content

Metrics · · 1 min read

Tracing a metric back to its source data

Trace a Snowfire metric back to the systems and fields that feed it: its sources, the SQL behind it, and metric links in the chain of thought.

What it’s for

Every Snowfire metric records where its number comes from, so you can trace it back to the systems that feed it.

Before you start

Open the metric from Metrics, or from a metric link in Chat. Editing SQL is part of the Admin role.

Steps

Trace it on the metric

  1. Open the metric. Overview shows the description and the formula.
  2. Open Details to see the source system and the data source range.
  3. Choose View SQL to see the query behind the number, and rerun it.
  4. Choose Download data to export the data behind the chart.
  5. Open History to see how the metric changed.
Metric page for Annual Recurring Revenue with its description, formula, chart and details
A metric: overview, chart and details.

Trace it from Chat

  1. Open Sources & Chain of Thought under the answer. Sources lists the tables, fields and filters the answer used.
  2. Open the chain of thought on the answer. It links to the metrics it used.
  3. Click a metric chip in the answer to open the metric.
Sources & Chain of Thought box opened on an answer, listing the tables, fields and filters applied
Sources: the tables, fields and filters behind an answer.

Check and fix

A traced number names its source system, its query, and the tables, fields and filters behind it.

ProblemFix
History reads No recorded events.No changes have been recorded for the metric yet.
History shows Query failed.Open View SQL, fix the query and use Validate.

Related articles

Can't Find What You Need?

Our support team is here to help. Get in touch and we'll respond within 24 hours.

Contact Support