All eazyBI for Jira eazyBI for Confluence Private eazyBI

DateDiffMinutes

EAZYBI Returns the difference in minutes from the first date to the second date.

Syntax

DateDiffMinutes(From_Date_Expression, To_Date_Expression)

Arguments

From_Date_Expression

MDX expression that returns the first date of the calculation.

To_Date_Expression

MDX expression that returns the second date of the calculation.

Examples

Duration from issue creation till the first time its been assigned

Use the following formula for issues to see the exact duration it takes for an issue to be assigned after its creation.

Set the Formatting to Duration → ##d ##h ##m Days, hours, minutes to display the result in days, hours, and minutes.

DateDiffMinutes(
  [Measures].[Issue created date],
  TimestampToDate(
    (
      [Measures].[Transition to first timestamp],
      [Transition Field].[Assignee],
      [Time].CurrentHierarchy.DefaultMember
    )
  )
)

Duration over due date for overdue issues

Have the Issue dimension in Rows with Issue level selected and filter the report by (unresolved) issues. Use the following formula to identify overdue issues and calculate the overdue duration.

Set the Formatting to Duration → ##d ##h ##m Days, hours, minutes to display the result in days, hours, and minutes.

CASE WHEN
  NOT IsEmpty([Measures].[Issue due date])
  AND
  DateCompare(
    [Measures].[Issue due date],
    Now()
  ) < 0
THEN
  DateDiffMinutes(
    [Measures].[Issue due date],
    Now()
  )
END

See also