Metrics and semantic layer

Metrics and the semantic layer

Every number has one versioned definition; dashboards, Si, reports and MCP read that same definition through the semantic layer, with a Standard, Approved or Unconfirmed confidence level.

One definition for every number

Each metric declares its formula, the dimensions it can be split by (date, channel, product…), its time grain (day, week, month), its unit and its good direction (is up good or bad?). Dashboards, Si, scheduled reports, alerts and MCP all get their numbers from the same metric engine: there is no separate SQL hidden in a dashboard or in one of Si's answers.

The semantic layer

The semantic layer describes which tables join to which, which dimensions can split a number and which filters are valid. A question, a dashboard tile and an MCP call are all the same combination:

PartExample
MetricNet revenue, profit after fees
DimensionChannel, product, date
FilterChannel = Shopify
PeriodLast month, last 28 days
ComparisonVersus previous period

DataxLand builds the query from that combination. You can view and edit the workspace's semantic model under Settings → Data model, Admin and above.

Three confidence levels

LevelWhere it comes fromWhen to trust it
StandardA metric from the industry × department packShared definition, tested against expected numbers
ApprovedYour workspace's own metric (ws.<name>)Checked against data and activated by an Admin
UnconfirmedAn exploratory answer from Si on the approved modelCheck it before using it as an official number

Every number is shown with its confidence label. An Unconfirmed answer you use often can become a workspace metric, see Workspace metrics.

Metric handbook

The Metric handbook page, in the Ask and explore group, has two tabs:

  • Metric library: every metric currently available, searchable with the box "Search metrics (e.g. profit, refunds, ROAS)". Click Edit description to change the display name, description, synonyms and notes for your workspace (the formula stays the same). Edited metrics carry an Edited by workspace label; Restore original puts back the pack version.
  • Workspace metrics: the metrics you define yourself.

Versions

Changing a formula bumps the version. The Sources section of every answer lists the metric, its version, the period and the "data as of" date; the number inspector shows the formula, filters, comparison period and the SQL that ran.

Dates and time zones

Timestamps are stored in UTC; business dates follow the workspace time zone (default Asia/Ho_Chi_Minh, changeable per workspace). Weeks start on Monday. See Time zone, currency and formats.

Markdown