Pivot tables are powerful functions available both in Excel and Google Sheets. In this article, we'll explain how to get them to work with Geckoboard.
What is a pivot table?
A pivot table is a table that summarizes data from another table and is made by applying an operation such as sorting, averaging, or summing to data in the first table, typically including grouping of the data.
You can use pivot tables to narrow down a large data set or see relationships between data points.
You can also use Pivot Tables to restructure your data. Below, the invoice number is shown in the first column with a column for each fruit type. Each cell then shows the number of each type in each order.
Geckoboard will automatically interpret pivot tables from your Excel spreadsheets – no extra work needed.
For Google Sheets
Currently, Geckoboard isn't able to retrieve pivot table data from a Google Sheet without using ImportRange to reproduce the pivot table in a new sheet.
- Navigate to the spreadsheet that contains the pivot table.
- Add a new sheet.
- Use ImportRange on this new sheet to reproduce the pivot table.
For this, you'd type
range_stringis the entire range of your pivot table, in cell
A1. This will import all the data in your pivot table.
- Now when you connect this spreadsheet to Geckoboard you can use this new sheet to start building visualizations from the data.