Jira On-Prem to Cloud Migration Nuance - ability to see all stories

[Kurt Alexander]

As a Portfolio manager, I understand unless the admin changes the attributes of the system, I will never be able to export more than 1000 stories at a time.  However, as we recently migrated from on-premises version of Jira to a cloud version, I can no longer see a number than 1000, when I configure my filter to see different views via JQL.  This is a major hindrance, as those numbers sometimes let you know if the JQL created was 100% accurate or not.  Not to mention, if I were to use date delimiters to parse the data down to 1000 or less, it'd be via "hunt and peck" method, as I would not know if the date range had 1001 or say 1400 in it, which would tell me how much to adjust dates.

Some would say, "you never need to see this much data."  I would counter with, "you are right, but my leadership team does, and they also expect to be able to see a compare and contrast over months, quarters, years, over multiple projects, aggregated."  Thus the high numbers of stories to be captured.

Any ideas?  Thanks!

[Earl McCutcheon]

Hello @Kurt Alexander ,

The in-application data points are limited for performance reasons to prevent overloading Jira on daily operations for searching data on the cloud, but a really good workaround for you here, that will also open up a lot more reporting capabilities is to look at either of the free add-on apps "Jira Cloud for Google Sheets (Official)"  or the "Jira Cloud for Excel (official)"

These add-ons can pull live data from Jira Cloud into the external spreadsheet application allowing for customized reporting using all the native functionality of Excell or Google sheets, so they go far beyond just getting issue counts as you can create formulas and charts to your heart's content for super detailed and custom reporting purposes.

Using the apps, to get around the limitations of export limits these export tools can go past the native limits and you can specify a data cap far beyond 1000 imposed by the issue navigator.

As an example, I will focus on the google sheets version of the tow application mentioned above but the functionality is parity between the two apps with a minor difference of Sheets uses the function =jira() and Excel uses the function =JIRA.JQL()

with a format of:

=jira(“JQL filter”,“fields,as,a,comma,seperated,list”,<offset as number>,<limit as number>)

in the following sheet i did a quick import using the following formula in cell A1, noting that I set the limit to an extremely high value of  10 million knowing it is far greater than I need:

=jira("project is not empty","summary,description,issuekey",0,10000000)

and the following Formula in Cell E1 to get a count on rows:

=COUNTIF(A:A,"*")

Noting there are currently 8906 issues in my test instance that I have permissions to view

Alternatively, you can use the tools built-in wizard to do additional data pulls and again set the Max Issues to far above what you need and import:

Hope this is what you are looking for.

Regards,
Earl

[Kurt Alexander]

Thanks Earl!  Yes, I have seen this earlier, but when Inquired with our Jira admins, I was told Jira Cloud for Google Sheets was not whitelisted.  Considering we are a GSuite (almost exclusively) shop, that was a bit surprising.

I eagerly await for it, as I have been using Excel exports and static formulas to create Jira based portfolio metrics for a few years now.  Sheets would be so much better as a back-end, then tossing the metrics into Data Studio.