Need support to build report

Question

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 ProviderNumber of ticketsService completed on timeService delayedPerformanceABC107370%XYZ63350%PQR10100100%

Elita Kalāne - eazyBI Support · Answer

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:

*  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__ · Answer

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

PLaksh11 · Answer

Hi @Arkadiusz Wroblewski

Thanks for the Response.