Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I show number of open tickets at the end of each week in a graph on Jira Dashboard

Marieke Cozijnsen
Contributor
September 8, 2021

I can retrieve the amount of tickets that were open at the end of each week using the JQL query of e.g.

Project = Y AND status was in ("Open", "In Progress") ON startOfWeek()

Project = Y AND status was in ("Open", "In Progress") ON startOfWeek(-1)

Project = Y AND status was in ("Open", "In Progress") ON startOfWeek(-2) etc.

Any way to show this in a graph on a Jira Dashboard? Or another way to do it instead of above formulas?

Preferably using a bar chart e.g:
bar chart.PNG

1 answer

1 accepted

1 vote
Answer accepted
Zul NS [Atlassian]
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 13, 2012

You can configure this by going to System > Issue Feature > Time Tracking. Change the "Time estimates will be displayed in the following format" to hours. More information, you can visit https://confluence.atlassian.com/display/JIRA/Configuring+Time+Tracking

Martin Bayreuther
Contributor
November 13, 2012

Yes, this was what I was searching for. Turned out I didn't search properly.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events