2. Tracking Changed, New and Removed rows

The Track Changes function allows fetching a selection of New and/or Removed and/or Changed rows. Whenever you choose to include more than one Type of rows' alteration (for example, Changed+New, Changed+New+Removed, etc.), then each row in the Results set is going to be assigned with a respective lable in the Change Type column.

To compare values and track changes / updates in Last Two instances:

Switch to the Last Two Instances mode

The Track Changes option is now available for use

Define whether you want to see which rows have been changed / new / removed since the previous date by selecting the respective check boxes

For each field: specify the field (parameter) by which the comparison is going to be performed

Click Apply Changes to update the Results set

Results: Only those rows where the values defined during Step 4 have been changed / new / removed since collecting the prior instance are going to be shown.

4. Using Derived Fields when Comparing Instances

Derived fields include values that do not exist in a Data Source itself but are calculated from one or more existing numeric fields via basic arithmetic expressions and non-aggregate numeric functions.

4.1. [Option 1] Constructing Complex Formulas

When constructing a formula for a Derived field in the Last Two Instances mode, you can inlude the same field, but from current and prior instances.

Derived fields with formulas including current and prior values become UNAVAILABLE when switching to a Single Instance mode.

4.2. [Option 2] Using Derived fields when constructing Filters

Derived fields can also be used to construct filters. In this case they are treated the same way as regular fields if the formula contains only current values (The drop-down lists in filters section will include current and prior value options). See the picture below.

Alternatively, if the complex formula of a Derived field includes both current and prior values which are required for calculation (as shown in the picture above), the drop-down lists in filters section will include only current value option.