Apparatus and method for supplementing a data report with a highlighted exception trend
A method of processing data includes manipulating a data set to produce initial data results including an individual data value. The data set is compared to a data change function over a period of time to selectively identify trend data. Indicia of the trend data is superimposed on the individual data value so that the information associated with the individual data value representing a relatively short period of time can be understood in the context of a trend over a relatively long period of time.
1 . A computer readable memory to direct a computer to function in a specified manner, comprising:
a data manipulation module to process a data set and produce a data report; and
an exception processor including
a trend analysis module to compare said data set to a predetermined data change function over a specified period of time to selectively identify trend data, and
a presentation module to superimpose indicia corresponding to trend data onto data within said data report.
2 . The computer readable memory of claim 1 wherein said data is gathered from a first time period and said trend data is gathered from said specified period of time, which is longer than said first time period.
3 . The computer readable memory of claim 1 wherein said trend analysis module identifies when data in said data set is outside a predetermined value for said specified period of time.
4 . The computer readable memory of claim 1 wherein said trend analysis module produces said trend data even when a first trend in said data set is offset by a second trend in said data so as to minimize cumulative trend data.
5 . The computer readable memory of claim 1 wherein said trend analysis module produces trend data in the form of percentage magnitude values.
6 . The computer readable memory of claim 1 wherein said trend analysis module utilizes a linear trend data change function.
7 . The computer readable memory of claim 1 wherein said trend analysis module utilizes a compound trend data change function.
8 . The computer readable memory of claim 1 further comprising a graphical user interface to specify said predetermined data change function and said specified period of time.
9 . The computer readable memory of claim 1 wherein said presentation module produces a vector bar with the length of said vector bar corresponding to a magnitude value for said data and the shading of said vector bar providing indicia of said trend data.
10 . The computer readable memory of claim 1 further comprising a forecast module to produce forecast trend data, said presentation module superimposing indicia corresponding to said forecast trend data onto said data within said data report.
11 . A method of processing data, comprising:
manipulating a data set to produce initial data results including an individual data value;
comparing said data set to predetermined criteria to selectively identify trend data; and
superimposing indicia of said trend data onto said individual data value.
12 . The method of claim 11 wherein comparing includes comparing said data set to predetermined criteria including a data change function and a period of time.
13 . The method of claim 11 wherein said manipulating produces said individual data value corresponding to a first time period and said comparing selectively produces said trend data over a period of time longer than said first time period.
14 . The method of claim 11 wherein said comparing identifies when data in said data set is outside a predetermined value for a predetermined period of time.
15 . The method of claim 11 wherein said comparing identifies said trend data even when a first trend in said data set is offset by a second trend in said data set so as to minimize cumulative trend data.
16 . The method of claim 11 wherein said comparing includes producing trend data in the form of percentage magnitude values.
17 . The method of claim 11 wherein said comparing includes comparing said data set to a linear trend data change function.
18 . The method of claim 11 wherein said comparing includes comparing said data set to a compound trend data change function.
19 . The method of claim 1 1 further comprising receiving said predetermined criteria from a graphical user interface.
20 . The method of claim 11 further comprising displaying a vector bar with the length of said vector bar corresponding to a magnitude value for said data and the shading of said vector bar providing indicia of said trend data.
21 . The method of claim 11 further comprising:
producing forecast trend data from said data set; and
superimposing indicia of said trend data onto an individual data value of said data set.