Feature Request: Grouping and aggregation in list view

Đang mở
#277 0 bình luận 1 reaction 0 người được giao Xem trên GitHub

Maintainer thường phản hồi trong vòng 1 ngày

Chưa có ai nhận issue này.

Đánh giá

Độ khó
5/5
Thời gian dự kiến
Hơn một tuần
Mức phù hợp với người mới
15/100
Loại issue
Tính năng
Độ rõ ràng
Khá rõ ràng
Mức độ hoạt động
Ít trao đổi
Công nghệ
go
Lĩnh vực
backend, frontend

Hướng nghiên cứu

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.

Do mô hình lập chỉ mục viết ra từ nội dung của issue.

Mô tả

enhancement

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:

  1. Group work items by field values
  2. 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.

Ngôn ngữ chính
Go
Star
421
Fork
50
Merge trung bình
17 giờ 34 phút
Pull request đã merge (30 ngày)
80

Chuẩn bị môi trường

Bắt đầu từ đâu

  1. Đọc hết issue, rồi đọc hướng dẫn đóng góp của dự án.
  2. Bình luận trên issue rằng bạn sẽ nhận — tránh hai người làm cùng một việc.
  3. Fork repository và làm thay đổi trên một nhánh.
  4. Mở pull request có tham chiếu số hiệu của issue.

Issue khác của Windshiftapp/core

Tất cả issue của Windshiftapp/core

Issue tương tự

Thêm issue về Go

Nhận issue mới trong hộp thư của bạn

Bản tóm tắt ngắn những issue GitHub phù hợp với người mới.