Group/Break feature: allow results to be grouped by one or more columns and allow selection of aggregation function per column, including Sum, Mean, Min, Max, StdDev, Percentile, Concatenate, Concatenate Distinct. “Break” feature retains individual rows and provides a summary row per grouping level.

1. Specific example: Multi-value cell: if multiple values apply to a row, e.g. multiple roles for a participant, there should be an option to display all of them in a delimited list within the cell.
2. Groups based on calculated value allow construction of histogram reports. E.g. create a column for “time of day” and round timestamps to hour values, stripping off date information. This becomes the “group” value. Then use a COUNT() calculation for log entries. This creates a histogram of site activity per hour of the day over the selected timespan.
3. Group with aggregate calculations is a critical feature for learning analytics. Indicators and targets must be “scaled” to convert to a value between -1 and 1. Scaling options should include:
4. Percentile (based on current report results)
5. Manual min/max, logarithmic distribution
6. Manual min/max, linear distribution
7. Manual classifier (conditional function transforming integers to categorical values - binary classifier is just a specific example of this)