Analysing Activities

View - Activity - Export of Activity Data to Pivot in Excel

You can assemble a list of all activities and paste them straight into a Pivot table.

Pivot tables may seem complicated, but once you have mastered the technique the possibilities for working with them are endless. You can put together any imaginable number of combinations of employees and activity types, which will provide you with the contexts you are looking for in your analysis.

You use a wizard to perform the export, and choose a limited period from which figures are retrieved.

The wizard for exporting to Pivot

Start the wizard from View - Activity - Export of Activity Data to Pivot in Excel.
Enter the From date and To date to denote the period from which you want to get the data for.
Select setupThis only determines the structure of the Pivot table when you open the Excel file. The same data is exported for all the selections and can be combined as you wish later.
in the drop-down menu below.
Click OK to produce the Excel file.

You can now continue to process the data in the Pivot table, or include it in the calculations you require. Remember to save the Excel sheet in a place where you can easily access it.