In the example Chart, "Work Orders Reported by Dept.", the SQL Statement and related fields can be entered as follows:
|
Chart Instructions |
Field |
Entered Value |
|---|---|---|
|
Field 1 must be the four-digit year. |
SQL Statement Text |
EXTRACT(YEAR FROM evt_reported) WOYear |
|
Field 2 must be the two-digit month. |
SQL Statement Text |
EXTRACT(MONTH FROM evt_reported) WOMonth |
|
Field 3 must be the Description of the code being grouped by. For example, if counting work orders by department, this field would be the description of the department. |
SQL Statement Text |
R5O7.O7GET_DESC('planguage', 'MRC', evt_mrc, '', '') WODeptDesc |
|
Field 4 must be the value being charted. Field 4 can be a number or monetary amount. |
SQL Statement Text |
COALESCE(COUNT(evt_code),0) WOCount |
|
The Group By Text field is used to give a label to the values being returned in Field 3. This label will be displayed next to a selection field on the Start Center screen. |
Group By Text |
Department |
|
The Value Type field is used to define Field 4 as either a number or a monetary amount. The only effect is the currency will be displayed on the hover text of the chart on the Start Center screen. |
Value Type |
Number |