Features Releases Tips & Tricks

18 Useful Reports for Your Development Team

For every development team, keeping track of its activities is important. Your project tracking tool is the perfect place for creating reports and analyzing these activities. However, sometimes it’s not obvious which reports you need to productively manage, plan and estimate your project activities, with all the different sets of data on features, tasks and bugs your team is working on. Let’s talk about that.

Suppose you have a development project, plus your company runs a number of other projects. In this post, we’ll answer the following questions:

  • What kind of reports do you need to keep track of your development team’s activities?
  • What kind of reports are useful to overview your progress & keep track of all projects in your company?

Having investigated this topic at length, we outlined a number of different kinds of reports and implemented them in YouTrack Harmony.

Here we’ll take data from a real YouTrack project and create an example of each report type. A description will be provided for each report, with a sample configuration. We’ll also use other JetBrains development projects to show examples of reports spanning multiple projects.

Important update: YouTrack  is already released with various reports and the live Dashboard. Read the blog post The Power of Reporting and Analysis in YouTrack 6 for more details.

YouTrack Reports

  1. State Transition

This report reflects the dynamic change of field values over a certain time period. For example, it shows how many issues have been Fixed by each developer in the past 6 months, or shows who has reported the most issues that ended up as ‘Won’t fix.’

Example 1: YouTrack Fixed/Verified issues in Spring 2014. For each developer, it shows how many issues ended up Fixed or Verified:

Project: YouTrack
Query: -Unassigned  (to exclude unassigned issues)
From States: Open, Submitted, in Progress, to be Discussed
To States: Fixed, Verified
Group by: Assignee

state transition

 Example 2: Who reported the most Won’t Fix issues in the past year?

Project: Marketing
Period: June 19, 2013—June 19, 2014
Type: State
From values: Submitted, Open, To be Discussed, Wait for Reply
To values: Won’t Fix
Group by: Reporter

won't fix

2. Matrix Report

This report demonstrates the distribution of two attribute values at the moment for any set of issues, presented as a matrix. You choose which attributes to use for X and Y axis and set any query to limit your set of issues.

Example:  States and Priorities Distribution in YouTrack project. This gives you an idea of how unresolved issues are distributed by states and priority in your project at the moment.

Project: YouTrack
Query: -Resolved
X axis: State
Y axis: Priority

state_priority matrix

3. Issue Distribution

A visual representation of the matrix report.

Example: How issue priorities are distributed by subsystems in your project.

Project: YouTrack
X axis: Priority
Y axis: Subsystem

subsystem distribution

You may narrow down the report by selecting which priorities to show. Click the Subsystem bar to open the list of corresponding issues.

4. Issues per Assignee

This report reflects the number of issues assigned to each member of the team at the moment, within one or more projects.

Example: How many unresolved issues are assigned to each developer in YouTrack project at the moment.

Project: YouTrack
Query: -Unassigned -Resolved

Issues per Assignee

Click on a developer bar to open his or her set of issues.

5. Issues per Project

This report shows the total number of issues at the moment, for any set of projects. It is a special case of the issue distribution report.

Example: Issue distribution in JetBrains Server Tools family of projects

Projects: YouTrack, YouTrack Feedback, TeamCity

issues per project

6. Pie Chart

The pie chart shows how issues are distributed at the moment by states, assignee, priority, types, etc. inside one or more projects.

Example: My Tasks. The pie chart shows how my unresolved issues are distributed by priority at the moment.

Project: YouTrack
Query: for:me #unresolved
Slices: Priority


7. Reopened Distribution

This report shows how many issues have been reopened, grouped by assignee, priority or project, over a given time period.

Example: How many issues, fixed by each developer, were later reopened in the past year:

Projects: YouTrack
Query: -Unassigned
Period: June 19, 2013—June 19, 2014
Group by: Assignee

reopened rate

8. Verified Distribution

Shows the number of verified issues grouped by assignee (QA), priority, project or any enumeration field.

example: How many issues each QA Engineer has verified this year.

Project: YouTrack
Query: -Nobody
Period: January 1, 2014—June 20, 2014
Group by: Verified by

verified rate

9. Time Report

The Time Report shows the total spent time working on project(s) or iteration(s) with the type of the work done and original estimation. It can be grouped by the type of work done or by users.

Example: Team time tracking report for the past month.

Project: Internal Development
Period: May 20, 2014—June 20, 2014
Group by: Work Author
Enable: Show work types

css_time report

