Custom SLA between created vs resolved date

Hello,

We have a requirement to show the reporting for each SLA for subtask.

This report is based on created date vs resolved date.

For example:
Subtask1 as (7days of SLA)
Subtask2 as (2days of SLA)

Now subtask 7days should be calculated from created date to resolved date.

Lets assume a user created a issue on July2nd and he resolved the same issue by 16July

In this condition the SLA is not met and we need to report show that it is not in Ontime/Delayed with some color indication.

How do we achieve this?

Hi @jranjan,

You can use the Issue dimension “Issue” level members in the report rows, filtered by the particular issue type with the Issue Type dimension in the report pages. Then select the measure “Average resolution days”. This measure will return the total resolution days for individual issues.

Then, you can use the cell formatting to highlight issues that were resolved past a certain threshold - Conditional cell formatting.

The report could look similar to the one below:

Best,
Roberts // support@eazybi.com