Thanks to the evaluation tools filter, sorting and grouping, simple analyses can be carried out with just a few clicks. For extensive, detailed evaluations and graphical representations SeaTable offers the statistics module.
In this article you will get to know the statistics module, with which you can create advanced analyses 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. You can create and save any number of such evaluations in each base.
The creation and management of charts and pivot tables is done in the statistics management. All created diagrams and pivot tables are saved there and are available for retrieval at any time. You open the statistics management with a click on the Statistics button in the top right corner of the table view.
All analyses in the statistics management are automatically updated when you change data in the table. You don't have to think about updating the data base, 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 the visualization and evaluation by selecting the view to be applied. If you want to create a chart or pivot table for only a subset of the data in a table, create a suitable view and define it as the relevant view. You will not find any filtering 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.
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 visualization of proportions)
Due to the simplicity of pie charts, the setting options there are limited compared to the other two types.
Open the statistics management. You create a new diagram by clicking on Create statistics at the bottom of the statistics administration.
Now the statistics editor opens with its split view: The diagram is displayed on the left; the settings are on the right. In the settings, select the Diagram tab.
First select the relevant table, the relevant view and the desired chart type in the settings.
You begin 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 executed in real time, i.e. the chart is immediately adjusted and updated with every setting change. This allows you to see immediately whether you have achieved the desired result and to readjust it if necessary. You can also set whether to include blank rows in the chart and whether to display data labels. You can also select the color of the chart.
Then select which values or which column are to be displayed on the Y-axis. You can choose between Count and Extended.(Counting is the default setting).
- When counting, the number of lines 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 will also be displayed in the statistics management. 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, 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 diagram you have just created is now displayed in the statistics management. From there, you can call up the diagram again at any time.
You can customize charts at any time using the chart editor. To return to the editor, access the statistics manager, click the three-dot icon to the right of the chart name, and then select Edit.
You can delete charts at any time via the statistics management. To delete a chart, click the three-dot icon to the right of the chart name, then select Delete.
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 selections. 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 generated?
* The values of which column are grouping criteria for the columns of the table to be created?
* Which values are to be evaluated in the table spanned by the rows and columns, and how?
Therefore, you need at least three columns for a pivot table. (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 management. You create a new pivot table by clicking 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 view on the right side.
You start the detail work on the pivot table by selecting Column for row grouping. Click the appropriate 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 allows you to see immediately whether you have achieved the desired result and to readjust if necessary. Depending on the selected column, you may have additional 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 blank rows in the chart.
Then choose which column you want to use for the column grouping. You will immediately see a pivot table in which the table values result from a simple count: how many rows have the respective characteristic.
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, 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 have just created is now displayed in the statistics management. From there, you can call up the table again at any time.
Customizing Pivot Tables
You can customize pivot tables at any time using the Table Editor. To return to the pivot table editor, access statistics management, click the three-dot icon to the right of the pivot table name, and then choose Edit.
Delete pivot tables
You can delete pivot tables at any time via the statistics management. To delete a pivot table, click the three-dot icon to the right of the table name, then choose Delete.