What Is A Pivot Table: Examples And Uses

pivot table online database software

Unless you’re an Excel expert, creating pivot tables in a spreadsheet can prove to be a daunting task. It requires time and dedication to learn the functions and overcome the inevitable errors messages. But Excel pivot tables are not the only solution if you like to use data aggregation tools. Businesses who already moved their data to online database software have access to a much easier solution to slice and dice their data. In this article, I’ll explain what are pivot tables, I’ll showcase some examples, and I’ll explain how to use them in your Kohezion account.

What Is A Pivot Table

A pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns. It allows grouping by any data field.

Pivot tables are the perfect solution when you need to summarize and analyze large amounts of data. In just a few clicks, you have access to a whole new set of information. As I already said, spreadsheets are one solution to create pivot tables, but the best tools don’t require to write complicated formulas or to start all over again every time you want to organize the data differently.  A drag and drop option to move your fields around is the easiest way to go.

Examples Of Pivot Tables

Pivot Table With Subtotal – Count Aggregation – Column Only

This task tracking application contains just a few fields such as name, date, assignment, completion, and time. If I want to know all the tasks with the completion status «done», I can simply drag the completion field as a column and use a table view paired with the count function. This is a simple count function, using only one column.

Pivot table example task completion

Pivot Table With Subtotal Bar Chart – Count Aggregation – Column And Row

To push the functionalities a bit further, columns and rows can be paired to rearrange data even further. Still with my task tracking application, I used a table with subtotal bar chart aggregation view paired with a simple count aggregation function. The completion field is used as a column and the type field is used as a row. As you can see, our pivot table feature isn’t generating any errors when some fields are left empty. The system is simply leaving unfilled rows and columns for the empty fields.

Pivot table example row and column table count

Endless Data Aggregation Possibilities

The possibilities of aggregation function and view combinations are endless. To understand better what you can do with your own data, watch this short video.

How To Use Pivot Tables In Your Kohezion Account

To use the pivot table feature in your Kohezion account:

  1. Open the desired search in the search groups left side bar.
  2. Click on the third icon (blue cube) to switch from a grid or calendar view to the pivot table view.
  3. Drag and drop the desired field(s) in the boxes to use them as columns and/or rows.
  4. Choose a type of aggregation view: table, bar chart, line chart, etc.
  5. Choose a type of aggregation function: count, sum, average, etc.

Pivot tables are a premium feature in your Kohezion account. Visit our website to upgrade your account and have access to more endearing features.

This entry was posted in Database Application, Online Database Software. Bookmark the permalink.