Members lesson 22
Summarize by
Count records and compare averages, maximums, and minimums in a pivot table.
What you will practice
- Count records with COUNTA
- Calculate group averages
- Find group maximums and minimums
Lesson preview
Starting tableSupport tickets
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Team | Owner | Ticket ID | Resolution hours |
| 2 | Billing | Ana | T-101 | 4 |
| 3 | Technical | Bo | T-102 | 11 |
| 4 | Accounts | Cam | T-103 | 3 |
| 5 | Billing | Dee | T-104 | 7 |
| 6 | Technical | Ana | T-105 | 16 |
| 7 | Accounts | Bo | T-106 | 5 |
| 8 | Billing | Cam | T-107 | 6 |