As a data analyst, I would like to pull from Jira on the update frequency of a set of issues.
Does JQL offer any solutions?
Hi @Monica
Unfortunately this is not possible out of the box. You will need reporting plugins to get you this. EazyBI is the app I would recommend for this one. Example: https://community.eazybi.com/t/count-user-interaction-with-issue/4309/5
I will let others chime in with other plugins.
Regards,
Fabian
Hello @Monica ,
I'm afraid that options is not natively available, but you can use a workflow Plugin like Power Scripts.
With Power Scripts you can build an script that can filter all the issues that have been updated in a certain range of time, but also count how many updates have been done on each ticket during that time, and many more!
https://marketplace.atlassian.com/apps/43318/power-scripts-jira-workflow-automation/?tab=overview&hosting=cloud
Thank you
If you need to see all changes made to one or multiple issues, you can try Issue History for Jira. add-on. My team developed it as a journal of all past activities.
You can select a date range, project, updaters, issues you want to see, etc. Multiple filters allow you to adjust the reports to your needs.
Also, you can export the report for further analysis.
Here is an example of one report:
There is a free 30-day trial to check if it works for you.
if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including the number of updates.
This is how it looks in action:
As you can see above, you can easily sort and filter by the number of updates, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.
Currently, the number of updates would show the updates across an issue's entire lifecycle, rather than a particular time range. If the above looks interesting to you, we'd be happy to look into a time range configuration, too.
Note that the above just works - so there's no scripting or automation whatsoever required.
Any question just let me know,
Best,
Hannes
Hi @Yuliia_Borivets__SaaSJet_
that sounds interesting. For a specific use case I am looking for a solution. This would be to find out the exact number of times a specific custom field has been updated in the past. A date field to be precise. Would that be possible?
Thanks & best regards,
Johannes
Hi @Johannes Rudolf
Thank you for your question! It's possible to see the exact number of updates for a specific custom field. This information is available in the field or column manager.
You can also set some filters like project and dates to narrow down the result. It looks like this:
So, generally, this information is available for any standard and most of the custom fields. You might check how it works for you.
I'll be happy to answer any further questions you might have.
Thank you for your swift response, @Yuliia_Borivets__SaaSJet_ .
I'll have a look at it then and will let you know.
Thanks again and have a wonderful day!
It looks like you're new here. Sign in or register to get started.
