SeaTable
  • Functions
  • Templates
  • Solutions
    • Marketing - – The next marketing campaign is bound to come. Nothing is easier than that.
    • Project management - – Plan, track and manage team projects from start to finish.
    • Human Resources - – Structure HR processes for new hires and onboarding.
    • Distribution - Manage your entire sales pipeline and customer relationships in one place.
    • Software development - Increase the quality and speed of your development team with SeaTable.
  • Support
    • Quick guide - – Everything you need to know to get SeaTable up and running in minutes.
    • Help area - – Find answers to your questions and get tips on how to get the most out of SeaTable.
    • Integrations - – Connect SeaTable with tools like Zapier, Integromat or n8n. Or use SeaTable's API.
    • SeaTable Blog - – Here you will find product information, news and many examples of how you can use SeaTable optimally.
  • Home Blog
  • Industries
    • Marketing
    • Project management
  • Topics
    • No Code / Low Code
    • Product Updates
    • Success stories
    • News
    • Productivity
  • Prices
  • Login
  • login
  • Registration
  • Menu Menu

Changelog

  • Version 3.3
  • Version 3.2
  • Version 3.1
  • Version 3.0
  • Version 2.8
  • Version 2.7
  • Version 2.6
  • Version 2.5
  • Version 2.4
  • Version 2.3
  • Version 2.2
  • Version 2.1
  • Version 2.0
  • Version 1.9
  • Version 1.8
  • Version 1.7
  • Version 1.6
  • Version 1.5
  • Version 1.4
  • Version 1.3
  • Version 1.2
  • Version 1.1
  • Version 1.0

First steps

  • Glossary of terms used by SeaTable
  • What is SeaTable?
  • Registration and login
  • The first base
  • Data analysis
  • Cooperation
  • Extensions

Use SeaTable

  • Use SeaTable
  • Bases
  • Views
  • Grouping, sorting and filtering
  • Statistics
  • Web forms
  • Templates
  • Data import and export
  • Personal settings

Expert knowledge

  • Formula Reference
  • Webhooks
  • API tokens
  • Zapier Integration
  • DTABLE file format

Working with groups

  • Introduction to working with groups
  • Create a new group
  • Rename a group
  • Change the order of the groups
  • Copy a Base to a Group
  • Release a Base to a Group
  • Share individual spreadsheets of a base
  • Delete a group
  • Create a folder
  • Move a Base to a Folder
  • Get workspace ID of a group
  • Add a Base to Favorites

Group members and permissions

  • Add a team member to a group
  • Assign permissions in a group
  • Transfer a group to another user
  • Group members and their permissions

Manage bases

  • Introduction to working with bases and tables
  • Create a new base
  • Creating a Base Using a Template
  • Duplicate an existing base
  • Delete a Base
  • How to add a description to a base
  • Customize the appearance of a base (icon and color)

Working in tables

  • Add a table in a base
  • Move a table
  • Link tables with each other
  • Delete a table from a base
  • Restore a deleted table
  • Use of emojis in table name
  • Adding data via copy-and-paste
  • Search and replace values
  • Find a cell or value in a table
  • Keyboard shortcuts and key combinations

Data import

  • What import formats does SeaTable support?
  • Import Excel files into SeaTable
  • Data import using CSV in SeaTable
  • Data import from Microsoft Access into SeaTable
  • Data import from Google Sheets into SeaTable
  • Limitations of CSV/Excel import
  • Tips and tricks when importing CSV or XLSX files
  • Import CSV records into an existing base
  • Creating a base from a DTABLE file

History and versions

  • Data recovery options with SeaTable
  • Restore a deleted Base
  • Retrieve tables, rows and columns from the recycle bin
  • Undo actions
  • Undo changes via the logs
  • Saving the current Base as a Snapshot
  • Restoring a snapshot
  • Saving a base as a DTABLE file

Working with columns

  • Overview of all column types
  • Adding a column
  • The specifics of the first column
  • Adding a column description
  • How to customize the column type
  • Duplicate a column
  • Customize the first column
  • Double column height
  • Hide column arrows

Text and numbers

  • The numbers column
  • The Automatic Number column type
  • The e-mail column and its use
  • The URL column

File and image attachments

  • The file column
  • How to remove attachments permanently
  • Differences between image and file column
  • The preview of image files
  • Delete images and files from a row
  • Access to deleted attachments

Selection columns

  • Create a single selection column
  • Adding options to a single-selection column
  • Changing the order of single-selection options
  • Cascading a single selection
  • Export and import options in single or multiple selection columns
  • The checkbox column
  • The rating column

Links

  • How to link tables together in SeaTable
  • The Lookup Formula
  • The rollup formula
  • The Countlinks Formula

Formulas

  • Basics of SeaTable formulas
  • Formula example: Simple multiplication with a formula
  • Formula example: Merging text columns with the help of a formula
  • Formula example: Logical if operators for comparing values
  • Formula example: Search for a word in a text
  • Formula example: Calculate the duration of a vacation
  • Formula example: Calculate days to an event
  • Differences between formulas in Excel and SeaTable

