Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Weighted rates. A rate over many rows is a total divided by a total: add up the numerator over the rows, add up the denominator, then divide. Averaging each row's own rate lets a tiny row count as much as a huge one.
Refund Share = DIVIDE(SUM(refunds[amount]), [Revenue])
Finance compares how much each channel discounts. The AI assistant built Discount Rate as the average discount_pct over order lines, so a one-unit line counts as much as a pallet.
AI assistant: “Discount Rate is the average discount across order lines, by channel. Sales Rep discounts are only a little higher than the others, so rep discounting isn't a problem.”
Fix Discount Rate so it is the money given away in discounts divided by sales before discount (quantity times unit_price), both added up over the lines. Bigger lines must weigh more.
Matrix
Updates as you typeFilters on this visualorders[status] is completed
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe