Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML
<h2>Filter the results of the report</h2>

<p>You have already selected the report that you want to configure and the pop-up 
window that appears allows you to set the parameters of the report 
wizard. Click on the <span class="button">Next</span> button at the bottom right of 
the window, until you reach the <span class="reference">Filter the results of the 
report</span> screen. On this screen, you have the option of filtering out certain 
calls from your reports, by selecting the values of the parameters, ensuring that 
only specific calls appear in your report.</p>

<img class="screenshot" src="http://www.tri-line.com/common/img/documentation/tim_plus/report_filters.png" alt="Report filters" />

<p>Each filter is described in the table below. Alongside each filter there's also an Information icon 
<img class="icon" src="http://www.tri-line.com/common/img/documentation/tim_plus/info_button.png" /> 
which you can click on to see a help prompt describing that particular filter.</p>

<table class="confluenceTable">
	<tbody>
		<tr>
			<th class="confluenceTh" width=122>Filter</th>
			<th class="confluenceTh">Description</th>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Account code</b></td>
			<td class="confluenceTd">If you want to produce a bill consisting of all chargeable calls made using a particular account code, enter the account code in this filed. To report on more than one account 
			code, simply comma separate.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Call type</b></td>
			<td class="confluenceTd">This filter allows you to define the type of call you would like to report on. If you would like to report on all calls, leave at the default <span class="keyword">All calls</span>.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Carrier</b></td>
			<td class="confluenceTd">If you use more than one carrier, you can choose which carriers calls you would like to report on. 
			<p>To report on all calls from all carriers, leave at default.</p> 
			<p>If you only use one carrier, there will be no drop-down list available and no option to choose a different carrier.</p></td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>CLI</b></td>
			<td class="confluenceTd">The Caller Line Identification (CLI) is the number associated with the incoming call. This is sometimes withheld by the person making the call.
			<p>You may choose to report on calls from a particular CLI or from numbers beginning with a particular CLI by entering the number in here. To report on more than one CLI, simply comma separate.</p></td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Cost</b></td>
			<td class="confluenceTd">If you want to add a filter for call costs, select calls above (<span class="keyword">></span>) or below (<span class="keyword"><</span>) the cost you wish to define. 
			The value entered should be in your major denomination expressed as a fraction, e.g. GBP 0.04 equates to 4 pence.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Destination</b></td>
			<td class="confluenceTd">To filter calls to a specific named destination (e.g. a place name, or a destination added to your Locations list) enter it here. e.g. London.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Dialled number</b></td>
			<td class="confluenceTd">To filter calls to a specific number, type the number in the dialled number field.
			<p>For partial numbers, such as those to a particular area code, just enter the beginning of the number, e.g. <span class="keyword">0033</span> for calls to France, 
			<span class="keyword">0161</span> for calls to Manchester. To report on more than one dialled number, simply comma separate.</p></td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Duration</b></td>
			<td class="confluenceTd">To filter calls above or below a particular duration, select the appropriate 'Above' or 'Below' option, then enter the value to compare against, in seconds, in the filed alongside. 
			For example, to show only calls above 30 minutes long, you'd choose <span class="keyword">>1800</span>, since 30 x 60 seconds = 1800.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>LCR code</b></td>
			<td class="confluenceTd">If one or more of your PBX uses Least Cost Routing (LCR), you can filter by LCR code by entering the specific code in the LCR field.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Response</b></td>
			<td class="confluenceTd">This filter allows you to filter based on the response times to calls.
			<p>You have the option of filtering calls above or below a specific threshold.</p>
			<p>The figure you specify is measured in seconds.</p></td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Start time</b></td>
			<td class="confluenceTd">To filter calls based on the start time, specify it in the format HH:MM:SS e.g. 8 am would be expressed as <span class="keyword">08:00:00</span>.</td>
		</tr>
		<tr>
			<td class="confluenceTd"><b>Trunk access code</b></td>
			<td class="confluenceTd">If you use specific access codes (prefixes) to route calls through specific trunks (channels), you can filter those here by simply entering the code used.</td>
		</tr>
	</tbody>
</table>

<p>In the example below, the user wants to filter all inbound calls, that are long than 30 seconds and that happen between 9:00 a.m. and 5:30 p.m.</p>

<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_plus/report_filters_1.png" alt="Report filters" />

<h2>Run/Schedule the report</h2>

<p>To run/schedule the report without setting any further parameters, simply click on the <span class="button">Finish</span> button. To continue adding parameters, click on the <span class="button">Next</span> button, which 
will lead you to the <a href="Setting the report Options">Options</a> parameters.</p> 

Below is a list of all report filters available in TIM Plus, although not all filters are relevant to all reports:

Screenshotmacro
Borderfalse
URL/download/attachments/4817244/filter_general.png

Account code

