Set up and update charts to display in the Start Center using SQL statements to define chart data.
To set up charts:
-
Select Administration > Start Center Setup > Chart Setup.
-
Click New Record.
-
Specify this information:
Chart Code - Enter a unique code identifying the chart, and then enter a description in the adjacent field.
Out of Service - Select to indicate the chart should not display in the Start Center.
SQL Statement - Enter the SQL statement which will define the chart data displayed.
Group By Text - Enter the type by which to group the chart data. For example, for a chart displaying open work orders, enter Department to display the open work orders by specific department.
Value Type - Select the value type for which the chart will display data. For example, select Number to display numerical representations of data in the chart.
Public - Select to indicate the chart should be available to all users in the Start Center.
-
Right-click on the form, and then select Group By Translations to view and edit the translations for Group By Text.
-
Click Save Record.