PromptVault
Data & ResearchProIntermediate

Why does the dashboard disagree with the source?

For analysts diagnosing a metric mismatch before changing queries or business definitions.

Works with
  • Gemini
The prompt155 words · 3 blanks

Troubleshoot the mismatch between [metric_definition], [calculation_logic], and [observed_symptom] before proposing any rewrite

The full prompt is in the app

Included with PromptVault Pro. Fill in the blanks there, then copy it into Gemini.

What you fill in

  • Metric specification[metric_definition]ExampleActive customer means one completed paid order during the calendar month
  • Query or formula[calculation_logic]ExampleSQL, spreadsheet formula, or transformation steps used by the dashboard
  • Mismatch evidence[observed_symptom]ExampleMarch dashboard shows 12,481 customers; source extract shows 11,906

How to use it

  1. 1Open it in PromptVault. Find it in Data & Research, or search for “Why does the dashboard disagree with the source?”.
  2. 2Fill in the 3 blanks. metric specification, query or formula and mismatch evidence — the only things the prompt cannot know.
  3. 3Copy and paste it into Gemini. That is the tool it is written for.

About this prompt

Why does the dashboard disagree with the source?” is a intermediate data & research prompt. For analysts diagnosing a metric mismatch before changing queries or business definitions. It is 155 words long and written to get a usable answer on the first message, in Gemini or any other chat assistant. Good for: troubleshooting, data analysis, statistics, audit and deep dive. Like every prompt in PromptVault, it was written and edited in-house, and it works offline once the app is installed.