Questions tagged [data-viz]
Post a PromptPrompts producing charts, dashboards, and visualizations.
14 prompts
18votes
2answers
1.6kviews
Prompt for a dedup + latest-record SQL query using window functions with a self-check
Reporting handed me an events table with duplicate rows per entity (late-arriving data, at-least-once delivery) and I needed exactly the latest row per key. The naive GROUP BY + MAX(updatedat) approac
18votes
2answers
2.0kviews
Choropleth of US counties with a projection and legend that don't lie
I was mapping a rate per county and the first output used Web Mercator, which visually inflates the northern counties and makes the whole map misleading for anything area-related. It also binned the d
16votes
2answers
3.1kviews
Canvas candlestick chart that survives a code review at 50k OHLC bars
Our desk needed an intraday candlestick view that stays at 60fps when someone scrolls a full year of 1-minute bars. The obvious SVG version from the model died around 8k nodes, and the first canvas at
16votes
1answers
1.7kviews
Prompt for a CSV-to-chart tool that picks the chart type instead of me
I wanted an internal tool where an analyst pastes any CSV and gets a defensible chart without choosing a type. My first attempt just always drew a bar chart, which is nonsense for two numeric columns.
14votes
2answers
2.2kviews
One-shot D3 time-series line chart that infers types from a messy CSV header
I kept feeding the model a CSV export from our analytics tool and getting a chart where the x-axis was treated as strings, so December sorted before February. The naive prompt ("plot this CSV as a lin
13votes
1answers
1.5kviews
SQL rollup prompt that returns chart-ready buckets with zero-filled gaps
My time-series charts had holes: any hour with no events simply didn't exist in the query result, so the line chart connected across gaps and hid outages. The naive "group by hour" prompt never genera
13votes
0answers
1.3kviews
Chart theming as design tokens so every chart in the app matches
We had six charts built by four people and they all looked slightly different: different grays for gridlines, different fonts, three shades of the same 'brand blue'. I wanted the model to generate a s
12votes
0answers
2.0kviews
How do I prompt for a Next.js dashboard that doesn't look like every other admin template?
Every time I ask for "a dashboard in Next.js" I get the same shadcn-flavored gray boxes. I built a genuinely distinctive analytics dashboard using the prompt below, which forces an editorial, print-in
9votes
0answers
1.2kviews
GitHub-style contribution calendar heatmap as pure SVG, no library
I wanted the little year-of-squares heatmap for an activity page, but the versions I got either misaligned the weekday rows or started the week on the wrong day, so the whole grid was shifted by one a
9votes
1answers
2.0kviews
Prompt that bakes accessibility into a chart instead of bolting it on later
Our charts passed a visual review and failed an a11y audit hard: color-only encoding, no keyboard access, screen readers announcing a wall of unlabeled paths. Retrofitting was miserable, so I moved th
8votes
1answers
1.8kviews
Interactive scatter explorer with brushing and a linked detail table
I wanted an explorer where you drag-select a region of a scatterplot and a table below updates to just those points, with the selection surviving zoom. My first version reset the brush every time the
8votes
0answers
968views
Inline SVG sparklines inside a table that stay readable at 20px tall
I needed a trend sparkline in the last column of a dense metrics table, one row per service. Every generated version either drew axes (pointless at that size) or normalized each row independently so a
8votes
1answers
894views
Turning a messy matplotlib notebook into one reproducible plotting script
I had a research notebook with 40 cells of exploratory plots, half of them relying on variables defined three cells up and a global rcParams tweak that only worked if you ran things in order. Sharing
7votes
0answers
1.6kviews
Prompt that turns any CSV into an interactive explorable chart page
Drop a CSV in, get a self-contained exploration UI out. The prompt below produces a page that infers column types, picks sensible defaults, and lets you switch dimensions. I use it weekly for one-off