Skip to main content
SQL-BASICS5 MIN READ

Average Is Not Always the Metric

Explain when AVG is the wrong aggregate and choose a metric-aligned alternative.

Luis L Sales Lead W Weight G Grain Q Query Metric ask 20 sec The request Luis asks for average discount by region before a pricing review. The source table is opportunity line items. If line items are the weight by accident, enterprise deals dominate the answer. pricing decision line source grain

Read the full lesson

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in

← Back to library
Contact us