The Analytics section is a powerful tool for gathering, manipulating, and displaying graphical and tabular data. You can view and modify a wide range of existing reports or create your own based on various data sources within the system as well as outside 3rd party systems. Data can also be run through Script Forge using processing techniques such as mapreduce and preProcess function.
You can create custom reports to help identify your own key metrics. Here are some examples of what our customers have built:
- Ticket Count - Integration with a 3rd party ticket system and display how many tickets a particular customer has open.
- FOREX - Display FOREX data on the dashboard
- 603 / 604 Block Report - Display the top CLI's that have been blocked per customer and per carrier.
- CLI Stats - Display stats per CLI
- ISO Code Stats - Display stats by Country ISO.
Create new Analytics¶
Click the to configure the following fields:
- Path: Select where the data will be displayed.
Customer- Management Customer Stats
Carrier- Management Carrier Stats
Dashboard- Dashboard Displayed at the bottom
Route- Management Customer Route Stats
Report- Management Report Reports
- Section: Allows you to group analytic components together when sharing the same name. This may often be collated together in the same tab.
- Title & Subtitle: Displays title and subtitle information on the rendered graph / table.
- Output: Select to render data in either Graph or Table, or both together.
- Graph Type: The following graph types are supported.
Line- 2 Axis of data, one can be temporal
Bar- 2 Axis of data, one can be temporal
Area- 2 Axis of data, one can be temporal
Pie- 1 Axis of data
Scatter- 2 Axis of data
Radar- 1 Axis of data
Gauge- 1 Axis of data
- Source: There are multiple sources of data which can be used:
Analytics- Big Data multi-vector querying. Note: Recalcs won't affect this data, and it never should be used for accurate financial data.
G3- Single value time-series data.
RTP- RTCP information.
Breakout- Financially Accurate data available with limited query vectors.
ScriptForge- Custom ScriptForge data source, can be used to combine other data sources or even import external data in real-time.
- Fields: What fields should be displayed in the Graph / Table. This changes per above data source.
- Start Offset: When there is NOT a data-selector on the page, the start offset will represent how far in the past the query will include.
- Interval: Select how the graph groups data.
Auto- Automatically choose an appropriate temporal resolution.
Collate- Collapse all the temporal data (ex: When selecting ACD, instead of having an axis for date/time, it will just display a single scalar value).
Time-based- Choose how to group the data (ex: Selecting Hour will display a unique value for each hour).
- Collate / Group: Choose how the data is to be grouped together. (Ex: Selecting "Customer" would mean that you would get a unique value for each customer.)
- Limit: How much collated data you wish to be displayed. Be careful not to include too many values.
- Order By: Which column you wish to order the data by, this is useful in combination with limit. Ex: display the top 10 customers with the worst ACD.
- Width: When the graph is rendered on a page with multiple graphs, choose how much of the page the graph takes up.
- Stacked: When using a line, area or bar chart, each series of data will be plotted offset of the previous series (not from the 0 on that axis)
- Filter: A filter is used to automatically filter the information that is displayed based on variables available from where the page is rendered. The format of a filter changes depending on the data source. Select a data source below to view the example:
If you want to render a graph in this view for testing, you may need to temporarily hardcode a customer or carrier ID to make it work.