Skip to content
Superset + AI · Explainer

From Superset dashboards to an infinite canvas

Dashboards are great at showing the numbers you already watch. They struggle with the questions those numbers raise. Here is where a canvas fits.

For the complete AI-readable content index, see /llms.txt.

DashboardGPT TeamUpdated 3 min read
On this page
  1. What dashboards are good at
  2. Where dashboards struggle
  3. What a canvas does differently
  4. The same investigation on a canvas
  5. Using both on a Superset stack
  6. When to promote a canvas answer to a dashboard
  7. FAQ

Key takeaways

  • Dashboards answer known questions on a schedule. Exploration starts with a new question each time.
  • A grid makes follow-ups awkward: every new question means a new chart and a new place to put it.
  • On a canvas, answers are objects linked to the question they came from, so the reasoning stays visible.
  • Keep Superset dashboards for monitoring and use a canvas for investigation.

What dashboards are good at

Apache Superset dashboards do one job very well: show a fixed set of metrics, refreshed on a schedule, to many people at once. Weekly revenue, active users, pipeline by stage. Everyone looks at the same tiles and knows where to find them.

That is monitoring, and a grid is the right layout for it.

Where dashboards struggle

Monitoring raises questions. Revenue dropped this week. Why?

To answer that on a dashboard, you:

  1. Open the chart builder and create a new chart broken down by region.
  2. Find space on the dashboard, or open a new one.
  3. Build another chart by channel for the weakest region.
  4. Build another for the weeks before and after.

Each step is a new chart, a new saved object and a new place to look. The line of reasoning, "revenue fell, it was the West, it was paid search, it started in week two", exists only in your head.

A grid is built for answers you already know you will need. It has no natural place for the next question.

What a canvas does differently

On the DashboardGPT canvas, each answer is an object: a chart, a metric, a table or a written insight. The canvas is infinite, so there is always room for the next answer beside the one it came from.

Dashboard gridInfinite canvas
Best forMonitoring known metricsInvestigating new questions
How a chart is madeBuild and save itAsk a question
Follow-upsNew chart, new tileSelect an answer and ask
LayoutFixed gridFree: group, arrange, branch
ReasoningLives in your headVisible as linked answers
RefreshScheduledScheduled on Team, or ask again

Three ideas make the canvas work:

  • Answers are objects, not tiles. Move them, group them, delete dead ends.
  • The thread stays visible. Each follow-up is linked to the answer it came from.
  • Group what belongs together. Headline, breakdown and cause sit side by side.

The same investigation on a canvas

  1. Ask "Weekly revenue for the last 12 weeks." A line chart appears.
  2. Select it and ask "Break the last week down by region." A bar chart appears next to it, linked.
  3. Select the West bar and ask "By channel, last 4 weeks." Paid search stands out.
  4. Ask "When did paid search orders start falling?" Week two.

Four answers, arranged left to right, with the reasoning visible. Share the canvas and a colleague can follow the investigation without a meeting.

Using both on a Superset stack

You do not have to choose. DashboardGPT is built on Apache Superset for query execution and charts, so the two fit together:

  • Superset dashboards for the metrics everyone monitors every week.
  • The DashboardGPT canvas for the questions those metrics raise.

A simple routine: review the dashboard on Monday; when something moves, open a canvas and investigate; share the canvas in the team channel with the conclusion at the top.

When to promote a canvas answer to a dashboard

If you find yourself asking the same question every week, it has become a monitoring question. Build it as a dashboard chart so it refreshes for everyone. The canvas is where questions start; the dashboard is where the permanent ones end up.

Frequently asked questions

No. Dashboards are best for monitoring known metrics. A canvas is best for exploring the questions they raise. Most teams use both.

Yes. Query execution and chart rendering in DashboardGPT are built on Apache Superset.

Each follow-up needs a new chart built and placed by hand, and the dashboard has no way to link it to the chart it came from.

Yes. On the Team plan, canvases can be shared with your team.

When you ask it regularly and others need to see it on a schedule.

Ask your data a question.

Open the playground and ask about revenue, churn or campaign spend. Charts, metrics and written insights appear on an infinite canvas.

  • No account, no install
  • Free plan with CSV and Excel uploads
  • Bring your own AI key