< Back to Help

has decreased by more than x from each result to next

has decreased by more than x from each result to next 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 there are at least two numerical samples and all numerical samples show a decreasing trend, with the differences between successive numerical results greater
than a constant. Note that the latest episode need not be numerical. The change can be expressed in either absolute or percentage terms.

This function can be combined with a ‘within last’ clause to detect cases where there has been a decreasing trend in just the last few years, weeks or days.

For example, given the following case fragment,

           01 Jun 03    20 Jun 03    03 Sep 03    15 Oct 03    02 Nov 03
ABC           2.5          2.3          2.2          2.1          2.0
DEF           6.3                       4.0          1.9          
GHI           20.0         17.8                      16.0         14.1
JKL           98           100          98           91           85

ABC has decreased by more than 0.05 from each result to next

DEF has decreased by more than 2.0 from each result to next

GHI has decreased by more than 10 percent from each result to next

JKL within last 12 weeks has decreased by more than 5 from each result to next