< Back to Help

has increased by more than x from each result to next

has increased by more than x from each result to next is used to detect cases in which the values for an attribute have an increasing trend. The condition will be true for a case if there are at least two numerical samples and all numerical samples show an increasing 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 an increasing 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.0          2.1          2.2          2.3          2.5
DEF           1.9                       4.0          6.3          
GHI           10.0         12.1                      13.4         14.8
JKL           100          98           94           101          108

ABC has increased by more than .09 from each result to next

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

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

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