Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Finance wants to know how much revenue comes from bulk orders that also got a discount, to decide whether bulk buyers still need discounts. The AI assistant says it is well over half of all revenue.
AI assistant: “Bulk Discount Revenue keeps lines with a quantity of 10 or more or a discount. It's well over half of revenue, so bulk discounts are a big deal.”
Fix Bulk Discount Revenue so it counts only order lines with a quantity of at least 10 and a discount above 0, both at once. The matrix shows it by channel next to [Revenue].
Matrix
Updates as you typeLoading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe