metric-semantic-layer
Define a metric in a semantic layer so it means one thing everywhere. Use when asked to define a metric, build a semantic layer / metrics layer entry, stop 'revenue means three things' problems, or write a metric definition for dbt MetricFlow / Cube / LookML. Produces a metric definition — exact formula, the base measure & aggregation, dimensions, filters, grain, edge cases, and a tool-ready spec.
npx skills add mohitagw15856/pm-claude-skills --skill metric-semantic-layer --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Metric Semantic Layer Skill "Active users" means three different things in three dashboards — that's the problem a semantic layer solves: define each metric **once**, precisely, and every tool reads the same definition. This skill writes that definition — the exact formula, base measure, allowed dimensions, default filters, and the edge cases that usually cause drift — in a tool-ready form (dbt MetricFlow / Cube / LookML). ## Required Inputs Ask for these only if they aren't already provided: - **The metric** — its name and the business question it answers. - **The base data** — the model/table and the column(s) it's computed from. - **The aggregation** — sum, count, count distinct, average, ratio. - **Dimensions & filters** — how it can be sliced, and any default filters (exclude test accounts, internal users, refunds). - **Tool** — dbt MetricFlow, Cube, LookML, or tool-agnostic. ## Output Format ### Metric: `[metric_name]` **1. Definition (plain English)** — one sentence a non-analyst understands, and the precise version ("count of distinct user_ids with ≥1 qualifying event in the period, excluding internal/test accounts"). **2. Formula** — the exact calculation: base measure ·
- Required Inputs
- Output Format
- Metric: [metricname]
- Quality Checks
- Anti-Patterns
- Based On
What does the metric-semantic-layer skill do?
Define a metric in a semantic layer so it means one thing everywhere. Use when asked to define a metric, build a semantic layer / metrics layer entry, stop 'revenue means three things' problems, or write a metric definition for dbt MetricFlow / Cube / LookML. Produces a metric definition — exact formula, the base measure & aggregation, dimensions, filters, grain, edge cases, and a tool-ready spec.
How do I install it?
Run `npx skills add mohitagw15856/pm-claude-skills --skill metric-semantic-layer --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From mohitagw15856/pm-claude-skills, a repository with 1,255 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.