Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML
<p>The filters option allows you to add one or more filters to the report 
to allow you to sift through information in more detail. To add a 
filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<img class="screenshot border" src="http://www.tri-line.com/common/img/documentation/tim_enterprise/add_filter.png" alt="Add filter" />
Note

NOTE: You may add more than one filter to any report.

HTML
<h4>Account code</h4>

<p>If your telephone system provides the ability to add account codes, you 
may filter by entering the account code here. If more than one account 
code needs to be entered, simply comma separate.</p>

<p>The default option is to search for calls where there is an exact match 
for the account code entered i.e. <span class="reference">'equals'</span>, however you do have several 
other options as presented below:-</p>

<ul>
    <li><b>equals: </b>to find only exact matches</li>
    <li><b>is not equal to: </b>to excluding calls to a particular number or beginning with a particular sequence of numbers</li>
    <li><b>begins with: </b>to find calls to a particular location e.g. 00 for International</li>
    <li><b>does not begin with: </b>to exclude certain calls e.g. 07 for UK  mobile/personal</li>
    <li><b>ends with: </b>when you want to find calls to a specific DDI</li>
    <li><b>does not end with: </b>calls to everywhere except a specific number range</li>
    <li><b>contains: </b>to find a call where you only have a portion of the number</li>
    <li><b>does not contain: </b>to find a call where you need to exclude certain numbers or portions of numbers</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Carrier</h4>

<p>The carrier is the tariff table used to cost the call. You can choose to
 filter all calls by a particular carrier e.g. if you want to check a 
recent bill from that carrier. Alternatively, you may want to look at 
all calls not routed over a particular carrier. To do this, simply 
select from the above:-</p>

<ul>
	<li><b>equals: </b>calls equal to the value entered here</li>
	<li><b>is not equal to</b>calls not equal to the value here e.g. calls that were not free i.e. 0.00</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Cost</h4>

<p>The cost, if any, incurred by the call (shown in local currency). You can filter by cost to show calls:-</p>

<ul>
	<li><b>greater than: </b>all calls above the value entered here</li>
	<li><b>less than: </b>all calls below the value entered here</li>
	<li><b>equals: </b>calls equal to the value entered here</li>
	<li><b>is not equal to: </b>calls not equal to the value here e.g. calls that were not free i.e. 0.00</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Dialled number</h4>

<p>When filtering by dialled number, enter the number you want to filter by here, including any international prefixes.</p>

<ul>
    <li><b>equals: </b>to find only exact matches</li>
    <li><b>is not equal to: </b>to excluding calls to a particular number or beginning with a particular sequence of numbers</li>
    <li><b>begins with: </b>to find calls to a particular location e.g. 00 for International</li>
    <li><b>does not begin with: </b>to exclude certain calls e.g. 07 for UK  mobile/personal</li>
    <li><b>ends with: </b>when you want to find calls to a specific DDI</li>
    <li><b>does not end with: </b>calls to everywhere except a specific number range</li>
    <li><b>contains: </b>to find a call where you only have a portion of the number</li>
    <li><b>does not contain: </b>to find a call where you need to exclude certain numbers or portions of numbers</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>LCR Code</h4>

<p>If you use least cost routing, you can select the carrier you would like
 to report on here. Alternatively you can choose to exclude certain 
carriers.</p>

<ul>
    <li><b>equals: </b>to find only exact matches</li>
    <li><b>is not equal to: </b>to find any calls over alternative carriers</li>
    <li><b>begins with: </b>to find calls for a partial LCR code</li>
    <li><b>does not begin with: </b>to exclude calls over certain carriers</li>
    <li><b>ends with: </b>exclude LCR codes ending with specific digits</li>
    <li><b>does not end with: </b>where the LCR code does not end with specific digits</li>
    <li><b>contains: </b>to find call on an LCR where you only have a portion of the number</li>
    <li><b>does not contain: </b>to find a call on LCR excluding certain numbers or portions of numbers</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Start time</h4>

<p>Start time is defined as the exact time of day the call started, as 
output by your telephone system.  You may choose to filter for any of 
the following:-</p>

<ul>
    <li><b>is greater than: </b>filter for calls that started after this time e.g. after 18:00</li>
    <li><b>is less than: </b>filter for calls that started before this time e.g. before 07:00</li>
    <li><b>equals: </b>filter for calls that started at exactly this time</li>
    <li><b>is not equal to: </b>filter for calls outside a particular time</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Call Type</h4>

<p>This allows you to define the type of call you would like to report on.
 You can choose between the following:-</p>

