Pro exercise

Headline metrics as rows

A reporting tool wants metrics as rows (metric, value), not as one wide row. Compute the total, mean and median order value from valid amounts, then unpivot the three numbers into rows — all with the same type and 4 decimals, so they can share one value column.

• aggregation
• unpivot
• types

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.