Custom Excel templates for FocalScope - response time summary
Friday, December 2, 2016 8:25 AM

The 'response time summary' template attached to this article is designed to show the average, minimum, and maximum response times per agent. This template can be used as a starting point for more elaborate custom reports. This article details how to upload, configure, and use the 'response time summary' template.

Be sure to download and extract Response time summary.zip file attached to this article; the Response time summary.xlsx template is contained inside the zip archive.

Prerequisites

Things to consider when configuring filtering for FocalScope reports

Tutorial

Creating and configuring a report for a new report

To use the 'response time summary' template, it needs to be associated with the correct parent report. Create the parent report as follows:

  1. Navigate to the [Shared Reports] folder
  2. Click the [Reports] tab (highlighted in red)
  3. In the right-hand pane, right-click and select [Add]

In the [Report form] window, configure the report as follows:

  1. Under the [General report information] section:
    1. Name - give the report a suitable, easily-identifiable name
    2. Template - select the [SLA conformation audit log]
    3. Cache expires - set the age (in hours or minutes) at which the report cache will expire and be wiped from the FocalScope server
    4. Excel template - leave this at the default setting until the 'response time summary' template is uploaded to the report
  2. Under the [Report parameters] section:
    1. Please note, add all [Report columns] by clicking the [>>] button (highlighted in blue in Figure 1)
    2. Please note, it is recommended that you enable the filters highlighted in Figure 2 when using the 'response time summary' template
    3. Configure the rest of the parameters as per your requirements (breakdown of report parameters and filters)
  3. [Optional] You can schedule the report for automatic dispatch to users in FocalScope
  4. Continued in next section...




Figure 1 - Creating a new report




Figure 2 - Recommended filter configuration

Uploading a custom template to a report

Proceed to uploading the Response time summary.xlsx file to the newly created report as follows:

  1. In the [Download report] window of the report, click the [Live Excel] button
  2. Click the [Browse] button (highlighted in red) and select the 'response time summary' template
  3. Wait for the yellow upload confirmation bar to appear
  4. Click the [Save] button (highlighted in blue) to associate the custom template with the report
  5. Ensure that [Response time summary] is selected in the [Pick a template from repository] list and click [Download report] to download the final report
  6. You can now set this template as the default for the report as per point 1.4 under the 'Creating and configuring a report' section at the start of this article




Figure 3 - Uploading a custom template to a report


Please note, if you intend to create custom templates based on the 'response time summary' one, download the attached Stub.zip file and use the Stub.html file contained in it to wipe the data from the custom template. This method will retain all filters set for pivot tables / charts in your custom template.

Additional Information



Attachments
Stub.zip
Response time summary.zip