10. Burndown Chart

This chart shows the ideal progress vs. actual progress for any set of issues over a certain time period. It can be based on issue count or any other kind of estimation value. Unlike Agile board’s Burndown, it’s not limited to a single Agile board or a single sprint.

For example, here is the Burndown chart which reflects the progress in the YouTrack development project in Spring 2014.

Project: YouTrack
Time period: March 1, 2014—May 31, 2014
Estimation field: Issue Count


11. Cumulative Flow

This report shows the distribution of issue states for a given time period. Unlike Agile board’s Cumulative Flow, it can be built based on any set of issues for any time period. It may include several projects and iterations and a set of custom states.

For example, here is the YouTrack Cumulative flow. It shows the dynamics of selected set of states distribution in Spring 2014.

Project: Marketing
Time period: March 1, 2014—May 31, 2014
Type: State
States: Open, To be Discussed, In Progress, Verified

Cumulative flow

When you click any stripe on the chart, the report is narrowed down to a single state. For example, here is the report narrowed down to the ‘In Progress’ state change only:

in Progress Cumulative flow

12. Custom Issue Distribution

This report shows the overall issue distribution for a set of projects for the last X days. Each project is illustrated as a double-bar, where each bar can be customized to show a certain issue attribute distribution. For example, you can see the distribution of features, bugs, exceptions and states (open, in progress, fixed) for a set of projects.

This report is more complicated to configure, but very clear and useful for managers who are interested in the general overview of all company projects.

Example: How many new Features vs. Bugs were reported, and how many issues were Fixed/Duplicated/Closed in the past 3 months, in ReSharper, IntelliJIDEA, TeamCity, YouTrack and PhpStorm projects.

Projects: ReSharper, IntelliJIDEA, TeamCity, YouTrack and PhpStorm
Period: March 20, 2014—June 20, 2014

Bar 1:
New Features: created Query: type:Feature
New Bugs: created Query: type:Bug

Bar 2:
Fixed: resolved date, Query: state:Fixed -Exception
Duplicate:resolved date, Query: type:Duplicate -Exception
Closed: resolved date, Query: -Exception state: {Can’t Reproduce}, {Won’t Fix}, Obsolete

custom issue distribution

13. Resolution Time 

This report shows the average duration of issue life cycle each day. It also shows the minimum and maximum resolution time each day. For example, this report is perfect for SLA Management.

Example: YouTrack Feedback average resolution time for 2014

Project: YouTrack Feedback
Period: January 1,2014—June 23, 2014

resolution time

14. New and Reopened vs. Resolved Rate (in progress)

Gives you an idea of the rate of incoming and outgoing issues in your project(s) for each day/week/month/year. Shows how fast your team resolves the issues and gets new ones to work on.

15. Reported vs. Fixed Rate (in progress)

Shows the ratio between reported and fixed issues for each day/week/month during a certain time period, in one or more projects. Gives you an idea of your team fix rate versus the rate of new issues reporting.

15(a). Verified vs. Reopened Rate (in progress)

This report shows verified vs. reopened issues in each day/week/month over a certain time period in a single or multiple projects.

16. Average Issue Age (in progress)
Shows average time it takes to transit issue from state to another. For example, you may want to know how much time, on average, your issues spend In Progress.

17. Issues Assigned to a User (in progress)
Shows how assigned to a user issues are distributed per states, priority, subsystem, etc.

18. Issues Resolved by a User (in progress)
Shows how issues resolved by a user are distributed per states, priority, subsystem, etc.

We hope you find some of these reports useful for your team. You’re welcome to try them in YouTrack.

We will keep adding more reports and sharing them with you as soon as they arrive. Please follow @youtrack to stay tuned.

Your feedback and input are extremely important to us. Please:

Keep tracking with pleasure!

Comments below can no longer be edited.

