The "Group By" feature in Pluto Insights is a function that categorizes data into groups based on selected columns in your dataset. It's often used in conjunction with aggregate functions (like SUM, AVG, COUNT, etc.) to provide summarized information about each group.
HOW TO USE THE "GROUP BY" FUNCTION
For instance, let's consider a dataset tracking course completions, with columns such as "Course Name", "Enrollment Date", "Progress" and "Learner Name". If you want to know the number of learners enrolled in each course, you would use the "Group By" function with the "Course Name" column.
Here's how to do it:
Step 1: Select Aggregate Query Mode,
> Make sure you're in Aggregate Query Mode. This mode allows you to use the "Group By" function.
Step 2: Select a Metric,
> In the "Metrics" section, select "COUNT" as your aggregate function and "Learner Name" as the column to count.
Step 3: Use Group By,
> In the "Group By" section, add "Course Name" as the column to group by.
With these settings, Pluto Insights will create a chart showing the count of learners for each course, effectively giving you the number of learners enrolled in each course.
Remember, you can group by multiple columns if needed. This can provide more detailed categorizations. For example, grouping by both "Course Name" and "Enrollment Date" could give you the number of learners enrolled in each course on each date.