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:
@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.
@Marieke Cozijnsen - apologies, i accidentally posted this as an answer (it was meant to be a reply to the answer)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your reply. No how can I make a 2d table on the Jira dashboard?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bill,
Thanks for your response. Is it possible that this report is not available for a Service Project?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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? :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.