Creating a custom report

Question

Hi all,

We have a request from our Chief Product Officer to create a report after each sprint for our squads and to follow a very specific template (see below).

I imagine some part of this would be manual, but I'd like to understand if anyone has any ideas of how we might be able to get at this data? Even if we can get 70% there that would be immensely helpful.

So far the best I can think of is:

* Set up automations to add a label for any ticket that matches certain epics our teams use that fall within the categories of (bugs, interruptions, tech debt, new work) --> although there could be an automation cap potentially?
* Go into each project's issue navigator for "completed issues" and export it into sheets
* Filter by label and count up the points per category
* Use the points to calculate the % and add it to the report

^that said though this only solves getting this information for "completed" points and those 4 categories. We still wouldn't have the data for the "committed" column or rolled over points.

For additional context, we use company management projects. I am also open to paid add ons or extensions if it helps get us what we want.

Thanks!

Roberts Čāčus - eazyBI · Answer

Hi @Mara Julin ,

You can create reports with the desired information in eazyBI. Thank you @Hannes Obweger - JXL for Jira for the suggestion.

That could require two reports that have to be "glued" together and the Comments part added. I don't have exact examples, but you can browse our Demo account to get the gist of the app's capabilities - https://eazybi.com/accounts/1000/dashboards/14871-chart-types.

Let me know if you want to try it out and need assistance setting up the reports.

Best,

Roberts // support@eazybi.com

Levente Szabo _Midori_ · Answer

@Mara Julin

Better Excel Exporter comes with a built-in pivot report called "Committed vs Completed".

This would be a good starting point to modify a little bit and create the report you need, by adding extra columns like "Comments" in your example.

Note that Excel templates are freely customizable to fit custom requirements like in your case.

Give it a try and reach out if you run into difficulties, our technical support is always available to guide you through the process of creating your custom Jira Software report template.

Rahul_RVS · Answer

Hi @Mara Julin

You can try out our add-on

Agile Tools

and generate reports such as:

- Sum up values to see overall % progress for your Issue Hierarchy

- View the full hierarchy of linked issues, Portfolio/Advanced Roadmaps, Epics, and Subtasks.

- Apply a lot of filters to put the focus on the relevant data only

- how long colleagues have been assigned to issues

- Group your statuses to define your own Cycle/Lead times

- Track time spent by resources with multiple filters / category / grouping features