Date, duration and people

  • The date column
  • The duration column
  • The columns Creator and Created
  • The employee column
  • The "Last edited" and "Last edited" columns

Other columns

  • The geoposition column
  • The button
  • Send an e-mail via button
  • Save a PDF document by button in a column

Work with rows

  • Adding a row
  • Select multiple rows
  • Duplicate a row
  • Locking a row
  • Change the order of rows
  • Delete a row
  • Display of changes on a row

Line details

  • What is the rows-ID?
  • How to find out who added a row ?
  • rows comment
  • Print row details

View basics

  • What is a view?
  • Create a new view
  • Rename a view
  • Delete a view
  • Differences between private and normal views
  • Duplicating views
  • Printing a view
  • Change the order of views
  • Group views in folders

View options

  • Filtering entries in a view
  • Link filter rules with AND and OR
  • Sorting entries in a view
  • Grouping entries in a view
  • Adjust row height
  • Hide and move columns
  • Cell coloring
  • Color marking of rows
  • Adjust the number of fixed columns
  • Lock views

View releases

  • Sharing a view with a team member
  • Create external link for a view

Working with plugins

  • What is a plugin?
  • Activate a plugin in a Base

Calendar plugin

  • Calendar plugin guide
  • Create new calendar entries in the calendar plugin
  • Create multiple calendars for one Base

Gallery plugin

  • Gallery plugin guide
  • Add a new row via the gallery plugin

Kanban plugin

  • Kanban plugin guide

Web forms

  • Creating a web form
  • Prefill form fields via URL
  • Conditional display of individual form fields
  • Configuration options and visual adjustments of a web form

Team collaboration

  • How collaboration works in SeaTable
  • Base and view shares at a glance
  • Groups for collaboration

Authorisations

  • Overview of all permissions
  • table permissions set
  • Create custom share

Release links

  • Create invitation link
  • Create external link for a base
  • Create a user share
  • Releasing a Base to a Group
  • Differences between invitation links and external links

Comments

  • The comment function in SeaTable

Team management

  • Unlock a team member
  • The functions of the team management in the overview
  • Groups and their members in the team management
  • Bases in the team management
  • View all access permissions of a Base
  • Empty the recycle bin in team management
  • Add a new team member
  • Make a team member an administrator
  • Delete the complete team
  • Lock or delete a team member
  • Changing the team name
  • Create a new group
  • Force two-factor authentication for the entire team
  • Enable two-factor authentication for a team member
  • View the terms of use or privacy policy
  • Open a support ticket
  • Request an AV contract

Subscription / Billing

  • Where can I find my invoices?
  • Plus or Enterprise subscription booking
  • Change current subscription: Customize package, duration and team size
  • Cancel the subscription
  • Customize billing address
  • Deposit of the tax ID
  • Change credit card
  • Payment by invoice
  • Discounts for public, non-profit or educational institutions
  • Is SeaTable free of charge? Can I try the Plus or Enterprise subscription?
  • Subscription packages
  • Subscription management

Working with automations

  • Automation overview
  • Functionality of automations
  • Create an automation
  • Manage and edit automations
  • Show execution log of an automation
  • Stop automations
  • Delete automations
  • Automation Trigger
  • Automation actions
  • Why can't I find the automations in my base?

Automation examples

  • rows Lock by automation
  • Linking entries via automation

Third party email

  • Set up Gmail to send emails via SMTP

Common data sets

  • Functionality of shared data sets
  • Create a common data set
  • Synchronization of a common data set
  • Create a new table with a common record
  • Add columns to a table created with a common data set
  • Sharing a common record with another group
  • Deleting a common record
  • Why do shared records only work in groups?

Big Data

  • rows Move to the Big Data backend
  • To create a Big Data view
  • Enabling the Big Data backend in a Base
  • Home
  • Help
  • Manual
  • Use SeaTable
  • Statistics

Statistics

Contents
  • Functionality of the statistics module
  • Diagrams
  • Pivot tables

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.
Various statistics in the module
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:

  1. Bar charts (especially for the representation of frequency distributions)
  2. Line charts (especially for the representation of a value over time)
  3. 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.

How helpful was this article?
Updated on 29 August 2022
Grouping, sorting and filteringWeb forms
Contents
  • Functionality of the statistics module
  • Diagrams
  • Pivot tables
SeaTable Logo

Do it like thousands of other people who use SeaTable to develop powerful processes, bring order to their data, and complete their tasks more efficiently.

SeaTable on Linkedin SeaTable on Medium.com SeaTable on Instagram SeaTable on Twitter SeaTable on Github SeaTable on YouTube SeaTable at Docker Hub

Products

  • SeaTable Cloud
  • SeaTable Dedicated
  • SeaTable Server
  • Support

Support

  • Quick guide
  • Help area
  • Templates
  • Integrations
  • Forum
  • Developer API
  • Status

Company

  • About us
  • We hire
  • Press
  • Contact
  • Blog
  • Imprint
  • Security
  • Data protection
  • Terms of use
  • EULA
Scroll up
  • Deutsch
  • Français
  • Español
  • Português
  • Русский