Group By

Group By

OVERVEW

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.




    • Related Articles

    • How to create a Pie chart

      OVERVIEW A pie chart is a circular graphical representation used to display data as a proportional distribution of categories. The chart resembles a pie, with each category represented as a slice, where the size of each slice corresponds to the ...

    • How to create a Table chart

      OVERVIEW A table chart, also known as a data table or tabular chart, is a visual representation of data in a structured tabular format. It presents data in rows and columns, similar to a spreadsheet or database table. Table charts are commonly used ...

    • Aggregate Query Mode

      OVERVIEW Aggregate query mode in Pluto Insights is a setting that determines how your data is processed and displayed in your charts. In Aggregate query mode, the data is grouped based on the selected columns and then mathematical or statistical ...

    • Time Grain

      OVERVIEW Time grain in Pluto Insights refers to the level of temporal detail you want to display in your charts. Essentially, it's the unit of time by which you're grouping your data. For instance, you could have data that spans several years but you ...

    • Metrics

      Overview In Pluto Insights, "metrics" refer to the quantitative measurements or calculations that you want to display or analyze in your charts. Metrics provide numerical values that represent specific aspects of your data. When creating a chart, you ...