Please enable JavaScript.
Coggle requires JavaScript to display documents.
Summarization (Summarize tool aka "group" or "group by"…
Summarization
Summarize tool aka "group" or "group by"
tool takes one or more columns by creating a "bucket" for each group
you can summarize more than one column
functions used in data buckets
one data is in "buckets" these functions can be applied
examine if rows change
first, last
count
min, max
average
median
mode
standard deviation
sum
Crosstab
once your summary is provided a crosstab creates new columns
helps deal with smaller data and transform it
makes data available in an intuitive fashion
example of a "skinny table" is sales of customers over time
This chapter was mostly examples and working with the north wind data file in Alteryx!