nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Eazybi Query execution timeout of 60 seconds reached

Ioannis Kouris

Hello,

I am trying to create a report in Eazybi with 2 calculated measures.

The first is already imported by Eazybi and it's called Issues with Event Log Time which counts the number of tickets with that field filled out.

The second measure is calculating the average time between the Event log time field and the ticket resolution date.

I have 3 dimensions in pages and 1 dimension in rows which is called Priority.

My problem is that i get the "Query execution timeout of 60 seconds reached" when i try to load the report with the Priority dimension expanded but it loads fine if it is not.

Is there a way to resolve this problem?

Thank you

Accepted answers

Lauma Cīrule

Hi @Ioannis Kouris,

Probably the problem is with the Avg calculation. Could you please provide the formula here or to support@eazybi.com?

Lauma / support@eazybi.com

All comments

Lauma Cīrule

Hi @Ioannis Kouris,

Probably the problem is with the Avg calculation. Could you please provide the formula here or to support@eazybi.com?

Lauma / support@eazybi.com

Ioannis Kouris

Hi Lauma,

Thanks for looking into this.

I was trying with 2 different formulas

1. AVG(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
NOT IsEmpty([Measures].[Issue Event Log Time])
),
CASE WHEN
[Measures].[Issues resolved] > 0
THEN
DateDiffMinutes([Measures].[Issue Event Log Time],
[Measures].[Issue resolution date]
)
END
)

2. AVG(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod([Issue].CurrentHierarchyMember.get('Resolved at'),
[Time].CurrentHierarchyMember) AND
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember) > 0
),
DateDiffMinutes(
[Measures].[Issue Event Log Time],
[Issue].CurrentHierarchyMember.get('Resolved at'))
)

Lauma Cīrule

Hi @Ioannis Kouris ,

Thanks for the follow-up! Unfortunately, the Descendants function can be resource costly if there are many issues in the cube. A custom calculation of minutes between the dates for resolved issues during the import might be the best solution; see more here https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/new-calculated-fields or contact support@eazybi.com if you need assistance with creating a JavaScript custom field for this case.

Still, there is one more thing you might try combining the first and second formula (filtering properties first has proven to be more efficient in some cases than filtering by measures):

Avg(
  Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
      [Issue].CurrentHierarchyMember.get('Resolved at'),
      [Time].CurrentHierarchyMember
    ) AND
    NOT IsEmpty([Measures].[Issue Event Log Time]) AND
    [Measures].[Issues resolved] > 0
  ),
  DateDiffMinutes(
    [Measures].[Issue Event Log Time],
    [Issue].CurrentHierarchyMember.get('Resolved at')
  )
)

Lauma / support@eazybi.com

Ioannis Kouris

Even if a bit late, thank you both for your support

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-cloud

eazybi

jira-service-management-cloud

jira-service-management