Difference between revisions of "Aggregate"

From Kolmisoft Wiki
Jump to navigationJump to search
Line 15: Line 15:
[[File:Aggregate_statistics.png]]
[[File:Aggregate_statistics.png]]
<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%.
==Searching and grouping==


'''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.
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 Country.
<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.
By default all details are grouped fist by Country, then by Prefix, then goes Originator and lastly by Terminator. If one of them is selected as none, or prefix input is cleared, then details will be grouped by those which left selected in same row just without parameter selected as "none".  
<br>
 
Other options lets you choose what information should be shown, it can be grouped by Prefix or Direction.
You wan to see details by prefix, in search it is necessary to writhe at least "%" symbol.
* '''From User perspective''' – lets you see Calls situation for real and from User perspective. It is useful if your [[LCR|LCRs]] have more than one [[Providers | Provider]]. If some of Providers in LCR are not reachable for one Call of User you will get few Calls which are recorded in database.
* '''Use Real Billsec''' – check this option and instead of Duration of Call, will be shown real Billsec.
* You are able to decide does '''Customer''', '''Price''', '''Billed Time''' should be shown for '''Originator''' and/or '''Terminator'''.
* '''Destination''' – shows Prefix or Direction column, depends from, how you are grouping information of Calls.
<br><br>
<br><br>
==Available details==
Also search options allows you to choose what information should be shown:
* '''General'''
** '''From User perspective''' – lets you see Calls situation for real and from User perspective. It is useful if your [[LCR|LCRs]] have more than one [[Providers | Provider]]. If some of Providers in LCR are not reachable for one Call of User you will get few Calls which are recorded in database.
** '''Use Real Billsec''' – check this option and instead of Duration of Call, will be shown real Billsec.
** '''Show when Answered Calls >=''' – enter number to show records containing answered calls no less than the specified number.
* '''Show Columns'''
** You are able to decide does '''Price''', '''Billed Time''' of '''Originator''' and/or '''Terminator''' should be shown.
** Same with '''Duration''', '''Answered Calls''' and '''Total Calls''' amounts, '''ASR''','''ACD'''.


=Available details=
'''ASR''' will have yellow background if it's value will be between 10% and 20%. Red background if value is between 0% and 10%.<br>
'''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.


* If Destination is checked, the destination countries are shown in statistics sorted by prefix.
* If Orig. is checked, calls are additionally grouped by user.
* If Term. is checked, calls are additionally grouped by terminator.
* If Orig. Price is checked, show additional collum with originator price.
* If Term. Price is checked, show additional collum with terminator price.
* If Orig. Billed time is checked, show additional collum with originator billsec.
* If Term. Billed time is checked, show additional collum with terminator billsec.
* If Destination  is checked, show additional collum with Destination name.
* If Use Real Billsec is checked, real billsec instead billsec is shown in Duration column.
<br><br>
[[File:aggregate_statistics_options.png]]
<br><br>
* Group by prefix - calls are grouped by prefix.
* Group by direction - calls are grouped by destinations subcode. If Orig. and Term. are unchecked and Group by direction selected, calls are grouped by country.
<br><br>
[[File:Aggregate group 1.png]]
<br><br>
<!---This functionality is available from MOR X4--->
<!---This functionality is available from MOR X4--->
Finally you are able export results to CSV file.
Finally you are able export results to CSV file.
<br><br>
'''[[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>
<br><br>
=From Reseller PRO=
=From Reseller PRO=

Revision as of 16:18, 2 March 2015

Description

Aggregate statistics provide brief information about terminators and originators, ASR, ACD. Only calls routed via Terminators are included. Every call made from every user to every different terminator is in the statistic so there may be the same prefixes repeated if grouping by prefix is not selected.

NOTE: search by Admin is not available because Admin's function to make calls is deprecated.

Usage

Go to STATISTICS –> Calls –> Aggregate

Aggregate statistics path.png

Here you are able to see

Aggregate statistics.png

Searching and grouping

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 Country.

By default all details are grouped fist by Country, then by Prefix, then goes Originator and lastly by Terminator. If one of them is selected as none, or prefix input is cleared, then details will be grouped by those which left selected in same row just without parameter selected as "none".

You wan to see details by prefix, in search it is necessary to writhe at least "%" symbol.

Available details

Also search options allows you to choose what information should be shown:

  • General
    • From User perspective – lets you see Calls situation for real and from User perspective. It is useful if your LCRs have more than one Provider. If some of Providers in LCR are not reachable for one Call of User you will get few Calls which are recorded in database.
    • Use Real Billsec – check this option and instead of Duration of Call, will be shown real Billsec.
    • Show when Answered Calls >= – enter number to show records containing answered calls no less than the specified number.
  • Show Columns
    • You are able to decide does Price, Billed Time of Originator and/or Terminator should be shown.
    • Same with Duration, Answered Calls and Total Calls amounts, ASR,ACD.

ASR will have yellow background if it's value will be between 10% and 20%. Red background if 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.

Finally you are able export results to CSV file.

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

From Reseller PRO

Simple reseller is not able to view Aggregate statistics. Reseller PRO must have Providers assigned to Terminators.

See also

Retrieved from "https://wiki.kolmisoft.com/index.php?title=Aggregate&oldid=19010"