You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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:
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?
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?
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)
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.
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? :)
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:
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.
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.
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.
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 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.