Hi @strojna.ewa ,
One approach could be dividing the “TTR duration” value by the number of resolved issues. That could return wrong values if some of the resolved issues don’t have the SLA. Having the SLA imported as a dimension could address that. Then you can divide the duration by the number of resolved issues with this SLA.
Another approach could use the Avg() function, which evaluates the SLA duration over the number of issues with this SLA. Unfortunately, that requires iterating through issues with the Descendants() function, which can slow down the report. See an example below:
The conditions inside the Filter() function may require fine-tuning to improve the report performance.
See the eazyBI documentation page for more details on the Avg() function - Avg - eazyBI.
Roberts // email@example.com