Hello, I would like to ask for help with optimization for one of my reports.
The source data for account is narrowed down by JQL in Source Data config like this:
resolutiondate >= ‘2021/01/01’ AND type = “JIRA SD Service Request”
In Pages - for my report I created calculated member for Issue dimension(to display only issues resolved without specific link type) like this
Sum(
Filter(
[Issue].[Issue].Members,
IsEmpty([Issue].CurrentHyerarchyMember.Get(‘Implementing JIRA inward’))
)
)
In pages I’m also using dimensions - Time (only Current month), Project (bookmark for one particular Jira project)
In Columns I have Measures and custom calculated member to get avg time to resolve calculated from Time to SLA custom field:
[Measures].[TTS - REQ - SLA SD Elapsed Duration resolved] / [Measures].[Issues resolved]
In Rows I have it sorted by Customer request type (All hierarchy level members)
NOW I need to narrow the results more by the Resolution type - I would like to exclude issues with resolution ‘Canceled’. I added Resolution dimension to Pages and created new calculated member using Except:
Aggregate(
Except(
[Resolution].[Resolution].Members,
{[Resolution].[Canceled]}
)
)
But with this, the report is taking too much time to load and ending up with error
(once is timeout and other time memory overload). Is there any better way how to achieve this please?