Layton ServiceDesk - Reporting - Creating Charts

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Added link to next article)
m (Implemented new "Previous Article" link)
Line 1: Line 1:
 
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p>
== Creating a Pie or Column Chart ==
+
<p align="right">[[File:btn_back_up.png|link=Layton ServiceDesk™ - Creating New Reports]] [[Layton ServiceDesk™ - Creating New Reports |<u>Previous article in this series: ''Creating New Reports''</u>]]</p>
 +
__FORCETOC__
 +
=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.
 
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.
Line 33: Line 35:
  
  
<center>[[File:Screenshot5.png]]
+
[[File:Screenshot5.png|center|link=]]
<br/>
+
</center>
+
<br/>
+
  
 +
=Creating a Trend Chart=
 +
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.
  
=== Creating a Trend Chart ===
 
 
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.
 
<br/><br/>
 
 
{| class="wikitable" border="0"
 
{| class="wikitable" border="0"
 
! width="100" |Report On
 
! width="100" |Report On

Revision as of 01:58, 7 July 2015

Btn back up.png Back to Contents

Btn back up.png Previous article in this series: Creating New Reports

Contents

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.


Screenshot5.png

Creating a Trend Chart

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


Unlike the Pie & Column charts the Trend Chart has a “No Grouping” option available for the Group By selection. If No Grouping is selected there will be a single trend line or bar based on the trend field.

As Trends are linear timelines the list of available trend fields are the date type fields within the master table. The most commonly used trend fields would be the Request Date (sys_requestdate), Problem Date (sys_problemdate) etc.

The Time Period is the interval been each data series and the options available are Day, Week, Month, Quarter and Year.

There are additional options to select whether the trend chart will be a Line or Bar chart and whether the orientation is vertical or horizontal.

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

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 of the report can be modified by selecting the design layout button next to the report in the report category list. See below for details on the design layout.


Screenshot6.png

Creating Charts

Proceed to Report Design Layout & Extra Functions.

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox