nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Present data from more that one filter in a gadget

Mark Ørnebjerg

Hi,

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

Brunata a/s

Accepted answers

Ramiro P

Hi Mark, as it's explained in this other question it's not possible to achieve that.

https://answers.atlassian.com/questions/2773/is-there-a-way-to-display-multiple-series-on-a-jira-chart-gadget

A possible solution would be to have a gadget per filter.

All comments

Jeison

Hi Mark,

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