Statistics Extended

A key feature of Statistics Extended is that it enables users to create reports in different result groupings. All the other functionality is the same regardless of the current report grouping and the content of this guide is applicable for reports in all types of result groupings.

The built in help function

Statistics has a built in help function that gives users easy access to help resources directly within the system. By clicking on any of the info icons spread throughout the system a popup will be displayed with information about that particular feature.

 
Some of the help information is also presented as inline content in the user interface.
 

Create a report with Statistics Extended

Open Statistics Extended

Go to the Statistics Extended section in Statistics through the start page or through the menu.

Select report parameters

When you enter the Statistics Extended page you will be presented with the following options.

• Select which period the report should cover and which weekdays that shall be included (From-To tab). Click on the calendar icons to the right of the dates to open a calendar where the dates can be selected. If you want to select a non-sequential combination of dates this can be done on the Special tab.
• Select what time of day the report shall span in the Interval.
• Select which interval grouping the report initially shall be presented in. The interval grouping can also be changed afterwards.
• Select what time format that time values such as call duration´s should be presented in. The default is hhmmss (hours:minuts:seconds)
• Under the additional tab you have the option to change the interval block length for the time grouping. The default time block value is 30 minutes.
• Select the type of report that you want to create in the Report tab. See the section Report types for more information about the available reports in Statistics.
• Select the result grouping that the report should be created in. See examples of the different result grouping options at the beginning of this page.
• Click on the icon in the Report targets tab to select the targets for the report (i.e. the numbers it shall include information about).

Select report targets

Under the Report targets tab the numbers that the report should include can be selected. The available targets depend on the type of report selected in the previous step. If a User id report was selected this tab will only contain targets of the type User id etc.

Select one or multiple targets by checking the check box to the left of the objects. To select all at once check the check box at the top.

If there are a large number of objects in the list the filter text box can be used to narrow down the visible target. Start typing filter criteria in the text box to automatically hide all targets that do not match the criteria. Note that selected target are always visible even if they do not match the current criteria.

When one or more targets have been selected (checked) a Create report button will be visible to the right, click on it to create the report. 

The report will now be created. Depending on how long period, how many targets that are included and the number of calls the report will contain it can take a couple of seconds up to few minutes to create a report. If the report takes longer than a few seconds to create a loading page will be loaded that shows the current progress. Once the report creation process is completed by the system the report will be automatically loaded in the user interface. 

Work with a loaded report

When a report has been created it will be loaded in the user interface and additional tabs will become available in the menu. By default the interval groupings tab will become active and can be used to change the loaded reports current interval grouping. The initial interval grouping is based on the selection made before the report was created.

The available interval groupings depend on the report period. A shorter period that for example does not span multiple months does not present the Year and month interval grouping alternative etc.

The report is presented both as charts and as a spreadsheet. Some of the reports contain more columns than what is possible to display on the screen, therefore you need to scroll horizontally to see them all.
By hovering or clicking on the column names in the charts or in the spreadsheets header row a column description containing information about the content of that column will be displayed. This feature is available for all columns that are presented in the system.

Additional options will be available when the report is loaded in the user interface. This section describes these different options.

Visible columns

Under the Columns tab it is possible to select what columns that the report shall include. By clicking on the predefined column combination links at the bottom one of them can be set and then modified further before being applied to the report. When you are satisfied with your combinations, click on the Update visible columns button to update the report.

Create a saved report - (Subscription report)

When a report has been created and customized it is possible to save it as a subscription report (i.e. a saved report) that can be created and sent to one or several e-mail addresses automatically at any given time.

On the Save report tab a saved report can be defined by defining a name, the intended receivers as well as the reoccurring schedule for when the report should be sent and what it shall contain when it is sent. It's also possible to create an inactive report that is not sent automatically but that can be created manually from an archive with the current report settings.

The scheduled times at which the saved report shall be sent can be set to a wide range of combinations for example The first day of every month 08:00 with the Previous month.

It's also possible to select what result and interval groupings the report should be created with.

More information about the different schedule options is available on the following pages.

• Interval options
• Schedule options

The last step is to select what format the report should be sent in, depending on the selected Excel format different sub options will be available. Some formats have support for multiple interval groupings and charts. 

The report is saved when you click on the Save button at the bottom left corner. After a report has been saved it will be loaded in the saved report editor where additional schedules can be added etc. See the page Working with saved reports for more information about how to handle saved reports.

Export a report to Excel

To export a generated to e.g. Excel, go to the Export tab. From there you can save the report as a file directly from the browser or to let the system send the file as an attachment in an e-mail message to one or multiple e-mail addresses.

An exported report contains the same content and settings that was visible and set in the user interface. If multiple interval groupings was selected the Excel export contains one sheet per grouping. (Note that not all export formats supports multiple interval groupings in a single file).

The Excel export contains the same column descriptions as the user interface and it is shown in Excel by hovering the column headers. The column descriptions is also available in a sheet named Column descriptions.

Information about the report

The tab Information about the report contains information about the loaded report and its content.

Show a call specification list

By going to the Call specification tab it's possible to view a list of all the calls that is included in the report individually. Due to performance reasons the call specification is only available if the total number of calls in the reports i less than 3000 (incoming and outgoing summarized). To view the call specification for a longer period the report needs to be split into several reports covering shorter periods.