Need support to build report

[PLaksh11]

Hello Team,

We need to build the below report.

Track average service duration by provider and measure % of calibrations completed on or before due date.

Currently we have 3 Fields in the jira ticket.

1. Service Provider (Single line Text field)

2. Calibration Due date (Date field)

3. Return-to-Service Confirmation(Date field)-  calibration completed Date

Using above three fields we need to build report.

If the Return to Service Date is on or before the Due Date, the service is considered acceptable and within the required timeline.

If the Return to Service Date is after the Due Date, the service is considered overdue and is not acceptable, as it exceeds the required timeline.

I need to bring report like below table.

Service Provider	Number of tickets	Service completed on time	Service delayed	Performance
ABC	10	7	3	70%
XYZ	6	3	3	50%
PQR	10	10	0	100%

[Marc -Devoteam-]

Hi @PLaksh11 

This is a BI related question. Jira reporting is not suited for BI reporting.

You could look at 3rd party apps to enhance your setup or to export relevant issue data into a BI reporting application or you the API for this.

[PLaksh11]

Hi @Marc -Devoteam-  Thanks for the update.

[Elita Kalāne - eazyBI Support]

Hi @PLaksh11 

Disclosure: I work for the eazyBI team.

If you are willing to try an Atlassian Marketplace app, check out eazyBI for Jira Cloud. 

eazyBI is a reporting and analytics app that lets you build a variety of reports, including what you're describing

Here is how you would set it up:

1.  Import your custom fields

• Service Provider (single-line text field) - configure it as a dimension in eazyBI custom field import options so you can group report rows by provider
•  Calibration Due Date and Return-to-Service Confirmation - import both as date type fields so their values are available for calculations

      2. Create 3 calculated measures and select one that is the standard (already imported) measure. 

 "Issues created" - standard measure that shows how many issues are created per Service provider

"Service completed on time" measure - a custom calculated measure that calculates the issues completed on time comparing the date fields

"Service delayed" measure - a custom calculated measure that looks for the difference between total issues created minus the ones completed on time

"Performance" - Percentage that shows how many issues were completed on time. 

This is how the report may look :

You can also display the results as charts or leave as a table report. 
If you're willing to try our app, you can reach to us directly at support@eazybi.com and we can help you with setting up your report. 

Best,

Elita from support@eazybi.com

[Habib__Plugio__]

Hi @PLaksh11 ,

I think Jira doesn't have ability to create a report like this.

If you prefer to use a third party plugin, you may check out our Multi-Dimensional Pivot Table plugin. 

It has ability to show multiple measures and conditional counting ability described as in your use case and it is completely FREE. 

-- Habib, Plugio

[Arkadiusz Wroblewski]

That @Marc -Devoteam-  

You can maybe play around with filters, and make something own with Excel but then you run into the problem Marc already mentioned.

Native Jira reports are usually fine for one or two field-based groupings, but once you need more complex reporting, they are not always reliable or flexible enough.

Best,

Arkadiusz🤠

[PLaksh11]

Hi @Arkadiusz Wroblewski 

Thanks for the Response.