Reuse answers, not effort

Save the answer (SQL, question, documentation, context) with links to dashboards/apps, so your team can get consistent answers fast and prevent unnecessary rework.

Request demo Learn more

Top 10 products by revenue in the past 30 days

Rob D
By Rob D Added Jan 02, 2026
320 24
Answer

What are the top 10 products by revenue in the last 30 days?

Description

This answer identifies your best-selling products by revenue contribution over the last 30 days.

"Revenue" is defined as the sum of product_price from the order_items table.
"Last 30 days" is interpreted as the 30-day period immediately preceding the current timestamp when the query is executed... View More

Data
jaffle_shop.order_items jaffle_shop.product
Related Resources
order_items
Sigma Monthly Revenue
Sigma Monthly Revenue
Answer
Results
Chart
Query
product_id product_name total_revenue revenue_rank
BEV-004 for richer or pour $8,3447 1
JAF-004 flame impala $7,2436 2
BEV-003 vanilla ice $7,1856 3
BEV-001 tangaroo $7,1484 4
JAF-005 mel-bun $6,1128 5
JAF-003 the krautback $6,0936 6
BEV-002 chai and mighty $5,9855 7
JAF-001 nutellaphone $5,5451 8
JAF-002 doctor stew $5,5154 9
BEV-005 adele-ade $4,7088 10

What gets saved in the Answers Library

Not just a number or a chart, all the context your team needs to reuse it confidently.

The Question

Automatically Captured in plain English so it's easy to search.

The SQL

The exact code used, including templates and parameters.

Direct Links

Deep links to related Sigma dashboards and Retool apps.

Definitions

Related key terms (e.g., “activation date”, “ARR”).

Guidance

Notes on how to use it (“don’t use this for revenue reporting”).

Context

Descriptions, ownership info, last updated dates, and tags for discovery.

How it works

Capture what worked once and reuse it everywhere.

Create

Ask a question (business user) and save the answer or write a query (technical user).

Enrich

runQL automatically enriches the query with descriptions, links, and documentation.

Publish

Edit anything and then publish the answer to the Library (optionally review/approve).

Reuse

Now when a team member searches or asks a question, the answer is suggested instantly.

What it looks like for your team

Your team can instantly find and reuse the answers they need.

Option A

Save as you go

When you get an instant answer to your question or write a query (technical person), you can instantly save that answer for reuse by your team. The question, description, notes, SQL, chart code, and related resources are automatically created and saved together.

Editor Toolbar

Top 10 products by revenue in the past 30 days

Rob D
By Rob D Added Jan 02, 2026
Question
What are the top 10 products by revenue in the last 30 days?
Auto Description

This answer identifies your best-selling products by revenue contribution over the last 30 days.

"Revenue" is defined as the sum of product_price from the order_items table.
"Last 30 days" is interpreted as the 30-day period immediately preceding the current timestamp when the query is executed... View More

Note

Custom Note

More Questions
SQL Query
Chart (Code)
Related Resources (Sigma, Retool, PowerBI)
Option B

Seed Answers

When a new dataset comes online, runQL can automatically create questions and answers so the most likely questions are already answered, reviewed, and ready before anyone asks. The seed answers are created from your schema + automatic semantic definitions, and you can also import your existing ticket backlog to kick of a seed answer process.

1. AI predicts likely questions

Based on schema structure and definitions.

2. Drafts are generated

SQL + documentation created automatically.

3. Review & publish

Expert verifies and makes them reusable.

Option A

Search the Library

Your team can find answers by business question or keyword. No need to know the exact column name, just ask like a human.

Find Data with runQL
Option B

Use a Saved Answer

When someone on your team asks or searches, they will be presented instantly with a saved answer, if there is one.

Answer

This answer identifies your best-selling products by revenue contribution over the last 30 days.

"Revenue" is defined as the sum of product_price from the order_items table.
"Last 30 days" is interpreted as the 30-day period immediately preceding the current timestamp when the query is executed... View more

order_items
Sigma Product Revenue
Answer Saved Answer
Results
Chart
Query
product_id product_name total_revenue revenue_rank
BEV-004 for richer or pour $8,3447 1
JAF-004 flame impala $7,2436 2

Edit anything to customize it as needed

You’re not stuck with the automated text. Your team owns the final definitions.

Edit details

Edit any documentation, tags, or metadata to match your business.

Human overrides

Your manual edits automatically became the source of truth over AI versions.

Add custom selectors

Let your team quickly select specific values (e.g. Region, Segment).

Add usage notes

Warn users about specific caveats (e.g., “don’t use this for revenue reporting”).

Great for ...

Recurring Questions

The same questions come up weekly.

Preventing Rework

People rebuild dashboards because they can’t find prior work.

One Source of Truth

You want one place for “how we answer this”.

Faster Onboarding

You want faster onboarding (“here’s how we measure X”).

Full Context

You want logic, documentation, and links captured together.

Stop building duplicate dashboards and apps

Most teams aren’t short on data, they’re short on reusable answers.

Manual Reality

  • Teams answer the same question repeatedly in Slack.
  • People rebuild “close enough” dashboards because they can't find originals.
  • Knowledge disappears when someone leaves or changes roles.

With runQL

  • The answer becomes a reusable asset instantly.
  • The SQL and resource links are always attached for validation.
  • New teammates ramp faster because the library is their starting point.

Related features

Automated Data Dictionary

The foundation for accurate answers.

Automated Resource Dictionary

Index your existing dashboards and reports.

Data Chat & Search

Ask questions and find answers in the library.

Build a library your team actually uses.

Save answers once. Reuse them everywhere.

Request demo