Summarizing and aggregating data

Summary calculations and aggregating data at various levels using group by functions are available through the Summarize tool. This is a popular tool that performs a variety of summation calculations, including: summing, math, min/max, string concatenation, grouping, and much more.

We will go through seven various calculations using the summary tool, and why these calculations are beneficial. Let's begin by looking through these examples using the same workflow as the previous section.

Summarize Example #1: Find the Min and Max DataValue by YearEnd, LocationAbbr, Topic, and Question.

Step 1: Select the Summarize tool from the Transform tool palette and drag it onto the canvas. Connect the Auto Field tool to ...

Get Learning Alteryx now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.