21 Responses to 18 Useful Reports for Your Development Team

  1. Avatar

    Michael Hedgpeth says:

    June 27, 2014

    This is really great stuff. I’m anxious to show this to people. Great job guys.

    • Valerie Andrianova

      Valerie Andrianova says:

      June 30, 2014

      Thanks, Michael!

  2. Avatar

    Rhona says:

    June 28, 2014

    Tested out some of the reports in the EAP, and they are exactly what I have been wanting/needing from YouTrack. Great job guys!

    • Valerie Andrianova

      Valerie Andrianova says:

      June 30, 2014

      Rhona, thanks for your feedback, we really appreciate it!

  3. Avatar

    Robin Roos says:

    July 16, 2014

    My management want to see Roadmap reports – features prioritised by some key such as an estimated completion date and/or status, with each feature carrying its description as a paragraph of readable text not a single line CSV.

    What can you suggest?

    • Valerie Andrianova

      Valerie Andrianova says:

      July 22, 2014

      Please use the Release Notes report, available on from the Issues List now. Filter the features you need and hit Reports->Issues in HTML. You can share the link to this report with your manager and team. To view the issues description, please click View Options, enable show description. Here is the example of the Release Notes for YouTrack 5.2.2
      With YouTrack 6 you’ll be able to add any kind of issues list (top issues, planned, roadmap) and share this widget with anyone.

  4. Avatar

    Mykola Shvachka says:

    July 16, 2014

    I don’t see one of the most useful report – Matrix Report with Issues by X axis and Date by Y

    __________|Issue 15|Issue 15|Issue 15|
    12.07.2015|_____1h|____ 1h|_______|
    14.07.2015| _______|_______|_____8h|

    Or maybe I don’t now how? Does anybody know?


    • Valerie Andrianova

      Valerie Andrianova says:

      July 22, 2014

      Thanks, Mykola! This report would be definitely useful. However, it looks like the Time report, grouped by date. Here is the feature request, based on your feedback:http://youtrack.jetbrains.com/issue/JT-25725
      Please add your comments and vote. We’ll add it to the 6.x version.

  5. Avatar

    Mykola Shvachka says:

    July 16, 2014

    @moderator, I’m sorry – final-final version)
    I don’t see one of the most useful report – Matrix Report with Date by X axis and with Issues by Y

    Issue 15|________1h|________1h|_________|
    Issue 16|________7h|__________|_________|
    Issue 17|__________|__________|_______8h|

  6. Avatar

    Mark Goldenstein says:

    August 15, 2014

    How can I make the Burndown chart time-based instead of task-based?

  7. Avatar

    Raffaele says:

    September 30, 2014

    In current YouTrack, 5.x series, is it possible to generate charts like Reported/Resolved (15) and Cumulative flow (11)? Or am I supposed to download the Excel data and print a chart with it?

    • Valerie Andrianova

      Valerie Andrianova says:

      October 1, 2014

      All the reports described in this blog post are coming in YouTrack 6 (planned for this fall). Cumulative flow is currently available in Agile Board only. The described Cumulative flow is more general and will be available in version 6. All new reports are already available for early preview here:http://confluence.jetbrains.com/display/TSYSPUB/YouTrack+EAP+Builds

  8. Avatar

    Martin Bless says:

    December 5, 2014

    This is all very great. Honestly! Nevertheless: What we need here is a “9. Time Report” that lists the text (and time) of the single time stamps.

    How can we do that?

  9. Avatar

    alinadi says:

    February 25, 2015

    Hi there,

    Is there any way to create report look likes this matrix report

    usr1 5h 0h 2h 7h
    usr2 1h 9h 4h 1d6h

    i create matrix report with column-row = project-assignne, but it shows issue number for projects instead of spent time.

    thank you for help.

    • Valerie Andrianova

      Valerie Andrianova says:

      March 4, 2015

      Unfortunately, not at the moment. Please use Time report to get the totals of work items and group it by Assignee.

      • Avatar

        alinadi says:

        March 10, 2015

        I want to see project based spent time per users. So i can figure out how my employes spent time, which project spent time mostly. Then i can calculate project costs.
        However i think you improve your report solutions for customs reports.

        • Valerie Andrianova

          Valerie Andrianova says:

          March 10, 2015

          Thanks for the details, I assume that Time Tracking report, grouped by Assignee, should work for you.

  10. Avatar

    Irfan says:

    June 24, 2015

    I would like to get time spent report , group by each day, user.
    1. I want to each employee logged time each day
    2. I also want to know which day employee has not logged any time.

    Is it possible with the current version of YouTrack?

    • Valerie Andrianova

      Valerie Andrianova says:

      June 26, 2015

      Unfortunately, it’s not possible at the moment. I think your request is similar to this one:https://youtrack.jetbrains.com/issue/JT-25725
      I’ve added your comment. Please watch the issue to get the updates.

  11. Avatar

    Terry Thompson says:

    June 29, 2017

    I’m building a report that must include a matrix that will list each project members name and their location. The locations are fixed, however the member move between locations daily.

Discover more