Jul 15

How to do Reporting in Jira + BigPicture?

Until recently reports in BigPicture were somewhat obscure. You would use ‘sums’, ‘counts’, and grouping available in Gantt chart and Scope modules. Starting BigPicture 7.3, though, there is a new reporting component. You get five predefined reports out-of-the-box, and they measure how your iterations, PIs, and projects are progressing. You can also configure custom column or pie charts as well as grid reports. How to go about reporting in Jira BigPicture?

And how does the new module differ from BigPicture to BigPicture Enterprise?

The new Reports module – for Agile, Waterfall, or Mixed Project management?

The new ‘Reports’ module is useful for all BigPicture users—those who are fully agile, classically waterfall, or – most commonly – hybrid. Note, in the below picture, how you can select the timeframe:

  • ‘Program’ – think Jira project(s)). I recommend this view to Waterfall/Hybrid/Agile project managers—those who use either the Gantt chart or Agile Board component of BigPicture.
  • ‘Program Increment’ – for SAFe employing, agile at scale organizations, those who use BigPicture’s Agile Board.
  • ‘Iteration’ – for Agile, Scrum, and Hybrid project managers, those who use the Agile Board.

 

Reports in Jira Big Picture

Reports in BigPicture vs. BigPicture Enterprise

The new Reports module differs significantly between BigPicture and BigPicture Enterprise. You have five predefined reports in BigPicture. While you can swap between the grid, pie, and column manifestations of those five reports, you cannot create new, custom ones. The ‘Edit’ button belongs to BigPicture Enterprise. Therefore to change the layout of reports page, edit current charts/reports and create new ones, you need BP Enterprise.

BigPicture BigPicture Enterprise1
Five predefined reports; using Jira Core fields yes yes
Drill down reports. Four levels of hierarchy are available yes yes
Pie, column charts; grid reports yes yes
Sum and Count aggregate functions yes yes
Auto-refresh button. Useful, for instance, when you deliver a presentation to an audience and need to keep them updated with live data. yes yes
Create a custom report yes
Use Jira Software and BigPicture custom fields, such as Risk probability. yes
Edit the grid (layout) of the Reports page; add new rows and columns to the grid; set the default type of a report (pie/column chart) yes

1 Note that you need to have ‘regular’ BigPicture installed in order to use the BigPicture Enterprise extension.

BigGantt does not feature the new reporting module.

Custom charts in BigPicture Enterprise

When it comes to reporting the BigPicture Enterprise extension is worth considering. Not only does it let you create a virtually unlimited number of custom charts, but you can also use custom Jira Agile (Jira Software) and BigPicture fields, such as Risk probability or Risk consequence, as in the below picture. You can also change the layout of your reports page—add new rows and columns.

Create custom report Jira, BigPicture

 

Five predefined reports and how to use them

Pivot table - Jira report

Four levels of the hierarchy are available in the pie, column charts as well as in the pictured grid form. Pie and column charts can be drilled down, too.

Let’s get back to the five standard reports present in both BigPicture and BigPicture Enterprise. What real-life scenarios can they cover?

Status per Assignee report. Check who in your team has the largest number of ‘To Do’ tasks. Is the individual possibly overallocated?

Issue Type per Status report. Monitor what are your teams indeed busy with at the moment. If, for instance, you take a closer look at the ‘In Progress’ status and you notice a single story and a dozen bugs in progress than it’s undoubtedly a bug-fixing time and you risk stalling in terms of product development.

Fix Versions per Status report. This one is for software houses. Say, you develop an app for both Jira Server, Cloud, and Data Center hostings. The report shows how far away you are at the moment from the release for each of the hostings.

Assignee per Status chart. Check who’s overloaded in a team and who’s not.

Priority per Assignee chart. You could, for instance, have a closer look at the ‘Highest’ priority in this report. And you’ve discovered that the Support team dominated the ‘Highest’ category. Having noticed that, what actions would you take as a project manager or CEO?

