Overdue Duration

Questions & Answers
1

Overdue Duration in (Days: Hrs: Mins) = Current Date Time (now) - Planned End Date Time

2

Hi @Bhargaviapple,

With the Issue dimension “Issue” level members in report rows, you can define a new calculated measure with the formula similar to the one below:

CASE WHEN
  -- check if issue overdue
  DateCompare(
    [Measures].[Issue due date],
    'today'
  ) < 0
THEN
  -- calculate overdue duartion in minutes
  DateDiffMinutes(
    [Measures].[Issue due date],
    Now()
  )
END

Use one of the duration formattings with minutes at its base. Please see more details on defining calculated measures and updating their formatting here - Calculated measures. The report could look similar to the one below:

Screenshot 2024-12-12 at 14.14.34
Screenshot 2024-12-12 at 14.14.341552×1286 132 KB

Best,
Roberts // support@eazybi.com