How to Create and Customize pivot table in Google Data Studio or Looker |
A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in the looker table to obtain a desired report. The tool does not actually change the database itself, it simply “pivots” or turns the data to view it from different perspectives.
Pivot tables are especially useful with large amounts of data that would be time-consuming to calculate by hand. A few data processing functions a pivot table can perform include identifying sums, averages, ranges or outliers. The table then arranges this information in a simple, meaningful layout that draws attention to key values.
Now the question that should come to your mind is that How pivot tables work and how can we create it.
Pivot tables in Looker Studio take the rows in a standard table and pivot them so they become columns. This lets you group and summaries the data in ways a standard table can't provide.
So When we create a pivot table, there are four main components:
Columns- When a field is chosen for the column area, only the unique values of the field are listed across the top.
Rows- When a field is chosen for the row area, it populates as the first column. Similar to the columns, all row labels are the unique values and duplicates are removed.
Values- Each value is kept in a pivot table cell and displays the summarized information. The most common values are sum, average, minimum and maximum.
Filters- Filters apply a calculation or restriction to the entire table.
So this pivot table is a standard table listing the day on day sales quantity and Revenues in millions by calendar date and country:
While this table is useful for showing which country has the most revenue and the high quantity of sales, it is useful for summarising this data in a meaningful way.
A pivot table, however, quickly shows the relationship of this data.This table easily summarises the data and You can also quickly spot outliers or anomalies in your data.
Pivot tables in Looker Studio support adding multiple row and column dimensions. which further breaks down the data, giving you even more insight into your data:
So In order to create a pivot table the first thing that you will need is a data source ,once you have your data source then you can go to add a chart option and select pivot table under pivot section.