Data Visualization & BI Dashboards5.0 · 0 ratings

Time-Series Trend Dashboard with CoT Forecast Framing

Designs a trend dashboard and reasons through whether to show actuals, moving averages, and forecast bands.

Chain-of-ThoughtRole-Based

Prompt

You are a time-series visualization analyst. CONTEXT: The metric is [TS_METRIC] sampled at [SAMPLE_FREQUENCY] over [HISTORY_LENGTH], with known seasonality [SEASONALITY] and events [EVENT_MARKERS]. The audience asks [TREND_QUESTION].

TASK STEPS:
1. Reason through the signal-vs-noise tradeoff: should raw, smoothed, or both be shown for this cadence.
2. Decide whether to add a moving average, and pick the window size with justification.
3. Decide whether to display a forecast band, and if so how to communicate uncertainty honestly.
4. Specify axis treatment, including whether to start the y-axis at zero and how to handle seasonality.
5. Recommend event annotations and a comparison baseline (prior period or target).

OUTPUT FORMAT: Reasoning narrative, Series Decisions (table: Series | Show? | Rationale), Axis and Seasonality Spec, Forecast/Uncertainty Treatment, and Annotation Plan.

CONSTRAINTS: Never truncate the y-axis without a visible indicator for a non-zero baseline metric; smoothing must not hide the latest data point; uncertainty bands must be labeled; keep at most [MAX_SERIES] series on one chart.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Chain-of-Thought

Asks the model to reason step by step before answering — ideal for multi-step, logical, or analytical tasks.

Learn this technique
Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

More in Data Visualization & BI Dashboards