Thanks to the evaluation tools filter, sort and group, simple analyses can be carried out with just a few clicks. SeaTable offers the statistics module for extensive, detailed evaluations and graphical representations.
In this article you will get to know the statistics module, with which you can create extended evaluations and attractive diagrams.
Functionality of the statistics module #
With the statistics module you can visualize data with the help of diagrams or evaluate it in detail using pivot tables. In each base you can create and save any number of such evaluations.
The creation and administration of diagrams and pivot tables is done in the statistics administration. All created diagrams and pivot tables are saved there and are available for retrieval at any time. You open the statistics administration with a click on the Statistics button at the top right of the table view.
All evaluations in the statistics administration are automatically updated when you change data in the table. You do not have to think about updating the data basis, SeaTable does that for you.
The evaluations displayed in the statistics administration always refer to a table in the open base. You determine the data basis for visualisation and evaluation by selecting the view to be used. If you want to create a chart or a pivot table only for a subset of the data in a table, then create a suitable view and define it as the relevant view. You will not find any filter functions in the statistics module itself. For this reason - when creating charts as well as pivot tables - you must always select the relevant table and view first.
Diagrams #
The statistics module supports three diagram types:
- Bar charts (especially for the representation of frequency distributions)
- Line charts (especially for the representation of a value over time)
- Pie charts (for simple visualisation of proportions)
Due to the simplicity of the pie charts, the setting options there are limited compared to the other two types.
Create diagram
Open the statistics administration. You create a new diagram by clicking on Create statistics at the bottom of the statistics administration.
Now the statistics editor opens with its two-part view: the diagram is displayed on the left; the settings are on the right. In the settings, select the tab Diagram.
First select the relevant table, the relevant view and the desired chart type in the settings.
You start the detailed work on the chart by selecting the column to be used on for the X-axis. Click on the corresponding field and select the column. The chart creation - just like all other setting changes in the statistics module - is carried out in real time, i.e. the chart is immediately adjusted and updated with every setting change. This way you can immediately see whether you have achieved the desired result and readjust if necessary. You can also set whether you want to include empty rows in the diagram and whether data labels should be displayed. You can also select the colour of the diagram.
Then choose which values or which column should be displayed on the Y-axis. You can choose between Count and Extended (Count is the default setting).
- When counting, the number of rows is counted and the determined value is plotted. If desired, this can be done stacked, grouped or consolidated.
- With Extended, numerical columns can be evaluated and either the sum, the average or the maximum value (maximum) or the minimum value (minimum) can be plotted. A grouping can also be carried out here if desired.
Finally, you should give the diagram a name. You do this by clicking on the pencil icon at the top left of the window. This name is also displayed in the statistics administration. Therefore, use a short, concise name to keep track of many diagrams. Of course, you can also adapt the name later.
If you are satisfied with your diagram, simply close the window by clicking at the top right or return to the statistics administration via the arrow at the top left. The diagram you have just created is now displayed in the statistics administration. From there you can call up the diagram again at any time.
Adapt diagram
You can customise charts at any time using the chart editor. To return to the editor, call up the statistics administration, click on the three-dot icon to the right of the name of the diagram and then select Edit.
Delete diagram
You can delete diagrams at any time via the statistics management. To delete a chart, click on the three-dot icon to the right of the chart name and then select Delete.
Pivot tables #
Pivot tables are powerful analysis tools that - if used correctly - can determine the results you are looking for within a few seconds, even from large, unclear data sets. The graphical editor makes them very easy to use.
A pivot table is an evaluation matrix where the matrix values are dynamically generated based on your selection. When creating a pivot table, you have three selection options:
- The values of which column are grouping criteria for the rows of the table to be created?
- The values of which column are grouping criteria for the columns of the table to be created?
- Which values should be evaluated in the table spanned by the rows and columns and how?
Therefore, for a pivot table you need at least three columns (Theoretically, you can also leave the column grouping unspecified. SeaTable will still display a result. However, the results obtained in this way can be obtained more quickly using the simple evaluation tools Grouping and Filter).
Create pivot table
Open the statistics administration. You create a new pivot table by clicking on Create Statistics at the bottom of the statistics administration. In the statistics editor, select the Table tab to create the desired pivot table.
First, select the relevant table and the relevant view on the right-hand side.
You start the detailed work on the pivot table by selecting Column for row grouping. Click on the corresponding field and select the column. The pivot table - just like all other setting changes in the statistics module - is created in real time, i.e. the table is immediately adjusted and updated with every setting change. This way you can immediately see whether you have achieved the desired result and readjust if necessary. Depending on the selected column, you may have further grouping options. In the case of a date column, for example, you can specify whether you want to group the values on a daily, weekly, monthly, quarterly or annual basis. You can also set whether you want to include empty rows in the chart.
Then choose which column you want to use for column grouping. You will immediately see a pivot table where the table values result from a simple count: How many rows have each proficiency.
With Advanced, very interesting further evaluations can be created with little effort.
Finally, you should give the table a name. You do this by clicking on the pencil icon at the top left of the window. This name will also be displayed in the statistics management. Therefore, use a short, concise name to keep track of many pivot tables. Of course, you can also adjust the name later.
If you are satisfied with your pivot table, then simply close the window by clicking on the top right or return to the statistics management via the arrow in the top left. The pivot table you just created will now be displayed in the statistics management. From there, you can call up the table again at any time.
Adjusting Pivot Tables
You can adjust pivot tables at any time using the table editor. To return to the pivot table editor, call up the statistics administration, click on the three-dot icon to the right of the pivot table name and then select Edit.
Delete pivot tables
You can delete pivot tables at any time via the statistics administration. To delete a pivot table, click on the three-dot icon to the right of the table name and then select Delete.