User Guide > Helpdesk and Service Automation > Reports - Helpdesk and Service Automation

Reports - Helpdesk and Service Automation

Tags:  

Reports - Helpdesk and Service Automation

Reports help to the track the performance of the helpdesk and service automation activities. You can take printouts of reports or can export to PDF/XLS/CSV file formats. The following actions can be done here.
To view the Scheduled reports that are created select Scheduled Reports from All requests box.

Generate Report from predefined report categories
Reports are grouped into various categories and the same are given below. Click on the report category to display the default reports available in that category. Then click on the desired report to generate the report. By default the current week's report will be generated. To generate reports for the desired period or to filter some parameters from being included in the report click on Refine Search button on the generated report page. You can also edit or delete the report. To edit click on Edit link and to delete click on Delete link available below the default report.
  • Account Reports
  • Reports by all requests
  • Reports by completed requests
  • Reports by overdue requests
  • Reports by pending requests
  • Summary Reports
  • Survey Reports
  • Timespent Reports
Edit Report
To edit a report follow the steps 5 to 14 provided for generating custom reports.

Delete Report
Default reports cannot be deleted. Reports that are generated and saved can only be deleted. Click on Delete link below the report to delete.

Generate Custom Reports
To generate custom reports click on New Custom Report link [Helpdesk and Service Automation-> Reports] and then
  1. Enter the Report Title.
  2. Select the report type as either Tabular Reports or Matrix Reports.
  3. Select the desired module for which the report should be generated.
  4. Then click on Proceed to Report Wizard button to configure the custom report.
  5. Select the Display Columns. In some reports this field will be replaced with Grouping.
    •  Display Columns
      1. Select the desired columns from Available columns box and move to Display columns box.
      2. If you want you can change the order of the columns in the Display columns box by selecting the desired column(s) and clicking on move up icon or move down icon .
    • Grouping
      1. Select either Simple to generate simple matrix report or Advanced tab to generate advanced matrix report.
      2. The select the desired values for the fields under the tab.
  6. Click on Next.
  7. Configure the filter options. The request that satisfy the rules will be not be considered while generating reports.
    1. Select the desired column and criteria.
    2. Click on the Choose button to add the values.
    3. Click on Add to Filter button to add this rule.
    4. Select either Match ALL of the following (AND) to filter if all the rules are satisfied or Match ANY of the following (OR) to filter if any of the rule is satisfied.
  8. Click on Next.
  9. Select the column to group from Group by box.
  10. Click on Next.
  11. Select the Summary type.
  12. Click on Next.
  13. Select the Chart type from the Chart type box and also the select the corresponding fields.
  14. Click on Run Report.
Generate Query Reports
This option helps you to generate reports based on the query you have entered to collect the data form the database. You can view the query that is used for collecting data and generating report from show query option (available on the report generated page). From there you can copy the query, modify it here and can customize it. To generate query reports click on New Query Report click and then
  1. Select the name of the module for getting Table Schema. The table schema contains information about, how to join the tables.It has different color code for different data type
  2. Click on Get.
  3. Enter the Query.
  4. Enter the Report Title.
  5. Logs will display the error messages if you provide any query.
  6. Click on Run Report.
Schedule Reports
This option allows you to schedule to generate reports and mail the same to the mentioned ID. To schedule reports click on New Scheduled Report link and then
  1. Select any on of the schedule type and configure the date and time.
    • Generate Once: Report will be generated only once on the selected date and time.
    • Daily Report: Report will be generated daily from the selected date onwards at the selected time.
    • Weekly Report: Report will be generated only on the selected day(s) in the week at the selected time. 
    • Generate Report: Report will be generated only on the selected date of the selected month(s) at the selected time.
  2.  Select the report to be scheduled from Report box. Note: If you are scheduling from Generated report page then this field will be selected accordingly by default.
  3. Enter the email ID to whom the report has to be sent in the To field.
  4. Enter the Subject and Message that has to be included while sending the message.
  5. Click on Save to save the scheduled report.
All the scheduled reports that are created will be listed under Scheduled reports page. You can also edit or delete scheduled reports by clicking on edit icon  or delete icon .

Generated Reports Page
The report that is generated will be displayed here. The generated report will contain the fields that are selected while generating the report. To select the desired field click on Edit link. If you have generated default report then the default fileds will be displayed. The following actions can be done here.
Refine Search
This option allows you to select the period for which you want to generate the report. You can also enable filters. To configure redefine search click on Redefine search or click on move down icon .
  1. Select the desired value in the Date Filter box.
  2. Select the desired period from During box or select the From and To date by selecting the appropriate radio buttons.
  3. Configure Advanced filtering.
    1. Select the desired column and criteria.
    2. Click on the Choose button to add the values.
    3. Click on Add to Filter button to add this rule.
    4. Select either Match ALL of the following (AND) to filter if all the rules are satisfied or Match ANY of the following (OR) to filter if any of the rule is satisfied.
  4. Click on Run Report to generate the report.
Save Report
This option helps you to save the save the report generated. To save a report click on Save Report as or Save Report link. Any one of the link will be displayed. Save Report as link will be displayed if you have generated default report. Save Report will be displayed if you have generated custom report. Then configure the following in the Save Report page.
  1. Enter the Report Name.
  2. Select either Every one to allow every one to view the report or Just me to allow only you to view the report.
  3. Select the Save-in Folder i.e., under the report category which you want to save the report. If not click on Add New Folder link, enter the new folder name and click on Add button to create a new folder to save the report.
  4. Enter the Description about the report.
  5. Click on Save.
View Query
This option enables you to view the query that is used to get the data from the database. To view the query click on Show Query link.

Export Report
You can export the report to PDF/XLS/CSV formats. Click on the respective links or logos to export.

View Graph
This option allows you to view the graph of the report. To view the graph click on Graph View link.

View Print Preview
This option allows you to view the Print preview inorder to take printouts. To view the print preview click on Print Preview link.
 





 RSS of this page

rtttrrb