Feature Request: Grouping and aggregation in list view
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 15/100
Research direction
This is design work spanning the list view UI and the backend query layer, so start by reading how the existing list view filters and sorts work items and how the server builds that query. Agree on the grouping model and the SUM semantics (per-group and overall totals) with maintainers before writing code. Done means a maintainer-approved design plus an implementation that groups by one field and sums one numeric column, with tests.
Written by the indexing model from the issue text.
Description
Description
It would be very useful to extend the list view with grouping and aggregation capabilities.
The goal is to make the list view suitable not only for displaying and filtering work items, but also for creating structured overviews based on field values.
Two related capabilities would be particularly useful:
- Group work items by field values
- Calculate sums for numeric fields
1. Grouping by field values
Users should be able to select a field by which the current list is grouped.
For example, when grouping by an Asset custom field, Windshift could create a hierarchical/tree-like view such as:
- Customer A
- Work Item 1
- Work Item 2
- Work Item 3
- Customer B
- Work Item 4
- Work Item 5
- No value
- Work Item 6
The same concept should ideally work with other suitable field types as well, for example:
- Assets
- Select fields
- Status
- Assignee
- User fields
- Project
- Other custom fields with discrete values
Groups should be collapsible/expandable so that the user can navigate larger result sets efficiently.
Expected functionality
- Select a field to group the current list by
- Automatically create groups based on the field values
- Display the corresponding work items below each group
- Provide a separate group for work items without a value
- Allow groups to be collapsed and expanded
- Keep the configured columns visible within the grouped view
2. Aggregation of numeric fields
For numeric fields displayed as columns, it should be possible to calculate aggregated values.
At minimum, SUM would be very useful.
When grouping is enabled, the list could display:
- Sum per group
- Overall sum across all displayed work items
Example
| Work Item | Customer | Estimated Cost | Actual Cost |
|---|---|---|---|
| Customer A | 15,000 | 12,500 | |
| Work Item 1 | Customer A | 10,000 | 8,000 |
| Work Item 2 | Customer A | 5,000 | 4,500 |
| Customer B | 20,000 | 18,000 | |
| Work Item 3 | Customer B | 20,000 | 18,000 |
| Total | 35,000 | 30,500 |
Ideally, aggregation could later support additional functions such as:
- Sum
- Average
- Minimum
- Maximum
- Count
Use cases
This would make the list view significantly more useful for reporting and management use cases, for example:
- Grouping work items by customer/account asset
- Grouping projects by department or business unit
- Displaying budget totals per customer
- Comparing estimated and actual costs
- Summing effort or story points
- Portfolio and project management overviews
- Financial and capacity-related reporting
Expected outcome
The list view should provide a flexible way to structure work items by field values and calculate aggregates for numeric columns.
This would allow users to create lightweight reporting and management views directly in Windshift without requiring an external reporting tool for relatively simple grouped reports.
- Dominant language
- Go
- Stars
- 421
- Forks
- 50
- Avg merge
- 17h 34m
- Merged PRs (30d)
- 80
Getting set up
- Ships a Dockerfile or Docker Compose file
- No pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Windshiftapp/core
-
Difficulty 2/5 1-3 hours Newbie friendliness 66/100
Windshiftapp/core#542 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 64/100
Windshiftapp/core#334 · 2 comments ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Windshiftapp/core#259 · 1 comment · 1 reaction ·
Maintainers usually reply within 1 day
-
[Bug][AI chat] Select menu dont appear when on index pagePossibly taken @valentimarco claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 20/100
Windshiftapp/core#541 ·
Maintainers usually reply within 1 day
-
Difficulty 3/5 1-2 days Newbie friendliness 45/100
Windshiftapp/core#538 · 1 reaction ·
Maintainers usually reply within 1 day
All issues in Windshiftapp/core
Similar issues
-
good first issue help wanted javascript
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 64/100
fullsend-ai/fullsend#9733 · 1 comment · 1 reaction ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
karmada-io/karmada#8101 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
Maintainers usually reply within 1 day