Month to Month Reporting, grouped by month and by assignee

Meryl Orne-Gliemann April 30, 2022

I'm looking for a way to see month-to-month reporting on number of tickets processed by our Team, possibly using the two-dimensional filter statistics: eg: 

X-Axis: Month   (eg: Jan-22, Feb-22, Mar-22 etc ....). and 
Y-Axis: Assigneee (Team Member)

Although our tickets auto record dates (eg: created date, resolved date etc ...), there doesn't seem to be any functionality to group dates within reporting. 

I've been playing with adding an additional field to the tickets, to record the month, but that adds another touchpoint for our team
Any advice/suggestions would be great thank you 🙏🏻

 

5 answers

3 votes
Gorka Puente _Appfire_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 2, 2022

Hi @Meryl Orne-Gliemann ,

If you're app for a commercial app, we are behind Dashboard Hub for Jira. You can create powerful custom charts in case you need to query JQL and give your own visual metaphor. Like in the following example, where I'm creating a grouped bar chart with all the resolved issues by agent by quarter. You can customized the colors, order, hide agents... 

Screenshot 2022-05-02 at 11.07.28.png

And of course you can have a single dashboard for all your reporting needs, it provides ~70 gadgets/metrics ready to go, integrations with 10 different products, ability to share externally the reports, templates for your dashboards... Here you can see three different examples: Agile Team dashboard, ITSM dashboard, DevOps dashboard

Hope this helps!

0 votes
Amen Teng May 10, 2022

Hi Meryl,

We released a beta free app that delivers just that. You can try out the app here and looking forward to your feedback to help us improve the app. Support Dashboards and Reports for JSM.

The report you are looking for is called the "Agent workload" report in our app. Hope that helps.

0 votes
Bloompeak Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 5, 2022

Hi @Meryl Orne-Gliemann

Welcome to the Atlassian Community!

You can try Reports - Charts and Graphs for Jira app developed by our team to create various reports, charts and graphs for your Jira projects.

  • You can create custom, flexible and colorful bar charts and table views for any data you want/need. As data source, you can choose Projects or Saved Filters or Advanced (JQL).
  • You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.
  • You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.
  • You can group your data on any field(Sprint, Status, Assignee, Component, Project etc.) you want.
  • You can choose various date ranges like All Time, Last Year, Last 3 Months, Last 6 Months etc.
  • You can modify existing Segments or add new segments.
  • You can order the results by drag and drop.
  • Here is a sample report that shows sum of story points on each fix version.

Below you can see an article about creating custom reports, charts and graphs in Jira with our app.

How to Create Custom and Flexible Reports, Charts and Graphs in Jira

Here is our live demo dashboard where you can see and modify sample reports and play with them.

Hope it helps.

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 1, 2022

Welcome to the Atlassian Community!

You are right to be reaching for a new field for this.  Jira does not have any functions for grouping any of its recorded dates together..

Of course, I would script it, rather than use a field and ask people to enter it.  A script or automation could easily populate a select list field with jan-22 feb-22 mar-22 etc when the issue is created or edited (and you could leave it off the view and edit screens so that humans can't mess with it and don't have to think about it)

Sreepriya Unnikrishnan September 20, 2022

Hi @Nic Brough -Adaptavist-  As a support team using JIRA Reporting Dashboards, this feature requested by the OP is highly essential for us. Disappointing that JIRA does not already have this in place for it's reporting. It would be very helpful if this grouping of dates is made available. Is there already a ticket for this request? Please let me know. Thanks,

Sreepriya

0 votes
Meryl Orne-Gliemann April 30, 2022

I forgot to add- hoping that this can be done using one single dashboard for all our reporting needs

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events