Reporting advice

[Stu]

Hi,

I have a custom issue type called 'Engagement' which is based on an epic.  There are about 50 of these in my instance of Jira.  In my engagement issue type there are 4 custom fields:

A. multi-select 

b. checkbox select 

c. multi-select

d. multi-select 

I want a report that can show for a given period of time, how many Engagements had

a,b,c,d selected.  I would like this be done graphically if possible and also with a table. 

I know I will have to create a filter for what I want to report on. How do a get a report from that filter?

Thanks

[Javi · Accepted solution]

Hi Stu,

Generating reports based on custom fields is very limited within Jira natively. However, I recommend taking a look at the following add-on: eazyBI

This add-on allows you to generate custom reports based on Jira fields which includes custom fields. I recommend checking out their documentation for more information regarding this add-on

As for other add-ons that provide similar functionality, you can also check out Arsenale Dataplane.

Regards,
Javier A.

[Stu]

@Javi thanks mate, I'll check it out.

[Pablo Beltran · Accepted solution]

We provide two solutions for this:

A) Build your own solution from the scratch:

On one hand, the SQL for Jira Driver allows you to access to any custom field and it also supports the custom field types mentioned, so you can read the data from Jira.

On the other hand, Eclipse BIRT for Jira supports charts and tables as well as aggregations to visualize those data.

B) The Analytics Client - Business Intelligence app supports those measures and displays the results on a pivot table that can be converted into charts too (bar, pie, etc). This is the quickest way to get the results, but you have less control over the visualization.

[Sami Linnanvuo _Screenful_ · Accepted solution]

Hi Stu,

Screenful add-on can create reports and visualisations from custom fields out-of-the-box. You can see some sample visualisations here and learn more the custom fields support from the documentation. 

Best,

Sami