Understanding Symmetric Aggregates

Metadata

• Author: Google Cloud
• Full Title:: Understanding Symmetric Aggregates
• Category:: 🗞️Articles
• Document Tags:: Looker,
• URL:: https://cloud.google.com/looker/docs/best-practices/understanding-symmetric-aggregates
• Finished date:: 2023-06-30

Highlights

Symmetric aggregates prevent analysts — and anyone else who uses Looker — from accidentally miscalculating aggregates such as sums, averages, and counts (View Highlight)

Symmetric aggregates do this by making sure to count each fact in the calculation the correct number of times as well as by keeping track of what you’re calculating. (View Highlight)

the symmetric aggregates function recognizes that total is a property of orders (not order_items), so it needs to count each order’s total only once to get the correct answer (View Highlight)

symmetric aggregates impose some performance costs (View Highlight)