Are BigPicture’s Reports as professional as Google Sheets or MS Excel?

COUNT, SUM functions, pie chartSpreadsheets’ most popular aggregate functions – SUM and COUNT – are available in the new reporting module. The COUNT is pretty obvious and pictured here. You would typically count tasks by status, type, or risk level. SUM, on the other hand, could be used to aggregate time spent or time estimated.

Hover, drill down Jira pie chartNote, that you can drill the graphs down, as explained in the picture. For instance, you might want to take a closer look at sub-tasks. You can either hover over the ‘Sub-task’ slice of the chart to get the pictured on on-the-fly ‘bubbles’. Or, you can click the red slice to step one level down, and get the ‘To Do/Done’ cutaway, pictured to the right.

Four levels of hierarchy are available in the Reports.

 

How else can you do reporting in Jira + BigPicture?

Now, for a moment, let’s forget the BigPicture’s new reporting component. Instead, let’s see how BigPicture users could do reporting prior to the new Reports module. Keep in mind the below methods remain operational.

(1) Scope and Gantt chart modules

Here you can aggregate columns, such as story points, time (logged, remaining), the number of tasks per user, or skills required. Sum, Count, and Average functions are available. The Scope component is especially appropriate for reporting purposes since it lets you save and reload your customized views-reports.

Project scope report

Note that the options available under ‘Aggregation’ vary from field to field. For instance, the Story Points field offers Min, Max, Sum, Avg, among others.

 

(2) Roadmap and Board 2.0

Starting BigPicture 7.2, you’ve got a report overlay on the Roadmap and Board 2.0 components. Pictured is the Roadmapping module.

Roadmap reports, Jira + BigPicture

(3) Program Manager

Here you can observe the progress of your programs (projects). Say, Project A is 75% completed, and Project B is only 25 percent done—this kind of high-level, big picture indicators. If you run a portfolio of programs and not just a single project, the Program Manager is a place to be. Note, however, that the Program Manager will soon be replaced by [Boxes]. It’ll be a change for the better, though.

Project portfolio progress report, Jira Big Picture

A bird’s eye view on the whole portfolio. ‘Percent completed’ of each program, here 99% or 100%, are evident.

 

(4) Resources component

Detect under- and over-allocation of your teams, individuals, and other resources. Do it using Week, Month, Quarter, and Half year perspectives.

Resources report Big Picture

Note, how you can switch the aggregation of remaining capacity between Daily, Weekly, and Monthly.

 

(5) CSV, XLSX files

Finally, you can export datasets to CSV and XLSX files from Scope, Gantt chart, Roadmap, Resources, and Risks components of BigPicture. Use standard Google Sheets/MS Excel functions to extract necessary aggregates. More in BigTemplate docs.

Export to csv, xlsx Excel Jira

Conclusion

Reports are the first BigPicture’s reporting module per se. The new module best supplement the Agile Board and Gantt chart modules of BigPicture. The reports focus on progress – be it the progress of a program (~Jira project), SAFe’s Program Increments that live within that program, or iterations (sprints) that exist inside the PIs. The reports were designed to alert a project manager quickly when the first cracks begin to appear on the workflow.

Reporting in Jira

Create a reporting page for your team – this is one example.

 

The good news
Aug 2019
BigPicture 7.4 for Jira Server, Data Center and Cloud is now live. It has new Quick assignee, Multi-select, and Time Tracking (Spent) features, among others.
July 2019
New Reporting component for BigPicture 7.3 and the corresponding version of BP Enterprise is scheduled for a release in July. Pie and column charts, as well as spreadsheet-style reports,  will be available – more.

Upcoming events

See you in:

  • San Diego for SAFe Summit, Sep 29 – Oct 4
  • Paris during Valiantys Enterprise Day, Oct 17

Complete calendar

About The Author

With his automotive background Marcin goes beyond the 'Jira + software development' standard. He likes simple, up-to-five-sentence answers to complex questions.