Thanks to the analysis tools filter, sort and group, simple analyses can be performed with just a few clicks. SeaTable also knows various operations for data processing, with which you can calculate cumulated values or create ranking lists, for example. For detailed evaluations with pivot tables, charts and graphical representations, SeaTable offers the Statistics plugin.
In this article you will learn how to create statistical analyses and appealing graphics with SeaTable.
Filter, sort and group
With filters, groupings and sortings, you can bring order to your data in no time at all and prepare it for your various use cases. By combining these simple analysis tools, which you can find centrally in every table view, even large amounts of data become structured and manageable. You can save different views to access them later.
At the statusrow you can read the number of rows in a view and certain column values. You can choose between the sum, the average, the median, the maximum or the minimum of all values in a column. You can also determine these column values for individual groupings.
Data processing operations
You can perform various operations using the data processing function. You can perform mathematical calculations across all values in a column as well as correlate values when entries in two different tables are identical. Useful statistical evaluations are, for example, cumulative values, percentages or ranked lists.
For more extensive data evaluations, SeaTable offers you various statistics. As with the views, you can of course save your statistical evaluations in order to access them at any time in the future.
With the statistics plugin you can visualize data in charts or evaluate them in detail using pivot tables. In each base you can create and save any number of such evaluations.
The management of charts and pivot tables is done on the dashboard of the statistics plugin. All created charts and pivot tables are saved there and are ready for retrieval at any time. All existing statistics are automatically updated when you change data in the table. So you never have to think about updating the statistics - SeaTable does it for you!
The evaluations displayed in the statistics management always refer to a table in the opened base. You define the data basis for visualization and evaluation by selecting the view to be applied. If you want to create a chart or a pivot table only for a part of the data in a table, then create a suitable view. You will not find any filtering functions in the statistics plugin itself. For this reason, you must always define the relevant data in a view before creating a statistic.
The statistics plugin supports a variety of chart types, for example:
- Bar and column charts (for displaying frequency distributions)
- Line charts (for the representation of a value over time)
- Pie charts (for simple visualisation of proportions)
Take the Statistics plugin guide to create a new chart step by step. Due to the simplicity of some chart types, the setting options there are limited compared to the other types.
Pivot tables are powerful analysis tools that allow you to get the results you're looking for within seconds, even from large, cluttered datasets. With the statistics plugin, creating pivot tables is child's play.
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 pivot table to be generated?
- The values of which column are grouping criteria for the columns of the pivot table to be created?
- How should the values in the table defined by the rows and columns be evaluated?
Therefore, for a pivot table you need at least two columns. Theoretically, you can also leave the column grouping unspecified. SeaTable will still display a result, but the results obtained in this way can be obtained more quickly using the simple evaluation tools Grouping and Filter.
Create pivot tables
Open the Statistics plugin and click the New Graph button in the upper right corner. In the options bar on the far right, click Pivot Table or scroll all the way down the list to create a new pivot table.
First, select the relevant table and view on the right side, then the column for row grouping and the column for column grouping. You will directly see a pivot table where the table values result from the number of entries: How many rows have each expression? At Summarize field you can create further interesting evaluations with little effort.
Finally, you should give the pivot table a name. You do this by clicking on the pencil icon at the top left of the window. Use a short, concise name to keep track of many pivot tables on your dashboard. Of course, you can customize the name later.
When you are satisfied with your pivot table, simply close the window by clicking on the x icon in the upper right corner and the pivot table you just created will appear on your dashboard. From there you can recall, adjust or delete the pivot table at any time.