How to... > Create advanced WebOffice Statistics

Guideline to create advanced WebOffice Statistics with MS Excel:

1.Create a new Excel sheet and copy and paste the content of the time span to be analyzed (<WebOffice web application>\WEB-INF\work\WebOffice_<date>.csv). Be sure to copy the column headings only once! If you want to create overall statistics, see chapter Overall statistics from daily statistics for details.

2. In Excel go to tab Insert and select Pivot Chart from the Pivot Table menu:

Insert a Pivot Chart in MS Excel

3. Select the Field REQUEST and drag it into Legend Fields

4. Select the Field DATE and drag it into Axis Fields

5. Select the Field USER and drag it into Values

Pivot Table creation

You can select the Requests you want to analyze from the Column Labels drop down box.

Column Labels in Pivot Chart

The following chart shows the statistics of all search results or MapTips:

Search result and Map tip analysis