Difference between revisions of "M4 Aggregates"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(2 intermediate revisions by 2 users not shown)
Line 10: Line 10:
<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>
--->
--->
Line 18: Line 18:
'''Filter by'''
'''Filter by'''


Filters allow to have 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>
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 Destination input then it will match all Destination numbers that start with 370. If you exclude % in Destination input then only exact number will be matched.<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 exact match.
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'''
'''Group by'''


Filtered statictics need to be grouped by either Originator, Origination Point, Terminator, Termination Point, Destination Group, Destination or any combination of these parameters. At least one Group by parameter needs to be selected.<br>
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 allows you to choose what information should be shown.
Other options allow you to choose what information should be shown.
* '''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.
* '''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, will be shown .
* '''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'''.  
* 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'''.  


Line 35: Line 35:


<br><br>
<br><br>
=Templates=
=Templates=



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