Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Month to Month Reporting, grouped by month and by assignee

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

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!

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.

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

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)

0 votes

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
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

289 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you