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.

[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.