A JQL for "how many times an issue has been updated in the past week?"

[Monica]

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?

[Hector Florin _Appfire_]

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

[Yuliia_Borivets__SaaSJet_]

Hi @Monica 

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.

[Johannes Rudolf]

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

[Yuliia_Borivets__SaaSJet_]

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.

[Johannes Rudolf]

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!

Johannes

[Yuliia_Borivets__SaaSJet_]

Thank you! Your feedback is welcome. Have a great day!

[Johannes Rudolf]

Hi @Yuliia_Borivets__SaaSJet_

thank you! Did have a look but it seems I cannot break it down as per issue? To see the exact number field updates as per field for specific issues? I need to find this data for +3k issues but I don't know if I have overlooked something?

Best regards,

Johannes

[Yuliia_Borivets__SaaSJet_]

Hi @Johannes Rudolf 

You can select the specific issue and check its field updates. But if I understand correctly, you need some report that will show all issues in your project and the number of updates for the specific custom field per issue, right?

If so, you can get the breakdown of the selected field changes per each issue like this:

Here, I selected the "log work" field as an example and sorted the columns by issue key.

In the left corner, you can see the number of updates for each issue. You can click that arrow and expand all changes. Does it look like smth that you need?

[Fabian Lim]

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

[Hannes Obweger - JXL for Jira]

Hi @Monica

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