Skip to main content
DatabricksPySparkSnowflakeApache Airflow
Code Keys/PySpark Academy/Module 10/Lesson 78
PYSPARK • LESSON 78

Multi-Metric Aggregate Calculations

How do we compute order count, gross sales, and average ticket size simultaneously in one pass?

Intermediate⏱ 2 Minutes⭐ 410 XP
🤔 THE QUESTION

How do we compute order count, gross sales, and average ticket size simultaneously in one pass?

💡 WHAT IS IT?

Passing multiple aggregate expressions into select() to perform comprehensive statistical profiling.

🎯 WHAT IS IT USED FOR?

Daily KPI snapshots, executive summary cards, and business health monitoring.

💻 EXAMPLE
from pyspark.sql.functions import avg, col, count, sum

df.select(
    count(col("order_id")).alias("order_count"),
    sum(col("amount")).alias("gross_sales"),
    avg(col("amount")).alias("avg_ticket_size")
).show()

🎯 Mission Objectives

Practice typing production-grade PySpark code for Multi-Metric Aggregate Calculations.

  • ✓ Compute count, sum, and avg simultaneously
  • ✓ Alias all calculated metrics
  • ✓ Display executive business summary
🚀 Start Mission
← Prev (Unique Cardinality with countDistinct())Next Lesson (Filtering Prior to Aggregation) →