- 1 Minute to read
- Print
- DarkLight
- PDF
2dzdelta0
- 1 Minute to read
- Print
- DarkLight
- PDF
2dzdelta0
Returns the difference between the current row and previous row for the specified measure, resetting each time dimension 1 changes
Requires 2 dimensions (2d)
If only 1 dimensions specified, will always return Current Row (RowX)
Calculates difference between rows (delta)
Resets to Current Row (RowX) each time dimension 1 changes (0)
Purpose
Use this function to:
- Calculate monthly change in sales, resetting at start of each year.
Calculation
2dzdelta0 = RowX - Row(X-1)
RowX = value for current row
Row(X-1) = value for previous row
2ddelta0 = RowX - Row(X-1)
Sample Result
Parameters
Parameter | Description |
---|---|
Dimensions | Discrete field(s). All fields must come from the same table. |
Name | Name to be displayed as Column Header in result grid |
Measure | The field to be used in the post-function calculation.
|
Function | COUNT / SUM / AVG / MIN / MAX / STDEV |
Post | 2dzdelta0 |
Value | Optional. Filter to apply when evaluating FUNCTION. Only records in the Filter Recordset will be included in the Function and Post-Function calculations. Must come from same table as DIMENSION/MEASURE or be linked to the Dimension table. |
Axis | 0 / 1. Y-Axis to use when plotting graph. Default = 0 |
Plot | Y / N. Specifies whether measure’s output column should be plotted on graph. Default = Y |
Resolve | Optional. Resolve level for the measure. If blank, Resolve = Dimension Table |
Series Type | Default / Bar / Stacked Bar / Line / Spline / RangeLow / RangeHigh / CSLow / CSHigh / CSOpen / CSClose Determines the graph style for the measure. |
Popup | Default / None / Extended |
Prefix | $ / £ / E / % |
Usage Notes
Row order is important when working with deltas. Set row order using Ascending / Descending Value/Labels
2dzdelta0 is the same as 2ddelta0 except that if the delta returns a null, zdelta will return 0.00
Use 2dzdelta if null values need to be treated as if they were zeros.
Example
NOTE: Measure 1 is included purely for illustration. It is not necessary to include this measure for the calculation to work.
Example use: Changes in sales, for product, by group
Dimension: [transactions].[product_group], [transactions].[productid]
Measure 1
| Measure 2
|