Project

General

Profile

Actions

Feature #10561

open

Custom reporting

Added by Brett Zamir over 12 years ago. Updated over 12 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
My page
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:

Description

With the power offered by your custom fields and their data type enforcement, it would be great to be able to build reports (which like filters could themselves be saved and shared or private) which can calculate and combine fields, including custom fields, including post-filtering (e.g., totaling a field within a date range) for:

1) summing integer/float type fields (e.g., to show billable hours or total estimated hours across projects or within a project) and allowing arithmetic operations on such sums
2) counting how many items match a given filter or set of filters

Display would be nice to allow a custom label for these counts/calcs as well as special displays for these reports:

1) Counts by each item of an enumerated List or User field (e.g., by bar graphs).
2) Stats on activity over time (e.g., issues closed per person per day).

If you really wanted to go all out, one could use Stephen Fews' principles toward showing bulbs, bullet graphs, and sparklines which quickly indicate the need for action in some area. There are some nice libraries already for client-side canvas or SVG for rendering these faster than server-side image files.

Ideally this could all be viewable either on one's MyPage or the proposed group-viewable MyPage #10273 (subject ideally to access restrictions), though some stats might be nice to be able to show as an overlay in the calendar (e.g., number of bugs completed per day), building on issue #10267.

Since this would be fairly ambitious, I think it could be done in phases, such as being first able to show filterable sums and counts, then calculations based on these, then the special display types.

Actions

Also available in: Atom PDF