Time tracking report per person in a given group
Allow exporting a CSV containing issue time-tracking data for a date period. This is an API-only method. Like exporting project issues to a CSV, it simply schedules a Sidekiq job that will email a CSV to the user. (Although it occurs to me it should be possible to construct the below report in GraphQL, if we support the relevant parts of our schema there, and then convert the response to CSV.)
- This is only available at the group level initially.
- It is only available to group reporters and up. (As they can see all issues in the group.)
- The user can select a date range to report on.
- The maximum date range is 60 days.
- The date range applies to the spend actions, not to when the issues were opened / closed / assigned. (In other words, the date range applies to
timelogs.created_at
.)
- The CSV has the following columns:
- Time.
- Username.
- Spend.
- Issue ID.
- Issue URL.
- Issue title.
- Milestone title.
- Epic title.
- Project Title.
If the group does not support epics, the epic column is omitted.
All of the above is, as always, subject to change. It's largely based on #10741 (comment 223769851), but if our internal customers have different needs, or we come across issues in implementation, we can address those.
Original description
From https://gitlab.com/gitlab-org/gitlab-ee/issues/10728#note_154839310:
There's a few things I would love to see in something like this:
- Reporting: Government will typically need a breakdown of something like this
There's a few things I would love to see in something like this:
Name | Hours | $/hour | Total |
---|---|---|---|
David | 8 | $200 | $1600 |
Chris | 10 | $500 | $5000 |
* | 18 | * | $6600 |