<ul>
    <li><b>equals: </b>to find only exact matches</li>
    <li><b>is not equal to: </b>to exclude calls that don't match</li>
</ul>

<p>Then you can define the actual type of call. e.g. to see all abandoned 
DDI calls, choose <span class="reference">'equals'</span> and select <span class="reference">'Missed DDI only'</span> from drop-down list.  
This will show how many channels had 'missed' or 'abandoned' calls at any one time.</p>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>CLI</h4>

<p>The telephone number of the caller if presented known as CLI (Caller 
Line Identification). If you want to search for calls from a particular 
CLI or look for all calls excluding those from a specific CLI, filters 
should be used as follows:</p>

<ul>
    <li><b>equals: </b>to find only exact matches</li>
    <li><b>is not equal to: </b>to find every call except those from that CLI</li>
    <li><b>begins with: </b>to find calls that begin with similar CLI numbers</li>
    <li><b>does not begin with: </b>to exclude calls from specific CLI's</li>
    <li><b>ends with: </b>exclude CLI numbers ending with specific digits</li>
    <li><b>does not end with: </b>where the CLI does not end with specific digits</li>
    <li><b>contains: </b>to find call from a CLI where you only have a portion of the number</li>
    <li><b>does not contain: </b>to find a call from a CLI excluding certain numbers or portions of numbers</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Destination</h4>

<p>The 'destination' can most easily be defined as the B end of the call. 
It will change depending on the type of report being run. e.g. on an 
internal call, the destination will be the extension number or name of 
the person being dialled (if the extension number has been allocated a 
name). On an outgoing call the destination will be the name of the place
 being dialled e.g. USA, Leeds, Vodafone etc. If a location or mobile 
has been customised with an exact name, this will be shown e.g. Joe 
Bloggs mobile, ABC Corp LA office etc. This allows you to search for all
 calls except those to a specific destination.</p>

<ul>
    <li><b>equals: </b>to find only exact matches</li>
    <li><b>is not equal to: </b>to exclude calls that don't match</li>
	<li><b>begins with: </b>to find calls for a partial LCR code</li>
    <li><b>does not begin with: </b>to exclude calls over certain carriers</li>
    <li><b>ends with: </b>exclude LCR codes ending with specific digits</li>
    <li><b>does not end with: </b>where the LCR code does not end with specific digits</li>
    <li><b>contains: </b>to find call on an LCR where you only have a portion of the number</li>
    <li><b>does not contain: </b>to find a call on LCR excluding certain numbers or portions of numbers</li>	
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Duration</h4>

<p>You may want to filter calls based on the length of time spent on a call
 i.e. call duration. To do this, simply use filters as follows:</p>

<ul>
    <li><b>is greater than: </b>allows you to look for calls longer than the duration entered</li>
    <li><b>is less than: </b>allows you to look for calls shorter than the duration entered</li>
    <li><b>equals: </b>allows you to look for calls equal to the duration shown</li>
    <li><b>is not equal to: </b>allows you to look for any call that does not match the duration entered</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</p>

<h4>Response time</h4>

<p>This filter allows you to search and see how long it took for a call to 
be answered. The duration for response time is always in seconds. The 
filters should be used as follows:</p>

<ul>
    <li><b>is greater than: </b>allows to to search for calls where the response time is   longer than the number of seconds entered</li>
    <li><b>is less than: </b>allows you to search for calls where the response time is below  the number of seconds entered</li>
    <li><b>equals: </b>allows you to search for call where the response time equals that entered</li>
    <li><b>is not equal to: </b>allows to to search for calls where the response time differs to that entered</li>
</ul>

<h4>Trunk access code</h4>

<p>This filter allows you to search for calls that used a particular trunk 
access routing code. The filters should be sued as follows:</p>

<ul>
    <li><b>equals: </b>to find calls using only this trunk access code</li>
    <li><b>is not equal to: </b>to find every call that went out not using this trunk access code</li>
    <li><b>begins with: </b>to find calls that went out over a trunk access code that began with these digits</li>
    <li><b>does not begin with: </b>to find calls that went out over any trunk access code excuding those that began with the digits entered</li>
    <li><b>ends with: </b>find calls over any trunk access code ending with specific digits</li>
    <li><b>does not end with: </b>find calls over any trunk access code that does not end with specific digits</li>
    <li><b>contains: </b>to find calls over any trunk access code where you only have a portion of the number</li>
    <li><b>does not contain: </b>to find a call over any trunk access code which does not certain numbers or portions of numbers</li>
</ul>

<p>To add the filter, simply choose the relevant filter and press the <span class="button">Add</span> button to add to the report.</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.