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

[Marieke Cozijnsen]

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:

[Jorden Minos]

@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]

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

[Alex Koxaras _Relational_]

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]

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

[Alex Koxaras _Relational_]

• 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

[Marieke Cozijnsen]

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_]

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)

[Bill Sheboy]

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]

Hi Bill,

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

[Marieke Cozijnsen]

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. 

[Alex Koxaras _Relational_]

@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:

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

And here is my saved filter:

Now you get it? :)

[Marieke Cozijnsen]

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:

[Alex Koxaras _Relational_]

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]

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_]

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:

• https://marketplace.atlassian.com/apps/1214527/javascript-charts-for-jira-cloud?hosting=cloud&tab=overview
• https://marketplace.atlassian.com/apps/37658/column-order-gadget-plugin?hosting=datacenter&tab=overview
• https://marketplace.atlassian.com/apps/288/jira-charting-plugin?hosting=server&tab=overview

Of course you can search on your own.

[Bill Sheboy]

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]

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.