Data Cleaning Exercises

Pro exercise

Average order value per channel

Report the average order value per channel, rounded to cents. Only valid amounts count: a missing or broken amount is excluded and reported, never treated as zero.

  • aggregation
  • averages
  • rounding

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