Row-level and aggregate calculations

Introduction to Sigma

Katrina Menne

Sigma Alliance Lead at Aimpoint Digital

Calculations in Sigma

• Use workbook data to answer key questions, like how long each call lasted in minutes
• Create a simple calculation to find call duration in minutes

Calculations in Sigma

• Use workbook data to answer key questions, like how long each call lasted in minutes
• Create a simple calculation to find call duration in minutes
• New questions will be asked:
  • Average call length by day
  • Grand total of minutes

Groupings

• Grouping by dimensions helps answer "For each" questions in your data
• Example: For each day or agent, calculate average or total call duration

 

Using the Formula Editor

Aggregating table data with Groupings

• Use table-level groupings to summarize data at a higher level
• Change data granularity by grouping records by day, agent, or other categories
• Calculate totals or averages for each group

Aggregating table data with Groupings

Let's practice!

Introduction to Sigma