Getting an effective report

[Adam G Alsop]

Hello all!

I am looking to see if there is a way to get a specifically formatted report out of JIRA without having to use something like Excel, crystal reports, PowerBI, etc and access the underlying DB directly (which will be challenging for me to get approval on).

I can almost get what I want, but not quite.  I suppose it's almost really more of a Dashboard, as I'd also like to get TOTALS on different fields.  Right now it's a manual process in Excel with is completely unsustainable.

Using Advanced Query, I can get the basis of what I want -

FEATURE ... Feature detail fields ....

Stories within that Feature, and all their details

Right now, I can only get the Story #s within the Features, and no additional details.

This is the JCL - 

project in ({Proj Name}) AND issuetype = Feature AND "PI (Program Increment)" = "{PI Value}" AND labels = {Team} ORDER BY key ASC

What I want to get is all the details on both the Features & Stories (Summary, PI/Sprint, Points, Fix Version, etc) and then get the TOTALS (Count of all Features per PI, Counts of all Stories within each Feature PLUS TOTAL Count of all Stories per PI, and the same for Points).

From a "Report" perspective, that's an easy thing to do, but (for me), not from a JIRA perspective.

Thanks SO much for any assistance!  (Oh, and NO option for any 3rd party plugins!)

--- Adam

[Danut M _StonikByte_]

Hi @Adam G Alsop,

It might not be possible to get all of this by using the native Jira reports.

I would advice having a look over this article on our blog: How to track multi-team or scaled-agile projects (such as SAFe®) in Jira with Great Gadgets app 

As you will see, with our Great Gadgets app you can get all the counts and totals that you need, and all charts and the SAFe® specific metrics at the team and PI level. 

It is a cost effective solution, which does not need direct access to Jira database.

Our support team will be willing to assist you with any questions. Just contact us at support@stonikbyte.com if you need any help. 

Thank you,

Danut Manda 

[Aron Gombas _Midori_]

First, note that on Cloud accessing the database directly with an external reporting tool is not an option at all. (You can export to Excel also on Cloud though, even with custom report templates.)

Second, I don't think you can do this without a third party app. 

If you can't use an app, then Atlassian Analytics can be your best option. That is a pretty interesting service, but I am not sure if it is mature enough for this this specific use case.

[Adam G Alsop]

Hmmm, that does not seem like a move in a positive direction.  If the app itself cannot support necessary reporting (or Dashboard) requirements, AND one is prevented from having direct DB access, that is definitely NOT a good user experience.

I am not certain whether my company has Analytics or not, but I will look into it.

Having to manually export data to Excel is honestly about as inefficient as it gets - I need live data.

Unfortunately, as I indicated, even free 3rd party plugins are not permitted.

--- Adam