TOPAZ report: Call to a number exceeding 5 minutes

Moderator: Luanda_Junzi

TOPAZ report: Call to a number exceeding 5 minutes

Postby John Richard Procter » Mon Jun 27, 2011 8:49 pm

TOPAZ report: Call to a number exceeding 5 minutes more than twice by department

We can create a TOPAZ report listing the number of calls made
to a telephone number, with a duration more than 5 minutes,
for a department specified in a certain date range, sorted by
most dialed number for these specifications.

This report needs to be setup for each department individually.

Setup:
To create a new report, click on REPORTS > CUSTOM REPORTS
Click on the "+", now enter your report heading under Description,
example "Calls by Department (duration > 5 min)".

Code: Select all
   Report options         : tick "summary"
                            untick "include incoming"
                            untick "incoming calls only"
   Select records         : Between dates
   Summary Report Format  : Private vs Business
   Order by               : Calls
   Group by               : Number
   Maximum Records        : 0 
   Field Selection        : Select seconds,
                            Select >,
                            enter "300"
   Only Select These      : Select All_Branch_
                            Select the departement required, example SALES
                            Select All_Sections_
   Between Dates          : Select From Date
                            Select To Date


This report will show all calls made by the department within the
date range having a duration longer than 5 minutes. Therefore also
including calls made to a phone number once and twice within the
date range.

To limit the report you can change "maximum records" to for example "25".
This will only show the top 25 most dialed numbers with a duration
more than 5 minutes by department.
John Richard Procter
 
Posts: 552
Joined: Tue May 03, 2011 2:02 pm

Return to Support Archive's (TOPAZ)

Who is online

Users browsing this forum: No registered users and 1 guest