Group By and Binning
This guide covers Group By (Breakdown) and Binning — shared features available across Query, Funnel, Flow, Retention, Data Table, and Significance reports.
Group By (Breakdown)
Group By segments your data by one or more dimensions. Instead of a single aggregated number, you see values split by category — for example, event count broken down by country or by model name.
Adding Group By Fields
Select a dimension field (e.g., country, device type, span name, model name) to split the results. You can add multiple Group By levels to create nested segmentation, up to the limit for the report type.
Group By Limits by Report Type
Report Type | Max Groups | Notes |
|---|---|---|
Query (most chart types) | 2 | Two-level nested breakdown |
Query (Histogram) | 1 | Histogram requires exactly one Group By with binning |
Query (Heatmap) | Exactly 2 | First group = X-axis, second group = Y-axis |
Funnel | 2 | Plus up to 5 cohort segments |
Flow | 2 | Standard breakdown |
Retention | 2 | Max 8 displayed rows |
Data Table | 5 | Significantly more dimensional depth than other report types |
Significance | Not applicable | Uses Comparison Criteria (Breakdown/Segment/Experiment) instead |
Sort Order
Results within each group are sorted in descending order by default (highest values first). Toggle to ascending order using the sort button in the Group By section.
Overall Toggle
The Overall toggle adds an extra row or line showing the measure computed without any grouping applied — the true total across all dimension values.
Off (default): "Overall" is the sum of the visible groups. If the data has many dimension values and only the top ones are shown, the overall equals only the displayed groups' sum.
On: "Overall" is the actual total computed without the Group By, so it includes all dimension values regardless of how many are displayed.
Overall is automatically forced on when a formula contains division (/) or when a measure function requires it.
Cluster Mode (Funnel Only)
When a breakdown is active in a Funnel's Conversion mode, you can choose how bars are visually grouped:
Cluster Mode | Description |
|---|---|
Funnel | Groups bars by breakdown value. Shows all steps for one segment together, then the next segment. Best for comparing the full funnel journey across segments. |
Step | Groups bars by funnel step. Shows all segments for one step together, then the next step. Best for comparing segments at each individual step. |
Example — Funnel clustering: [Step1-Mobile, Step2-Mobile, Step3-Mobile] [Step1-Desktop, Step2-Desktop, Step3-Desktop]
Example — Step clustering: [Step1-Mobile, Step1-Desktop] [Step2-Mobile, Step2-Desktop] [Step3-Mobile, Step3-Desktop]
Cluster mode is only available when a breakdown is active AND the funnel is in Conversion mode.
Binning
Binning lets you bucket the values of a Group By field into ranges or groups instead of showing every distinct value. This is especially useful for numeric or high-cardinality fields.
Range Binning (Numeric Fields)
Divide a numeric field into equal-width or custom ranges.
Auto Range
Specify boundaries and Kubit generates equal-width bins:
Parameter | Description | Constraints |
|---|---|---|
Min Value | Lower bound of the first bin | Must be >= 0 |
Max Value | Upper bound of the last bin | Must be > Min |
Number of Bins | How many equal-width bins to create | 1–50 |
Example: Min=0, Max=100, Bins=5 creates ranges [0–20], [20–40], [40–60], [60–80], [80–100].
Manual Range
Define each bin's boundaries individually:
Add up to 50 bins, each with a min and max value.
Bins must not overlap.
Each bin can be given a custom label (e.g., "Low", "Medium", "High").
Enum Binning (Categorical Fields)
Group specific categorical values together into named buckets.
Create buckets and assign one or more field values to each.
Give each bucket a custom label.
Group Others toggle: when enabled, all values not assigned to any bucket are combined into a single "Others" group. When disabled, unassigned values appear individually.
Date Binning (Date/Time Fields)
Bucket date values into time-based ranges (e.g., group dates into custom periods).
Named Binning (Saved Templates)
Select a previously saved binning configuration to reuse across reports.
When Binning Is Required
Histogram charts always require binning — you must define how the distribution values are bucketed.
For all other chart types, binning is optional. It's available whenever a Group By field supports bucketing (indicated by the field's metadata).