메뉴
Use when Codex or another agent needs to explain a governed metric's business meaning, formula, source table, default dimensions, related fields, or口径 in ChatBI. Trigger for requests such as 指标解释, 口径说明, 销售额怎么算, 毛利率是什么意思, 目标完成率定义, and 指标来源.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
| name | chatbi-metric-explainer |
| description | Use when Codex or another agent needs to explain a governed metric's business meaning, formula, source table, default dimensions, related fields, or口径 in ChatBI. Trigger for requests such as 指标解释, 口径说明, 销售额怎么算, 毛利率是什么意思, 目标完成率定义, and 指标来源. |
| trigger_conditions | ["用户问指标含义、口径、公式、来源，不要数值结果"] |
| when_not_to_use | ["用户要实际查询指标值（用 chatbi-semantic-query）","用户要维护别名映射（用 chatbi-alias-manager）"] |
| required_context | ["问题中含指标名或业务别名"] |
Use this skill when the user wants an explanation of a metric rather than a metric value query.
scripts/explain_metric.py with the user's original Chinese question.收入 to the governed metric name in metric_definition.chatbi-semantic-query.python3 scripts/explain_metric.py "销售额口径是什么"
python3 scripts/explain_metric.py "解释一下毛利率" --json
python3 scripts/explain_metric.py "目标完成率怎么算"
python3 scripts/explain_metric.py "收入这个指标是什么意思" --json
Run commands from this skill directory, or pass the full path to the bundled script.
metric_definition.alias_mapping.field_dictionary.Return concise executive-friendly text. Do not generate business charts for metric explanation results unless the user explicitly asks for a visual breakdown of the formula.
This skill only reads semantic metadata tables. It must not modify MySQL data or write semantic aliases.
Use when Codex or another agent needs to summarize the currently connected ChatBI business database, list queryable tables or views, explain what each table contains, show row counts, fields, semantic metrics, dimensions, aliases, or answer questions like 当前数据库有哪些表可以查, 数据库概览, 业务库结构, 表清单, schema 概述.
Use when Codex or another agent needs to answer Chinese natural-language data questions against the local ChatBI demo MySQL database, map business terms to governed metrics and dimensions, generate safe read-only SQL, execute metric queries, or return JSON/table results for sales, revenue, gross margin, target achievement, customer, retention, region, channel, product, and monthly trend analysis.
Use when Codex or another agent needs to add missing Chinese synonyms, aliases, or business phrasing to the local ChatBI semantic layer, especially when a natural-language query uses a new word that should map to an existing metric or dimension in alias_mapping. Supports safely inserting aliases for governed metrics and dimensions such as 销售额, 毛利, 目标完成率, 客户留存率, 区域, 时间, 部门, 产品类别, 产品名称, 渠道, and 客户类型.
Auto-analysis middleware for uploaded tables. It profiles table rows, proposes metrics for user confirmation, executes accepted metrics with deterministic calculations, and emits frontend-ready analysis proposal/dashboard JSON for charts and dashboards.
BI chart recommendation for ChatBI and analytics workflows. Use when Codex needs to choose chart types and emit frontend-ready chart recommendation JSON from a user's analysis intent, Query Intent JSON, SQL result metadata, or tabular data, especially after natural language to SQL to data pipelines.
Use when the user asks for month-over-month (环比) comparison of business metrics such as sales, gross margin, order count, or customer count. Triggers on phrases like "环比", "上月对比", "月度对比", "和上个月比", "比上月", "月环比". Returns a comparison table with absolute change and percentage change, plus a grouped bar chart plan.