...
Introduction
The Custom report is the most flexible of all reports and allows a wide range of options and filtering criteria to be selected, enabling you to search for very specific phone calls. The results are displayed as an itemised list, grouped by call type: All, Outbound, Answered, Missed, Internal and Tandem.
Screenshotmacro |
---|
Border | false |
---|
Shadow | false |
---|
URL | /download/attachments/7242115/custom_report_4.png |
---|
|
HTML |
---|
<h2>Introduction</h2>
<p>This is the most flexible (and often daunting) report. For those who feel
they want more information than is provided in the in-built reports,
you can specify exactly what search terms you want to look for,
including new additions such as CLI (Calling Line Identification) and
LCR (Least Cost Routed) calls.</p>
<h2>Running the report</h2>
<p>Click on the <img class="icon" src="http://www.tri-line.com/common/img/documentation/tim_professional/reports_button.png" /> function button, on the top right-hand side of the main application window to access the <span class="reference">Reports</span> screen.</p>
<p>From this screen, either double-click on the <span class="reference">Custom Report</span> in the reports list or highlight the <span class="reference">Custom Report</span> and press the <img class="icon" src="http://www.tri-line.com/common/img/documentation/tim_professional/run_now_button.png" /> button, as shown below:</p>
<img class="screenshot naked" src="http://www.tri-line.com/common/img/documentation/tim_professional/custom_report_1.png" alt="Custom Report" />
<p>The following <span class="reference">Report Selection Criteria</span> window appears:</p>
<img class="screenshot naked" src="http://www.tri-line.com/common/img/documentation/tim_professional/custom_report_2.png" alt="Custom Report" />
<h4>Select a report period</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/report_period.png" alt="Custom Report" />
<p>You need to select a time period for which you want the report to produce information for. You can select a pre-set period from the drop-down list, as shown above.</p>
<p>The default is set to <span class="keyword">Last Month</span> (the period from the first day to the last day of the previous calendar month, and NOT the last 30 days).</p>
<h4>Or enter your own custom period</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/custom_period.png" alt="Custom Report" />
<p>If you want to specify a period not shown in the list, go back to the <span class="reference">Select a report period</span> field and select <span class="keyword">Custom
Period</span> from the drop-down list and then enter your <span class="reference">Start</span> and <span class="reference">End</span> dates and times manually
into the boxes provided, as shown above.</p>
<h4>Choose a site</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/choose_site.png" alt="Custom Report" />
<p>If your system is set-up for multiple sites, you have the option of
selecting a particular site here. Select the blank line (or leave
the box empty) to report on all of your sites.</p>
<h4>Select a type of call</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/call_types_custom_report.png" alt="Custom Report" />
<p>You can report on certain types of calls. You can do this by selecting them from the drop-down list, which is provided.</p>
<p>If this is left blank all types of calls will be reported on.</p>
<h4>Specify an extension range</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/specify_extension_custom_report.png" alt="Custom Report" />
<p>You can report on more than one extension number. In the field provided
you need to enter the number(s) of extensions you want to report on.</p>
<h4>Choose an extension group</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/choose_extension_group.png" alt="Custom Report" />
<p>This is an optional feature, you can specify an extension group which is
provided from the drop down list or simply leave it blank and it will
do all the extension groups that have been set-up on TIM.</p>
<h4>Specify a trunk range</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/trunk_range.png" alt="Custom Report" />
<p>You can report on more than one trunk number. In the fields provided
you need to enter the <span class="keyword">Number from - to</span>.
If you would like to report on an individual trunk in the
<span class="keyword">Number from</span> enter the trunk number and then enter the same
trunk number in the <span class="keyword">to</span> field.</p>
<h4>Choose a trunk group</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/trunk_group.png" alt="Custom Report" />
<p>You have the option of selecting a trunk group to run the report for.
You can do this by selecting the trunk group out of the drop-down
list, which is supplied.</p>
<h4>Specify a partial dialled number</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/specify_partial_number.png" alt="Custom Report" />
<p>You can search on partial or specific numbers. If you wanted to find out all
pagers, personal and mobile numbers that are being called you could
enter '07' in the field provided and when the report has been processed
you will get all the pagers, personal and mobile numbers.</p>
<h4>Specify a named destination</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/destination.png" alt="Custom Report" />
<p>You can search on partial or specific named location. If you wanted to find out all calls to London, you could enter 'London' in the field provided and when the report has been processed you will get all the calls to London regardless of the dialled number.</p>
<h4>Specify a call duration range (hh:mm:ss)</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/call_duration.png" alt="Custom Report" />
<p>You can report on calls between a certain call duration. In the fields supplied, enter the <span class="keyword">From duration - to</span> in hours, minutes and seconds (<span class="keyword">hh:mm:ss</span>).</p>
<h4>Specify a response time range (hh:mm:ss)</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/response_time.png" alt="Custom Report" />
<p>You can report on how quickly your incoming calls are answered by specifying the exact response time range here. In the boxes supplied, enter the <span class="keyword">From response- to</span> in hours, minutes and seconds (<span class="keyword">hh:mm:ss</span>).</p>
<h4>Select a call cost range</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/call_cost.png" alt="Custom Report" />
<p>You can report on calls above and under a certain cost. In the fields supplied you need to enter the <span class="keyword">Cost from - to</span>.</p>
<h4>Specify a partial Caller ID</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/caller_id.png" alt="Custom Report" />
<p>You can find out who is calling you organisation, you can do this by
inputting the calling number e.g. 02079207095 and it will show you
how many times they have called your organisation (this all depends
on your telephone system outputting the information). If you just
wanted to see how many calls you are receiving from Bristol then, all
you need to put in is the dial code, which would be 0117.</p>
<h4>Specify an account code</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/account_codes.png" alt="Custom Report" />
<p>You can report against a single account code or a range of account codes
by typing them in the box below. If entering more than one account
code, comma separate as follows 1147, 1153, 1178 etc.</p>
<h4>Select a field to order the results by</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/order_custom_report.png" alt="Custom Report" />
<p>This gives you the option to order the result by any field on the report. You can do this by choosing a selection from the drop-down list. If no sort field is selected, the results will be ordered by the date and time calls were introduced to the call database, which is not necessarily the same as selecting <span class="keyword">DateTime</span> from the field list. Therefore, if you want the results in order of date and time, you are advised to explicitly select <span class="keyword">DateTime</span> from the drop-down list.</p>
<h4>Sort Order</h4>
<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_professional/sort_order_custom_report.png" alt="Custom Report" />
<p>The default order in which the results are sorted is ascending - from
smallest value to highest value. You can select to view the results
in descending order by selecting this option here.</p>
<h2>Creating the Report</h2>
<p>When you have chosen a reporting period, and are happy with your selections, click on the <span class="button">Run Now</span> button.</p>
<h2>The results</h2>
<p>Because of the number of selection parameters available on Custom Reports,
the results can vary. The example below show outgoing calls to mobile
during a specific time period. Because outgoing calls only was
selected, there are no CLI's showing.</p>
<img class="screenshot naked" src="http://www.tri-line.com/common/img/documentation/tim_professional/custom_report_3.png" alt="Custom Report" />
<p>The header contains the date and time the report was generated, the
period the report covers, and an indicator for each of the report's
criteria that you selected, if any.</p>
<p>The report consists of a single table housing all of the calls that
matched your selection criteria. Each column of the table is
described here:</p>
<table class="confluenceTable">
<tbody>
<tr>
<th class="confluenceTh">Column header</th>
<th class="confluenceTh">Description</th>
</tr>
<tr>
<td class="confluenceTd"><b>Date & Time</b></td>
<td class="confluenceTd">Shows the date and time the call was started.</td>
</tr>
<tr>
<td class="confluenceTd"><b>Extension</b></td>
<td class="confluenceTd">The extension number (and the name of the extension in brackets).</td>
</tr>
<tr>
<td class="confluenceTd"><b>Destination</b></td>
<td class="confluenceTd">For outgoing calls, shows the destination of the call; for other calls, shows the type of call, e.g. unanswered, abandoned, internal, feature call.</td>
</tr>
<tr>
<td class="confluenceTd"><b>CLI</b></td>
<td class="confluenceTd">Shows the caller line identity of the incoming call.</td>
</tr>
<tr>
<td class="confluenceTd"><b>Dialled Number</b></td>
<td class="confluenceTd">Shows the number that was dialled, in the case of an outgoing or internal call.</td>
</tr>
<tr>
<td class="confluenceTd"><b>Trunk</b></td>
<td class="confluenceTd">The trunk that the call came in/went out on.</td>
</tr>
<tr>
<td class="confluenceTd"><b>Response</b></td>
<td class="confluenceTd"><p>The length of time it took to respond to the call.</td>
</tr>
<tr>
<td class="confluenceTd"><b>Duration</b></td>
<td class="confluenceTd">Shows the duration of the call in hours, minutes and seconds.</td>
</tr>
<tr>
<td class="confluenceTd"><b>Cost</b></td>
<td class="confluenceTd">Shows the cost of the call.</td>
</tr>
</tbody>
</table><a id="Running the report"></a> |
Running the report
Access the Reports screen, select the Custom Report from the list and click on the Run now button.
Screenshotmacro |
---|
Border | false |
---|
Shadow | false |
---|
URL | /download/attachments/7242115/custom_report_1.png |
---|
|
A new window will open, allowing you to configure the parameters of your report:
Screenshotmacro |
---|
Border | false |
---|
Shadow | false |
---|
URL | /download/attachments/7242115/custom_report_2.png |
---|
|
Select a report period
For each report, you must specify a time span that covers the calls you want the report to include.
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7241970/report_period.png |
---|
|
There are several preset reporting periods available for selection, based on the standard Gregorian calendar. The following table describes how the start and end times are defined for each preset period:
Period | Description |
---|
Today | The start and end dates are set to the current date. The start time is set to 00:00:00 and the end time to 23:59:59. |
Yesterday | The start and end dates are set to the current date minus one day. The start time is set to 00:00:00 and the end time to 23:59:59. |
This week | The start date is set to the first day (normally Monday) of the current week. The end date is set to the current day. The start time is set to 00:00:00 and the end time to the current time. |
Last week | The start date is set to the date of the last Monday, and the end date is set to the start date plus seven days. The start time is set to 00:00:00 and the end time to 23:59:59. |
This month | The start date is set to the first day of the current month. The end date is set to the current day. The start time is set to 00:00:00 and the end time to the current time. |
Last month | The start date for this period is set in three stages: The day is set to the first day of the month. The month is set to the previous month. The year is set to the current year, unless it is currently January, in which case, the previous year is used. The start and end times are set to 00:00:00 and 23:59:59 respectively. |
This year | The start date is set to the first day of the first month of the current year, whilst the end date is set to today's date. The start and end times are set to 00:00:00 and 23:59:59 respectively. |
All calls | The start and end dates and times are set to the dates and times of the first and last call in the entire call database, respectively. |
In addition to the presets described above, it is possible to specify a custom reporting period by choosing Custom period from the drop-down list and specifying your own Start and End dates, as shown below:
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7241970/custom_period.png |
---|
|
Choose a site
If your system is set up to log multiple sites, you can select a particular site from the drop-down list. To report on all sites, select the blank line.
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7241970/choose_site.png |
---|
|
Select a type of call
This option allows you to define the type of call you want to report on, in terms of where the call originated and where it was delivered, e.g. incoming, outgoing, internal, etc. To report on a specific type of call, select it from the drop-down list:
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/call_types_custom_report.png |
---|
|
Specify an extension range
You can choose to report on a single extension or a range of extensions, by entering the details in the box provided, as shown below:
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7241967/choose_extension.png |
---|
|
Choose an extension group
To monitor the call activity for a specific department, select the extension group you want to report on from the drop-down list. To report on all extension groups, select the blank line.
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7241970/choose_extension_group.png |
---|
|
Specify a trunk range
To report on more than one trunk number, enter the trunk range in the
and fields. To report on an individual trunk, enter the same trunk number in both fields. Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/trunk_range.png |
---|
|
Choose a specific trunk group
To run the report on a specific trunk group, select it from the drop-down list. To report on all trunks, select the blank line.
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7241967/trunk_group.png |
---|
|
Specify a partial dialled number
To report on a specific dialled number, enter the partial or full number in the field provided. For example, to report on all mobile calls enter
in the field, as shown below:
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/specify_partial_number.png |
---|
|
Specify a named destination
If you want to filter calls to a specific, known destination, type the full or partial name of the destination in the text box provided, e.g. enter
to report on all calls to London, regardless of the number that was dialled. Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/destination.png |
---|
|
Specify a call duration range
To filter calls within a particular duration, enter the desired duration in the
field in format. Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/call_duration.png |
---|
|
Specify a response time range
To monitor how quickly your incoming calls are answered, specify a response time range in the fields provided, in
format. Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/response_time.png |
---|
|
Select a call cost range
You can define a cost filter to include calls above or below specific values, by entering your criteria in the fields provided, as shown below:
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/call_cost.png |
---|
|
Specify a partial Caller ID
If the caller ID is outputted in the raw data, you can report on calls that originate from a specific phone number. For example, to report on all incoming calls from Tri-line, enter
. You can also enter a partial phone number; for example, to report on all calls received from Bristol, enter , the dial code of this location. Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/caller_id.png |
---|
|
Specify an account code
To produce a report consisting only of calls that were made using a particular account code, enter it in the field provided. To report on more than one account code, separate each entry with a comma, as shown below:
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/account_codes.png |
---|
|
Select a field to order the results by
By default, the report's results are ordered by cost. To sort the results by a different column, select it from the drop-down list.
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/order_custom_report.png |
---|
|
Sort order
By default the report's results are displayed in ascending order. If you want to display the results in descending order, tick the appropriate option.
Screenshotmacro |
---|
Border | false |
---|
URL | /download/attachments/7242115/sort_order_custom_report.png |
---|
|
HTML |
---|
<a id="Creating the report"></a> |
Creating the report
When you have selected a reporting period and have chosen the report's criteria, click on the Run now button, as shown below:
Screenshotmacro |
---|
Border | false |
---|
Shadow | false |
---|
URL | /download/attachments/7242115/custom_report_3.png |
---|
|
HTML |
---|
<a id="The report's results"></a> |
The report's results
Below is an example of this report's output, displayed as an itemised list.
Screenshotmacro |
---|
Border | false |
---|
Shadow | false |
---|
URL | /download/attachments/7242115/custom_report_4.png |
---|
|
The header of the report will display its title, any friendly name you assigned to it, the period of the report and any options you have selected in the report's selection criteria window.
The body of the report consists of a single table housing all calls that matched your selection criteria. Each column header of the table is described below:
Column header | Description |
---|
Date & Time | The date and time the call started |
Extension | The name or number of the extension that made or received the call |
Destination | The name of the destination where the call terminated, or a brief description of the type of call, for incoming ones |
CLI | The telephone number of the remote caller for inbound calls |
Dialled Number | The telephone number dialled, in the case of an outbound call |
Trunk | The number of the trunk carrying the call |
Response | The length of time it took for the call to be answered, e.g. the response time |
Duration | The duration of the call in hours, minutes and seconds |
Cost | The cost of the call, if applicable |