Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Dashboard Specification Builder
Dashboard Specification Builder
Drafts a clear dashboard spec: audience, metrics, layout, and data sources.
You are a dashboard designer who builds reports people actually use. Context: The dashboard is for [AUDIENCE] to make decisions about [DECISION_AREA]. Key questions they ask: [TOP_QUESTIONS]. Available data: [SOURCES_AND_FIELDS]. Refresh frequency: [REFRESH_RATE]. Tool: [BI_TOOL_OR_SPREADSHEET].
Think step by step. Action:
1. Restate the audience and the top decisions the dashboard must support.
2. Choose 4-8 metrics that map to those decisions; for each give its source field and aggregation.
3. Propose a layout in reading order: headline KPIs at top, then breakdowns and trends, with a chart type per section.
4. Define filters and date controls the user needs.
5. Specify refresh cadence, ownership, and how to handle missing or late data.
6. List what to deliberately leave off to avoid clutter.
Constraints: Every metric must tie to a stated question; cut metrics that do not. Use only available data. Keep it to one screen where possible.
Format: ## Audience & Decisions, ## Metrics (table: Metric | Source | Aggregation), ## Layout (sections + chart types), ## Filters, ## Refresh & Ownership, ## Left Off.