All eazyBI for Jira eazyBI for Confluence Private eazyBI
All eazyBI for Jira eazyBI for Confluence Private eazyBI

DateAddWorkdays

EAZYBI Returns date plus specified number of workdays.

Syntax

DateAddWorkdays(date, days)
DateAddWorkdays(date, days, nonworkdays)

Arguments

dateDate expression.
days

Integer expression for number of working days to add.

By default Saturdays and Sundays are considered as non-working days.

nonworkdays

Specify string with non-working day numbers (use 1 for Monday, 2 fort Tuesday, 3 for Wednesday, 4 for Thursday, 5 for Friday, 6 for Saturday, 7 for Sunday).

If not specified then '67' is used which means Saturday and Sunday.

If Time dimension options are specified then these Time dimension non-working days will be used (in this case please do not specify this argument).

Examples

DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5)

DateAddWorkdays([Issue].CurrentMember.get('Created at'), 5, '67')

The example below calculates predicted date to complete unresolved issues based on recent progress in the project

  DateAddWorkDays("Today", 
  -- remaining scope
  ([Measures].[Issues due],
   [Time].CurrentHierarchy.Defaultmember)
    /  
  -- average resolved issues per week in last 52 weeks
  AVG(
	{[Time.Weekly].[Week].CurrentDateMember.Lag(52):
	 [Time.Weekly].[Week].CurrentDateMember.PrevMember},
	 CoalesceEmpty(
	 ([Measures].[Issues resolved],
	  [Time].DefaultMember),
	  0)
  ) 
  * 5  -- workdays in week 
)

See report example Predicted completion date in our Demo account. The calculated measure Rolling predicted date uses the formula above to calculate a date in how many days from today unresolved issues will be resolved if the progress will be similar to the last 52 weeks and no new issues will come in. Remaining scope / average pace per week gives a count of predicted weeks. They are multiplied by 5 workdays per week to get total predicted workdays that could be added from Today.

See also