Layton ServiceDesk - Reporting - Creating Charts

Creating a Pie or Column Chart

If a Pie or Column chart report type has been selected the “Available Fields” and “Selected Fields” windows will be removed as they are not applicable to these types of reports.

An additional option for the Pie and Column Charts will be to “Show Summary Grid”. A summary grid displays the same information that is represented in the Pie or Column chart in a grid format along with a grand total.

Select the Master Table from the drop down list. The drop down list will display all of the tables in the database. The most common reports will involve Requests, Problems, Changes & Tasks and the relevant master tables for these reports are listed below.

Report On	Master Table to Select
Requests	Request
Problems	Problem
Changes	Change
Tasks	Action

Select a “Grouped By” field from the drop down list. All of the data fields from the master table will be displayed in the drop down list.

The final step is to apply any filters to the report. Please see the Applying Filters section in the grid report section above.

Once the report has been completed click the save button and the report will be added to the list of reports in the selected category. After the report has been saved the design layout can be modified by selecting the design layout button next in the report category list. See below for details on the design layout.