Data Cleaning Exercises

Pro exercise

Headline numbers in one row

Produce the three headline numbers for a dashboard tile: valid orders, total revenue and the exact median order value. One row, computed only from amounts that pass validation.

  • aggregation
  • medians
  • exact decimals

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