Available on Cloud and starting from the eazyBI version 6.5.
|MDX expression that returns a date. Starting date, if it is a workday, will be included in the calculation.|
|MDX expression that returns a date. Date until which to count workdays; this day itself will not be included in calculation even if it is a workday.|
Specify a string with non-working day numbers (use 1 for Monday, 2 for Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday, and 7 for Sunday).
If Time dimension options are specified then you can use the argument 'default' to take into account these Time dimension non-working days.
|businesshours||Specify a string with business hours (start and end) in 24-h clock time or 12-h clock time.|
The following example returns a difference in workhours from the Issue created date until resolution if non-working days are Friday and Saturday and working hours are defined from 9 am to 5 pm (incl). That means if the event happened at 5:59 pm it would still be included.
- Function DateDiffDays which returns the number of days between two dates.
- Function DateDiffWorkdays which returns the number of workdays between two dates.