Difference between revisions of "M4 Aggregates"

From Kolmisoft Wiki
Jump to navigationJump to search
(Created page with '=Description= Aggregate statistics provide brief information about Terminators and Originators, ASR, ACD. =Usage= Go to '''REPORTS –> Aggregate''' <br><br> '…')
 
 
(23 intermediate revisions by 7 users not shown)
Line 1: Line 1:
=Description=
=Description=


Aggregate statistics provide brief information about Terminators and Originators, [[ASR/ACD | ASR, ACD]].  
Aggregate statistics provide brief information about Terminators and Originators, [[ASR/ACD | ASR, ACD]].
<br><br>
[[File:Aggregatesm2.png]]


=Usage=
=Usage=
Line 7: Line 9:
Go to '''REPORTS –> Aggregate'''  
Go to '''REPORTS –> Aggregate'''  
<br><br>
<br><br>
'''ASR''' will have yellow background if it's value will be between 10% and 20%. Red background if value is between 0% and 10%.
<!---
'''ASR''' will have yellow background if its value will be between 10% and 20%. Red background if the value is between 0% and 10%.


'''ACD''' will have yellow background if it's value will be between 2:00 and 3:00. Red background if value is between 0:00 and 2:00.
'''ACD''' will have yellow background if its value will be between 2:00 and 3:00. Red background if the value is between 0:00 and 2:00.
<br><br>
<br><br>
In search filter you can choose time period, which originator and/or terminator you want to see. Also you can search statistics by Prefix or Destination Group. Search by Destination Group works with wild card %. For example, you can type in the beginning of the Country and press search. You will get results for all the countries that begin with the specified text.  
--->
 
'''Filter by'''
 
Filters allow having more specific data. You can filter data by specific Date, Originator (User), Origination Point, Terminator (User), Termination Point, Duration, CallerID (number part of CallerID), Destination (number), or Destination Group.<br><br>
Destination and Destination Group filters support wildcard %. For example, if you enter 370% in the Destination input then it will match all Destination numbers that start with 370. If you exclude % in Destination input then only the exact number will be matched.<br>
Destination Group input works in the same way - if you want to match Destination Groups by wildcard then you can use %. For example, if you enter Lithuania% then Destination Groups like Lithuania, Lithuania Mob, Lithuania Fix, etc., will be matched. Exclude % wildcard if you want an exact match.
 
'''Group by'''
 
Filtered statistics need to be grouped by either Date, Date/Hour, Originator, Origination Point, Terminator, Termination Point, Source Prefix, Destination Group, Destination/Prefix, Manager, OP Rate, TP Rate, Hangup Cause or any combination of these parameters. At least one Group by parameter needs to be selected.<br>
 
 
Other options allow you to choose what information should be shown.
* '''From User perspective''' – allows you to see real Calls situation from a User perspective. It is useful if your [[LCR|LCRs]] have more than one [[Providers | Provider]]. If some of the Providers in LCR are not reachable for one Call from a User, you will get fewer Calls that are recorded in the database.
* '''Use Real Billsec''' – check this option to show real Billsec instead of Duration of Call, which will be shown.
* You are able to decide if '''Price''', '''Billed Time''' should be shown for '''Originator''' and/or '''Terminator''' and other fields like '''Duration''', '''Answered Calls''', '''Total Calls''', '''ACD''', '''ASR''', '''Profit'''.  
 
'''[[Hide_Users | Hidden users]]''' will not be shown in Originator and Terminator dropdowns, but when Any is selected, hidden users will be displayed in search results.
 
<br><br>
 
=Templates=
 
Go to '''REPORTS –> Aggregate –> Templates'''
<br><br>
<br><br>
Other options allows you to choose what information should be shown.
Here you are able to set up your template.
* '''From User perspective''' – allows you to see real Calls situation and from User perspective. It is useful if your [[LCR|LCRs]] have more than one [[Providers | Provider]]. If some of the Providers in LCR are not reachable for one Call of User, you will get fewer Calls which are recorded in database.
* '''Use Real Billsec''' – check this option to show real Billsec instead of Duration of Call, will be shown .
* You are able to decide if '''Price''', '''Billed Time''' should be shown for '''Originator''' and/or '''Terminator''' and other fields like '''Duration''', '''Answered Calls''', '''Total Calls''', '''ACD''', '''ASR'''.  
<br><br>
<br><br>
[[File:M2_Aggregate_template_create.png]]
<br><br>
=Auto Export=
Detailed explanation here: [[M4 Aggregates Auto Export | Aggregates Auto Export]]

Latest revision as of 12:33, 11 May 2023

Description

Aggregate statistics provide brief information about Terminators and Originators, ASR, ACD.

Aggregatesm2.png

Usage

Go to REPORTS –> Aggregate

Filter by

Filters allow having more specific data. You can filter data by specific Date, Originator (User), Origination Point, Terminator (User), Termination Point, Duration, CallerID (number part of CallerID), Destination (number), or Destination Group.

Destination and Destination Group filters support wildcard %. For example, if you enter 370% in the Destination input then it will match all Destination numbers that start with 370. If you exclude % in Destination input then only the exact number will be matched.
Destination Group input works in the same way - if you want to match Destination Groups by wildcard then you can use %. For example, if you enter Lithuania% then Destination Groups like Lithuania, Lithuania Mob, Lithuania Fix, etc., will be matched. Exclude % wildcard if you want an exact match.

Group by

Filtered statistics need to be grouped by either Date, Date/Hour, Originator, Origination Point, Terminator, Termination Point, Source Prefix, Destination Group, Destination/Prefix, Manager, OP Rate, TP Rate, Hangup Cause or any combination of these parameters. At least one Group by parameter needs to be selected.


Other options allow you to choose what information should be shown.

  • From User perspective – allows you to see real Calls situation from a User perspective. It is useful if your LCRs have more than one Provider. If some of the Providers in LCR are not reachable for one Call from a User, you will get fewer Calls that are recorded in the database.
  • Use Real Billsec – check this option to show real Billsec instead of Duration of Call, which will be shown.
  • You are able to decide if Price, Billed Time should be shown for Originator and/or Terminator and other fields like Duration, Answered Calls, Total Calls, ACD, ASR, Profit.

Hidden users will not be shown in Originator and Terminator dropdowns, but when Any is selected, hidden users will be displayed in search results.



Templates

Go to REPORTS –> Aggregate –> Templates

Here you are able to set up your template.

M2 Aggregate template create.png

Auto Export

Detailed explanation here: Aggregates Auto Export