Summary
This document provides information on group by functionality. Group By allows you to aggregate data based on multiple columns, enabling powerful insights.
It supports various aggregations, including sums, averages, counts, and more. This is vital for data analysis and reporting.
Features
- Column Selection: Select the columns to include in the group by calculation.
- Aggregation Type: Choose the aggregation method: sum, average, count, etc.
- Grouping: Define the grouping criteria.
- Results Display: View the results in a clear and organized manner.
Example
Let's say we have a table with columns 'Category' and 'Value'. We can group by 'Category' and calculate the sum of 'Value' for each category.
The output will show the total value for each category.
Visualizer
A visualization can show aggregated data more effectively.