Workdays Calculation

Questions & Answers
1

Hi all,

Using the default Average Workdays in transition status, and found that it seems to be including weekends - ie if it goes into status on Friday, then comes out on Monday, that is showing as 3 days.

Any ideas why?

CASE WHEN [Measures].[Transitions from status] > 0 THEN
  [Measures].[Workdays in transition status] /
  [Measures].[Transitions from status]
END
2

Hi @auto98,

The workdays from the measures “Workdays in transitions status” are taken from the Time dimension settings specified in the eazyBI import options - https://docs.eazybi.com/eazybijira/data-import/jira-issues-import#JiraIssuesImport-Timedimension.

Check the settings and see if you have the correct non-working days selected.

Best,
Roberts // suport@eazybi.com