Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×Hello everyone,
I’m looking for advice on Jira gadgets to use for comparing two filters:
Could you recommend the most suitable gadgets for this type of comparison?
Thank you in advance for your suggestions!
Have a great day.
Hello Eran,
you can use Two dimensional filter statistics gadget.This gadget allows you to compare two filters side by side. You can set one axis to represent the time period (Q4 this year vs. Q4 last year) and the other axis to represent the bug count or other relevant metrics.
So I looked at my first answer and then some of the others and realize I was giving you an "down in the details" solution without a clear indication of the possibilities.
I am colorblind so if the follow looks hideous, I apologize up front.
I added a new tab to the BI Solution I've started sharing here: (feel free to access this example). Power BI Rest API Example 2
Note - I didn't load any more data so I used the 1st half of November and the 2nd half of November for my sample time periods.
With the rest APIs pulling the data out for you, the possibilities are pretty limitless. And no matter what you want to do, you only have to understand how this all works one time. No variations from one Plug in to another.
And I have mentioned the APIS are Free? If you're up to the task - you can proceed from here and never talk to any of us again. Or, you can start with my Power BI solution .. which is free for a short while.
Good luck!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Eran Roiter,
You could use two Jira gadgets side-by-side. I would recommend the Issue statistics gadget (the Two Dimensional Filter Statistics gadget could be also an option), configured with a filter that returns the issues from each quarter.
But if you need something more advanced and easier to configure, you could search for an app on Atlassian Marketplace that offers these statistics.
If you are willing to use an app, our Great Gadgets app has some useful gadgets for this:
Advanced Issue Filter Formula gadget - lets you display the count, sums, percentages etc of issues in up to 6 filters or JQLs. This is an example for you use case.
Pivot Table & Pivot Chart gadget - lets you create multidimensional tables and pivot charts of various types
Hope this helps.
Danut
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Eran Roiter,
I am Marlene, product manager of Quick Filters for Jira Dashboards.
If you are open to work with a Marketplace app, you can try out the Bar Chart gadget of our Jira cloud app.
It's possible to define "Custom JQL Values" for each bar, as you can see in the "Config Screenshot".
- Just select "Custom. JQL Values" as "Field" in the config.
- Then define the JQL for each bar.
If you want to test Quick Filters for Jira Dashboards without installation, you can visit our demo dashboards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Eran Roiter
How do you want to compare the issues from the two filter results? What questions do you want to answer?
For built-in dashboard gadgets...
If you want to inspect the details of the issues, and their fields, try the Filter Results or Two-dimensional Filter Statistics gadgets.
If you want to see trends over time, try the Created vs. Resolved Chart or Average Time in Status ones.
Next, discuss this need with your Jira Site Admin as your company may already be using marketplace addons to dashboards to help.
There are both paid and free gadgets to add for such comparison reporting. An example free one from Atlassian is the JavaScript Chart for Jira Cloud. It has multiple chart types for displaying multiple filters as chart series, and please note it can be a bit difficult to use.
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.
The REST API (or maybe even just the issue navigator) could be your friend here.
Step 1. Create a filter (or JQL) for Q4 2023.
Step 2. Create a filter (or JQL) for Q4 2024.
Step 3. Export the issues either with the Issue Navigator (if not too many) or using the REST API call : yoursite/rest/api/3/search?jql=filter=10000. You can test it in a browser since it is a GET call.
Example : https://splitdimedata.atlassian.net/rest/api/3/search?jql=filter=10003
If you are still reading ... all you have left to deal with is Pagination and an API key.
But the APIS are free --- no plugins needed.
You can put this in Power BI, Excel, or probably many other JSON capable tools. Atlassian provides the Postman libraries right there on the API Documentation Page.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I can think of having two of "two dimensional filter" side by side. Other than that I have hardly come across any use case that can compare real-time data based on the part history of the issues.
Please note that you will be able to get a good view based on all the fields other than status as those are always updated.
-Bibek
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.