What it looks like for your team
From question to reusable answer in seconds.
Enter your question in plain language and get a result table or create a chart instantly.
Click "Instant Answer" and you can instantly pivot, filter, and export data without needing to build a new dashboard.
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.
You may find the Sigma Monthly Product Revenue dashboard useful, it has a bar chart for Revenue by Month.
Monthly Product Revenue
Instant Answer
| Product ID | Product | Revenue |
|---|---|---|
|
|
|
|
| 6 | Pro Plan (Monthly) | $12,450 |
| 2 | Enterprise License | $8,200 |
| 7 | Pro Plan (Annual) | $5,100 |
| ... 8 more rows | ||
Optionally save the answer for reuse. When you do, the question, description, notes, SQL, chart code, and related resources are automatically created and saved together.
Top 10 products by revenue in the past 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.
This answer:
- Looks at all order line items placed in the past 30 days.
- Groups those sales by product.
- Calculates total revenue per product as the
sum of
product_priceacross all qualifying order items. - Ranks products from highest to lowest revenue.
- Returns the top 10 revenue ranks, including ties (so if multiple products share the same revenue as the 10th-ranked product, they will all be included).
Note
Custom Note