Calculating Current Assignee Duration in eazyBI Report

Questions & Answers
1

Hi eazyBI,

I’m looking to generate a report that includes the current assignee’s working days duration up to today, along with the historical “Workdays assigned” values from the change history.

As I understand, the default “Workdays assigned” measure captures only past assignee durations and does not include time spent by the current assignee unless reassigned.

Could you please advise the best approach or MDX pattern to calculate the ongoing duration for the current assignee and combine it with historical data in a single report?

Thanks

2

Hi @Kumar_T

Thanks for posting your question! It looks like you reached out to us directly as well.
I’m pasting the solution here as well, in case other eazyBI users may be looking for something similar

CASE WHEN
  [Assignee].CurrentHierarchyMember.Name = [Assignee].[User].getMemberNameByKey(
  [Issue].CurrentHierarchyMember.get('Assignee name')
)
THEN
  -- For current assignee: historical + current workdays
  [Measures].[Workdays assigned] +
  DateDiffWorkDays(
    TimestampToDate(
      ([Measures].[Transition to last timestamp],
       [Transition Field].[Assignee])
    ),
    Now()
  )
ELSE
  -- For past assignees: only historical workdays
  [Measures].[Workdays assigned]
END

How the measure works:
The formula checks if the assignee in the current row matches the issue’s current assignee
If it’s the current assignee: it adds historical workdays + ongoing workdays (from last assignment date to today)
If it’s a past assignee: it shows only the historical workdays from the “Workdays assigned” measure

Best wishes,

Elita from support@eazybi.com

1 Like