Calculating business hours cycle time in Jira using eazyBI

[omid sh]

Hi everyone,

I am using Jira Software with eazyBI and I want to calculate the cycle time of an issue (Story / Task) from To Do → Done.

The problem is that Jira/eazyBI calculates the full elapsed time (24/7), including nights and non-working hours.

What I need instead is to calculate only business hours, with the following rules:

• Working hours: 08:00 to 16:00
• Time should stop outside business hours and resume the next working day at 08:00 

Unfortunately, in our eazyBI instance:

• I do not have access to configure Business / Working Hours
• The function DateDiffWorkhours is not available

👉 Is there any way to calculate true business-hour cycle time using only MDX formulas in eazyBI, without Jira Service Management SLA or external scripting?if you have any suggestions please let me know.