How to create a Filter & Dashboard to calculate average # of Issues opened in last x days

p_park November 13, 2024

 

Hi All - My use case is that I'm trying to show that the average number of Issues (bugs and stories) being created in the last x days is trending down. I have created Filters to show # of Issues (Bugs and Stories) in the last x days. Is it possible to create a Filter &/or Dashboard to calculate average # of Issues opened in last x days? 

Thanks in advance! 

4 answers

0 votes
Vitalii_Bobak_SaaSJet
Atlassian Partner
November 20, 2024

Hi @p_park 

If you want to calculate the average number of issues, you can do this in a few ways:

  1. Manual Method:

    • Export the data to a CSV file.
    • Count the total issues created in the filtered timeframe and divide by x (number of days).
  2. Use an Add-on like Time in Status:

 

If you consider installing third-party add-ons, option for you can be Time in Status. You can get various real time reports with add-on. To get average days aging was on a give date just 

  1. Choose Average Time Report 
  2. Sort by Project (Assignee, JQL etc)
  3. Filter issues based on your preferred time (including issues created before add-on installation)
  4. Access your report through Grid View

Знімок екрана 2024-09-19 о 20.53.57.png

Also you can display the average time by Chart View. 

Знімок екрана 2024-09-19 о 20.55.23.png
 
Visualize Trends

  1. Use Time in Status reports to create exportable charts and graphs.
  2. Add custom widgets to your Jira Dashboard for tracking metrics like average lead time or issue creation trends.

                       Знімок екрана 2023-12-19 о 17.19.17.png

Add-on developed by my team and free up to 10 users
Hope it helps 

0 votes
p_park November 14, 2024

Thanks @Kit Friend  I created the Recently Created Chart gadget already. Good to know it doesn't have average capabilities.  

0 votes
Danut M _StonikByte_
Atlassian Partner
November 13, 2024

Hi @p_park,

You could try the Recently Created Chart gadget of Jira. This displays the number of issues reported each day (and how many of them are already resolved). Unfortunately it does not display the average as a number. 

image.png

For better charts, my advice is to search for on app (plugin) Atlassian Marketplace.

If you are willing to use an app, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget that can display the issue created every day of month, split by type along with the total or average.

image.png

 In addition, it can display this data as a chart. 

image.png

The app offers many other gadgets that could be useful to display the average.

If you need any help with these gadgets, feel free to contact us at support@stonikbyte.com.

Danut.

p_park November 14, 2024

Thanks @Danut M _StonikByte_ I created the Recently Created Chart gadget already. Good to know it doesn't have average capabilities.  

0 votes
Kit Friend
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 13, 2024

Without additional apps there's not too much smarts in terms of averages etc in Jira.

This guide will help you explore your native options: 

https://support.atlassian.com/jira-cloud-administration/docs/use-dashboard-gadgets/

I'd recommend trying the created vs resolved for helping with your visualisation here. 

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events