I'm helping our interal it departement presenting some kpi goals from Jira, and need a nice way of showing data from 5 different Jira filters. Right now I have 5 Filter Results beneath each other and the team manager has to copy the values into excel and make graphs for him self. See attach picture.
I have the following simple JQL query 5 times (giving me data from current week and the past 4 week):
project = HD AND issuetype = Task and status CHANGED FROM Closed TO Open DURING(startOfWeek(-1),endOfWeek(-1))
Is it somehow possible to present the number of issues from each query graphically?
Thanks in advance.
Mark Ørnebjerg Jensen
Hi Mark, as it's explained in this other question it's not possible to achieve that.
A possible solution would be to have a gadget per filter.
Based on the information you gave, I believe you could make use of one of these tools:
1. In issue navigator, search for issues using one of your filters. Click on Views > Excel (All fields) or Excel (Current fields) or Charts. You can do this to export search results to Excel with all fields, current fields, or to generate a dashboard gadget that will show the results graphically.
2. Create a report based on especific criteria. On the project page of any of your projects, you'll see a "reports" button on the top right corner. Click on that to generate a report, refining some criteria. Use this documentation for more information https://confluence.atlassian.com/display/JIRA/Generating+Reports
Hope it helps.
I want this also. I have a bunch of filters which track our releases. My manager wants a Gadget which shows this for a set of filters:
filter name - open bugs - resolved bugs - closed bugs
Does this exist now? It is hard to search for something like this. The terms are abstract.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot