Grouping
Applies to: Kyvos Reporting
Grouping allows you to organize or summarize related data based on one or more grouping keys. You can define the order of grouping using either the group key or a summary value of a detail field.
For example, you can group population data by Region and order the regions alphabetically or by population size (highest to lowest).
Key Highlights
Supports multi-level grouping, such as Country > State > City.
You can define sorting order, ranking logic, and conditional display for groups.
Useful for generating hierarchical reports and segmenting data effectively.
Grouping Properties
Property | Description |
|---|---|
Field | Select the field to group the report by. The first field becomes the Group By field (top-level grouping). Subsequent fields are added as Then By fields (nested grouping). |
Order | Select the sorting order:
|
Ranking Field | Optional. Select a field whose summary will be used to rank or sort groups instead of using the group key itself. |
Ranking Function | Choose a function to summarize the ranking field:
Function list varies based on the selected field's data type. |
Show When | Define a condition using fields and logical operators (AND/OR) to determine when the group should appear in the report. Only groups meeting the specified condition will be included. |
Group Actions
Action | Description |
|---|---|
Add Group ![+] | Adds a new group to the report. |
Remove Group ![-] | Removes the selected group. |
Grouping by Date Fields
When using a date field as a grouping key, you can choose to group by specific time units:
Unit | Description |
|---|---|
Minute | Groups data by minute (0–59) of the hour. |
Hour | Groups data by hour (0–23) of the day. |
Day | Groups data by day of the month (1–31). |
Week | Groups data by week number within the month. |
Month | Groups data by month (1–12). |
Quarter | Groups data by quarter (Q1–Q4). |
Year | Groups data by calendar year. |