DataWindows app
Personal KPI Dashboard
Pin the handful of numbers you care about (GMV, UV, conversion…) on a tiny desktop dashboard.
The problem
BI tools are slow and fragmented. Memory of yesterday's comparison fades.
The solution approach
A local dashboard: a few self-defined metric cards; import a new row daily; with WoW, YoY, and 7-day sparkline.
What you will end up with
- 4–12 freely arranged metric cards.
- Per card: today, yesterday, WoW / YoY, last-7 sparkline.
- Incrementally import one row from Excel/CSV; older data archived.
- Pinnable as a small desktop widget.
Ready-to-use prompt
You are a senior engineer building local desktop tools. The user is a business data owner, non-developer.
[Goal]
See the few numbers you care about in 3 seconds.
[Platform & Stack]
- Windows + macOS; Electron + React + TypeScript; local SQLite
[Core Features]
1. Metric definition: name, unit, manual-entry calc, target, threshold.
2. Main grid: 4–12 cards, drag to reorder.
3. Per card: today, yesterday, change arrow, 7-day sparkline, target hit flag.
4. Daily import from Excel/CSV one row per day; manual backfill allowed.
5. "Minimal mode" button: shrink to a horizontal bar pinned top-right.
[Visual Style]
- Light background, white cards, radius 16, generous whitespace.
- Primary button muted dark; secondary light gray.
- Follows system dark mode; system fonts.
[Robustness]
- All data stays on the local machine. Offline.
- Autosave; 7-day rolling backups.
- Friendly messages on bad input, never raw stack traces.
[Delivery]
1. Outline project structure + plain-text wireframe first; wait for confirmation.
2. Deliver in modules; run each one for me to see.
3. Package a Windows .exe and macOS .dmg, ship a 500-word plain-language user guide, list known limits.
Start with structure and wireframe.After copying
1
Open Codex Desktop and create a new project
2
Paste the prompt and send
3
Wait for Codex to finish; tweak company names, column names, button text as needed