To produce a report consisting only of calls that were made using a particular account code, enter the account code in the field provided. 

Reporting_filter
FilterAccount code
Value0140

To report on more than one account code, separate each code using a comma.

Call type

This filter allows you to select 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 all types of call, set this to All calls.

Reporting_filter
FilterCall type
ValueAll calls

Carrier

If you use more than one carrier, you can limit the results to include only calls that were made using a specific carrier.

Reporting_filter
FilterCarrier
ValueAll carriers

Info

If you use only one carrier, there will be no drop-down list available and no option to choose a carrier.

CLI

Calling Line Identification (CLI) is the telephone number of the remote caller in an incoming call scenario.

You can report on calls that originate from a specific CLI or those whose CLI matches a particular pattern of digits. For example, to report on all incoming calls from Tri-Line, you could enter 02072652600.

Reporting_filter
FilterCLI
Value02072652600

You can use the ! symbol to explicitly exclude a CLI from the report's results, and/or the

Referencemacro
Label*
 symbol as a wildcard in digit pattern matching.  For example, to exclude calls from Tri-Line, but include all others, you could use !020726526*. To report on more than one CLI, use a comma to separate each entry.

Cost

You can define a cost filter to include calls above or below specific values by entering your criteria, as shown below:

Reporting_filter
FilterCost
Value<2.00

You can specify a cost range by using the 

Referencemacro
Label-
 symbol; to specify limits, use the comparison operators, >, <, and 
Referencemacro
Label!
 .

Destination

If you want to filter calls to a specific, known destination, type the name of the destination in the text box provided. This filter accepts the ! and * symbols for excluding values and specifying partial matches, respectively.

For example, if you wanted to exclude all calls to France, you could enter

Keywordmacro
Label!France*
, as shown below:

Reporting_filter
FilterDestination
Value!France*

Dialled number

To filter calls to a specific dialled number, type it in the text box provided. The dialled number is defined as the number that is dialled (in the case of an outbound call), or the DDI number that the remote party dialled to reach a particular extension or group (in the case of an inbound call).

To filter calls to a specific area, a partial number can be entered (e.g. 0033 for calls to France).

Reporting_filter
FilterDialled number
Value0033

You can use the ! symbol to explicitly exclude a dialled number from the report's results, and/or the 

Referencemacro
Label*
 symbol as a wildcard in digit pattern matching.  For example, to exclude calls to Tri-Line, but include all others, you could use !020726526*). To report on more than one dialled number, use a comma to separate each entry.

Duration

To filter calls above or below a particular duration, enter the desired duration in seconds.

Reporting_filter
FilterDuration
Value>1800

You can specify a duration range by using the 

Referencemacro
Label-
 symbol; to specify limits, use the comparison operators, ><, and 
Referencemacro
Label!
 .

In the above example, the report will return only calls longer than 1800 seconds (30 minutes).

LCR code

To filter your results to include only calls that used a Least Cost Routing (LCR) code, enter it in the text box provided.

Reporting_filter
FilterLCR code
Value162

You can use the ! symbol to explicitly exclude a LCR code from the report's results, and/or the 

Referencemacro
Label*
 symbol as a wildcard in digit pattern matching.  For example, to exclude calls made using all LCR codes beginning
Referencemacro
Label162
, you could enter
Keywordmacro
Label!162*
To report on more than one LCR code, use a comma to separate each entry.

Response

This option allows you to filter calls based on their response time, measured in seconds. Specify the desired response time threshold in the text box provided.

Reporting_filter
FilterResponse time
Value>10

In the above example, the search results will display calls that have a response time greater than 10 seconds. 

You can specify a response time range by using the 

Referencemacro
Label-
 symbol and; to specify limits, use the comparison operators, ><, and 
Referencemacro
Label!
 .

Start time

This option allows you to filter calls based on the time the call started. Specify the start time in the text box provided using the hh:mm:ss format.

For example, to include only calls that began after 10 am, you could enter 10:00:00 in the Start time field, as shown below:

Reporting_filter
FilterStart time
Value10:00:00

Trunk access code

If your telephone system uses trunk access codes to connect calls using specific channels, you can limit your report's results to include only calls made using those codes. Specify the trunk access code in the text box provided.

Reporting_filter
FilterTrunk access code
Value9

You can use the ! symbol to explicitly exclude a trunk access code from the report's results, and/or the 

Referencemacro
Label*
 symbol as a wildcard in digit pattern matching. For example, to exclude calls made using the
Referencemacro
Label9
 trunk access code, you could enter 
Keywordmacro
Label!9
To report on more than one trunk access code, use a comma to separate each entry.

Run or schedule the report

To run or schedule the report without setting any further parameters, select the Finish button;  to apply further settings, click on the Next button, which will direct you to the Options section of the report wizard.