Metrics and Aggregations

Metrics and Aggregations

Within a fact transformation:

  • You can define measures (e.g., SUM(Amount), COUNT(Orders))
  • Use aliases to define user-friendly measure names
  • AC automatically handles aggregation functions and naming consistency
  • Macros can be used to standardize calculation patterns (e.g., DAX or SQL expressions)