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:
| Part | Example |
|---|---|
| Metric | Net revenue, profit after fees |
| Dimension | Channel, product, date |
| Filter | Channel = Shopify |
| Period | Last month, last 28 days |
| Comparison | Versus 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
| Level | Where it comes from | When to trust it |
|---|---|---|
| Standard | A metric from the industry × department pack | Shared definition, tested against expected numbers |
| Approved | Your workspace's own metric (ws.<name>) | Checked against data and activated by an Admin |
| Unconfirmed | An exploratory answer from Si on the approved model | Check 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.
Related
Si: context analysis and Q&A
Si is DataxLand's AI data assistant — it proposes how to read and map your data for you to approve, and answers questions with approved metrics.
Workspace metrics
Define your own workspace metrics (ws.<name>) on the same metric engine, check them against data, activate them and manage versions; review metrics proposed by Si.