Aggregate Query Mode

Aggregate Query Mode


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 operations are applied to create summary values.


For example, suppose you have a dataset of course completion progress and you want to create a table chart showing the completion progress per User Segment. You would use Aggregate query mode for this.

In this mode, you would select "User Segment" as your "Group By" column, and then choose a metric like "Completion Progress" with an aggregate function such as "Count". The system then groups the data by User Segment and calculates the completion progress for each Segment. 

Aggregate query mode is useful for creating summary visualizations and gaining a high-level understanding of patterns and trends in your data.

    • Related Articles

    • Raw Records Query Mode

      OVERVIEW Raw Records query mode in Pluto Insights is a setting that allows you to display your data in its most detailed form, without any aggregation or summary. Each row in your chart corresponds directly to a row in your dataset. HOW TO SETUP THE ...
    • 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 ...
    • Percentage Metrics

      OVERVIEW Percentage metrics in Pluto Insights are metrics that represent a value as a percentage of a total or a subset of the data. They are useful for comparing proportions or relative contributions of different categories within your dataset. HOW ...
    • How to create a Bar chart

      Overview A Bar Chart compares metrics from different categories using bars. Bar lengths are used to indicate the magnitude of each value and colour is used to differentiate groups. Creating a Bar Chart Step 1: Select the "Charts" tab in the top bar, ...
    • 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 ...