Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Relationships. A relationship lets a filter flow from a lookup table (one row per value) to a table with many rows per value. It runs from the many side to the one side, on the column both tables share.
refunds[order_id] → orders[order_id]
While tidying the model, a colleague deleted a relationship. Now the Revenue by category matrix shows the same number on every row.
Add the missing relationship so that Revenue splits correctly by product category.
Matrix
Updates as you typeLoading the Brightline model…
Language