Design a metrics table that tracks both additive metrics (revenue, count) and non-additive metrics (

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Problem

Design a metrics table that tracks both additive metrics (revenue, count) and non-additive metrics (avg_order_value, conversion_rate) by date and channel. Non-additive metrics cannot be summed across dimensions.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.