Align metric definitions before reporting

Document denominators, periods, grain and joins in an inspectable specification before building reports.

適用情境 / When to use

Graphene documentation describes metrics and joins in a semantic layer. This exercise drafts a specification without installation or database access.

步驟 / Steps

1. Open an ordinary text chat at gemini.google.com with an eligible account. Prepare shareable or fictional plain text using the prompt parameters; transcribe it yourself and mark ambiguities. Do not upload source files or connect accounts.
2. Paste the text and prompt; request only a draft, comparison or plan, not tool execution.
3. Check every output against supplied sources, references and unknowns. A human decides next steps; no automatic publishing, payment or deployment.

提示詞 / Prompt

From [fictional fields, data grain, relationship descriptions, existing metric definitions and questions], draft metric specifications for [report purpose, period, timezone and output format]. State numerator, denominator, inclusion/exclusion rules, time boundaries, null handling, duplicate keys and join cardinality. Flag conflicting definitions and possible double counting without guessing business rules. Show manual derivations only from supplied samples and label them unexecuted; list missing inputs. Connect to no database, invent no SQL execution results or accuracy claims, and install, run or modify nothing. A data owner must review.

留意事項 / Cautions

• Project documentation is not independent performance evidence. We installed nothing, ran no queries and checked no real data.
• Checked 2026-11-02: official Gemini web lists Hong Kong, Macau, Taiwan, Traditional/Simplified Chinese and English; account and age eligibility apply. Limited use is available without a paid AI plan and varies by account and workload. Taiwan’s public subscription page lists Free at NT$0/month; no paid plan is required for this exercise. HK/Macau paid prices and local taxes, offers and final quotes are unverified. Output quality in all three languages is untested. Web eligibility does not establish App/API eligibility; neither is needed here. Original-tool regional features, devices and paid eligibility are unconfirmed; do not bypass restrictions. Android’s official region list also includes HK/Macau/Taiwan. The iOS and AI Studio/Gemini API lists include Taiwan, not Hong Kong or Macau; feature and device restrictions still apply.

來源限制 / Evidence limits

Project documentation is not independent performance evidence. We installed nothing, ran no queries and checked no real data.

流程說明 / Workflow note

Original, untested text-only exercise by this site; it does not reproduce source devices, agents or integrations. Checked 2026-11-02: official Gemini web lists Hong Kong, Macau, Taiwan, Traditional/Simplified Chinese and English; account and age eligibility apply. Limited use is available without a paid AI plan and varies by account and workload. Taiwan’s public subscription page lists Free at NT$0/month; no paid plan is required for this exercise. HK/Macau paid prices and local taxes, offers and final quotes are unverified. Output quality in all three languages is untested. Web eligibility does not establish App/API eligibility; neither is needed here. Original-tool regional features, devices and paid eligibility are unconfirmed; do not bypass restrictions. Android’s official region list also includes HK/Macau/Taiwan. The iOS and AI Studio/Gemini API lists include Taiwan, not Hong Kong or Macau; feature and device restrictions still apply.

原始工具組合 / Original tool stack

Graphene; coding agent; semantic models

Source checked: 2026-11-02

Graphene analytics framework