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

2 answers

0 votes
Jorden Minos
Contributor
April 16, 2024

@Marieke Cozijnsen - Hi Marieke, I was just wondering if you ended up finding a way to show time-series chart of open tickets?  I have the same need currently.  Appreciate any tips!  Thank you.

Jorden Minos
Contributor
April 16, 2024

@Marieke Cozijnsen - apologies, i accidentally posted this as an answer (it was meant to be a reply to the answer)

0 votes
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 8, 2021

Hi @Marieke Cozijnsen 

There is no out-of-the-box graph in Jira which you can tweak to get the results you want. You may want to try a few apps, to get your result. However I would find a 2d table quite suitable for this kind of report. Have you tried that?

Marieke Cozijnsen
Contributor
September 8, 2021

Thanks for your reply. No how can I make a 2d table on the Jira dashboard?

Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 8, 2021
  • Create and save your filter (if you haven't already)
  • Create a dashboard or find the dashboard to which you want to add this filter
  • Go to the dashboard and click add gadget
  • Find the "Two Dimensional Filter Statistics"
  • Go to the gadget add your filter to it, and configure the X and Y to your likings
Like Del Jensen likes this
Marieke Cozijnsen
Contributor
September 8, 2021

Thanks Alex, I had not used this gadget before. This is good for the current status of things. But how can I make sure I see in the table the number of tickets of each past week? e.g.
Week 35 900 open tickets

Week 34 850 open tickets etc. 

I can do that using my query but then it's a different query for each value and in this table I can only select one query.

Do you understand what I mean?

Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 8, 2021

Yes I do, but the answer is no. You will not be able to see a separation of past weeks.

Try the Recently Created Issues. It will look like this (and I think that this is what you were looking for)

week.png

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 8, 2021

Hi @Marieke Cozijnsen 

Adding to Alex's suggestions...

If you are okay seeing finer grain data than weekly, you could do this by mis-using Jira's version of the Cumulative Flow Diagram (CFD) report.  This report is available for both company-managed and team-managed projects.

Navigate to the report from your project, and de-select the "done" status.  That will show the cumulative counts of issues over time which are not completed.

Kind regards,
Bill

Marieke Cozijnsen
Contributor
September 8, 2021

Hi Bill,

Thanks for your response. Is it possible that this report is not available for a Service Project?
Service project.PNG

Marieke Cozijnsen
Contributor
September 8, 2021

Hi @Alex Koxaras _Relational_ ,

Unfortunately how many were 'recently created' does not show how many are open. I want to see if my team's workload is decreasing or increasing by seeing the amount of open tickets. 

Like Ashley Hilbert likes this
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 8, 2021

@Marieke Cozijnsen ,

Maybe you have misunderstand something. If you create your filter to show your OPEN and IN PROGRESS issues, and then select it in the gadget, you'll get the info you want. For example, I have created a filter with a JQL

status in ("In Progress", Open) ORDER BY created DESC

Now, I go to my dashboard, and configure my gadget by selecting the above filter:

openandinprogress.png

And then I get the exact results I got with my filter:

bars.png

 

And here is my saved filter:

filterOPEN.png

 

Now you get it? :)

Marieke Cozijnsen
Contributor
September 9, 2021

Hi @Alex Koxaras _Relational_ ,

I've tried that but it then filters on that it only shows the tickets created in that specific week and I need all the open tickets to be counted so also tickets that were created weeks or months ago but are still open in that specific week.

See here if I use your instructions and I click on the bar in the bar chart the filter is this:

Filter.PNG

Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 9, 2021

If you need all the ticket for all time, then don't use the "created >=" in your JQL. Your JQL should be something like

project in (AWI) and Status in (open, "to do") and resolution = unresolved

The above JQL statement will yield all open and to do issues, which are unresolved from the project AWI, for all time.

If you then place this JQL in the dashboard, it will show you and count all tickets that were created weeks or months ago. Just make sure that in "Days Previously" enter 365 for a whole year.

Marieke Cozijnsen
Contributor
September 9, 2021

Hi Alex, 

Yes but the 'recently created' chart always adds the 'created' in the JQL regardless of whether you have it in the saved filter. 

If you click on your own bar chart and you see the filter then you can see that it has added the 'created' in the JQL which makes sense as the gadget/graph is 'recently created'

Please correct me if I'm wrong though.

Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 9, 2021

I see what you mean. I'm afraid then that you'll have to search on the marketplace for an app, which will suit your need, because there is no out of the box functionality which will help you do exactly what you want.

Some free apps which may be useful to you could be:

Of course you can search on your own.

Like # people like this
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 9, 2021

Hi @Marieke Cozijnsen 

Yes, it appears the CFD is not available for service projects; I missed that you were using that type.  As Alex notes, it may be time to check what options are available in the marketplace.

Stuart
Contributor
November 6, 2023

You can create a board for a service project, it's just not obvious. If you go to a software project's board then click on the little caret next to the board name in the left-hand menu you should see the option to create a board. Then just pick Kanban and "Board from existing project" then just select you service management project.

Suggest an answer

Log in or Sign up to answer