Data Cleaning Exercises

Pro exercise

Roll line flags up to orders

Summarize order lines per order: how many lines, whether ANY line is backordered and whether ALL lines have shipped. 'Any' and 'all' are different roll-ups of the same line-level facts.

  • aggregation
  • booleans
  • grain

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