Workday counted by issue created date

Hi eveyone!

I want to get a workday date by year. (2018, 2019)
But when we did 2018 and 2019 as Time,
It is counted based on the Transition change date, not the issue create date.
How do I change to the issue create date on that basis?

image

‘Workdays_issue’ is in Measure
==>
CASE WHEN
[Measures].[Transitions from status issues count]>0
THEN
[Measures].[Workdays in transition status]
END

Hi @bbyoo

I am not 100% sure I understood the requirement, but if you are trying to sum up all the workdays the issues created in the specific year have spent in all the statuses, please try the formula below:

  Sum(
    Filter(
      Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
      DateInPeriod(
        [Measures].[Issues created date],
        [Time].CurrentHierarchymember
      )
      AND
      [Measures].[Issues created]>0
    ),
  [Measures].[Workdays in transitions status]
  )

The formula above iterates through all the issues in the cube and filters out the ones that were created in the period of the current Time dimension member. Then all the workdays spent in those issues in that Time dimension period are summed up.

Let me know if I got it wrong or you have any questions.
Kind regards,
Roberts // eazyBI support