< Back to Help

has decreased by more than x between each of last n results

has decreased by more than x between each of last n results is used to detect cases in which the values for an attribute have a decreasing trend. The condition will be true for a case if the current sample value is a number and, amongst the previous n numerical samples, each is smaller than the previous by more than x. The change can be expressed in either absolute or percentage terms.

For example, given the following case fragment:

           01 Jun 03    20 Jun 03    30 Jun 03    15 Oct 03    02 Nov 03
ABC           2.3          2.0          1.8          1.6          1.3
DEF                        5.1          4.0                       2.9
GHI           13.1         11.5         10.1                      9.0

ABC has decreased by more than .1 between each of last 5 results

DEF has decreased by more than 1.0 between each of last 3 results

GHI has decreased by more than 10 percent
between each of last 4 results