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.
|Expression||MDX expression that typically returns a measure, a tuple, or a string.|
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.
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.
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.
- Add standard calculations based on a selected measure how to compare values between time periods
- Function VisibleRowsSet