Advanced Calculations: Aggregating Dimensions

Aggregating measures is practically instinctive and often automatic, but some calculations or views can only be created by aggregating dimensions! Learn about the MIN(), MAX(), COUNT(), COUNTD() and ATTR() aggregation types, and why you might need to use them.

Lesson Objectives

At the end of this lesson, you will be able to:

• Define aggregation.
• Recognize when to aggregate dimensions.
• Recall dimension aggregation types.

Aggregating Dimensions in Calculations

Lesson Objectives

At the end of this lesson, you will be able to:

• Recognize the mixed aggregation error in a calculation.
• Edit a calculated field to display a valid expression.
• Recall dimension aggregates from the calculation aggregation list.