All eazyBI for Jira eazyBI for Confluence Private eazyBI

PreviousRowValue

EAZYBI Returns the measure value of the preceding row (row above). The value is recalculated every time when changing visible row order by drilling into some dimension, ordering rows by measure, removing a row, changing the dimension on report rows, or other interactions with the report that change the visible row set.

Syntax

PreviousRowValue(<Expression>)

Arguments

ExpressionMDX expression that typically returns a measure, a tuple, or a string.

Examples

For example, you may use PreviousRowValue() to see the delta of current and previous (above) row values. This works well if report rows are ordered to represent a specific workflow. This example shows changes in the measure "Hours spent" between the current row and the row above.

PreviousRowValue([Measures].[Hours spent])
- [Measures].[Hours spent]

The following formula calculates duration in minutes from one issue creation till the next issue creation for issues visible in reports. Descending issue order by creation date is important for this measure to work as expected.

DateDiffMinutes(
  [Issue].CurrentHierarchyMember.GetDate('Created at'),
  PreviousRowValue([Issue].CurrentHierarchyMember.GetDate('Created at'))
  )

See report example Blocker issues (detailed list) in our Service Management Demo account.  The calculated report specific measure Time till next blocker incident uses the formula above. 


See also