Self-service analysis & shared metrics — found from sitemap — Metabase

Cited by

Facts read from this source

• Metrics definition Report an error

  “Metrics define the official way to calculate important numbers for your team.”

• Metrics components Report an error

  “Metrics have three components: Data source: metrics are associated with a specific data source and can be used in any question built on that data source. Formula: the aggregation’s definition. Dimensions: the fields people can use to break out and filter the metric, including an optional default dimension Metabase uses to display it.”

• Metrics query builder Report an error

  “When you start a question on a data source that has a metric defined, Metabase will show you metrics on that data source in the Summarize block under Metrics.”

• Metrics create methods Report an error

  “Bring up the command palette with cmd/ctrl + k (that’s cmd + k for Macs, or ctrl + k for Windows PCs) and search for New metric”

• Metrics edit propagation Report an error

  “If you edit the metric’s definition, all questions that use the metric will immediately start using the new definition.”

• Metrics explorer Report an error

  “To break metrics out by different dimensions, compare metrics and measures, and do math with metrics (like add or divide metrics by each other), check out the Metrics explorer.”

• Metrics data sources Report an error

  “You can build metrics on tables, saved questions, models, and other metrics.”

• Metrics formula aggregation required Report an error

  “A metric formula must be an aggregation of a column, meaning you can have a formula like Sum([Price]) which will add up all the values in the Price column across all records, but you can’t have a formula like [Price] + [Tax] which adds two values on a per-record basis.”

• Metrics reference other metrics Report an error

  “You can reference other metrics when defining the formula for your metric.”

• Metrics conditional expressions Report an error

  “You can use conditional custom expressions like CountIf, SumIf, and DistinctIf to create conditional aggregations.”

• Metrics dimensions curation Report an error

  “By default, every column from a metric’s source data serves as a dimension. You can curate a metric’s dimensions to choose which fields appear as breakout and filter options. You can also set the default dimension Metabase uses to display the metric.”

• Metrics related table dimensions Report an error

  “If the metric’s source table has foreign keys, the Available dimensions list also includes fields from the related tables.”

• Metrics permissions Report an error

  “permissions for metrics are determined by a combination of collection permissions, “View data” permissions, and “Create queries” permissions.”

• Metrics library Report an error

  “By adding metrics to your Library, the query builder will display the metrics more prominently in menus.”

• Metrics limitations Report an error

  “For now, metrics are associated with a specific data source, and can’t be used on any other data source, including on data sources derived from metric’s original data source.”

• Metrics sql not supported Report an error

  “Metrics are only available to the query builder. For defining reusable bits of SQL, check out Snippets.”

• Metrics verification plan gating Report an error

  “On Pro and Enterprise plans, you can mark metrics as verified.”

• Metric caching plans Report an error

  “Caching results of individual metrics is only available on Pro and Enterprise plans (both self-hosted and on Metabase Cloud).”

• Metrics join not recommended Report an error

  “We don’t recommend using joins in metric definitions. If you need to build a metric that uses information from multiple tables, consider making a transform to join those tables, then create a metric on the table the transform creates.”

Scores citing this record

• The Data Analyst Self-service analysis & shared metrics
• The Finance Controller Self-service analysis & shared metrics
• The IT Administrator Self-service analysis & shared metrics
• The Managing Director Self-service analysis & shared metrics
• The SaaS Product Lead Self-service analysis & shared metrics
• The Skeptic Self-service analysis & shared metrics
• The Skeptic Pricing transparency