Geckoboard

Pivot tables in Google Sheets cannot be automatically interpreted by Geckoboard. You'll just need to create a new sheet and <a href="https://support.geckoboard.com/en/articles/6055680-use-google-sheets-importrange-function-to-display-data-in-geckoboard">use ImportRange</a> to reproduce the pivot table in a format we can read.

Add a new sheet to the spreadsheet containing the pivot table. For reference, <a href="https://docs.google.com/spreadsheets/d/11_A9rhoXK08n6a9uF0q4NzCvIwdQO-JASpERPkckOlk/edit?usp=sharing" rel="nofollow noopener noreferrer" target="_blank">see our example used in the video above</a>.

Use ImportRange on this new sheet to reproduce the pivot table. For this, you'd enter <code>=IMPORTRANGE([spreadsheet_url], [range_string])</code>, where <code>spreadsheet_url</code> is the URL of the Google Sheet and <code>range_string</code> is the pivot table sheet name and cell range you want to import.

After entering this formula for the first time you'll see the <code>#REF!</code> error in the sheet. Hover over the cell and click Allow access.

Use this new sheet to display your pivot table when <a href="https://support.geckoboard.com/en/articles/6055517-connect-your-google-sheet-to-geckoboard">connecting your Google Sheet to Geckoboard</a>.

1. Add a new sheet to the spreadsheet containing the pivot table. For reference, <a href="https://docs.google.com/spreadsheets/d/11_A9rhoXK08n6a9uF0q4NzCvIwdQO-JASpERPkckOlk/edit?usp=sharing" rel="nofollow noopener noreferrer" target="_blank">see our example used in the video above</a>.
2. Use ImportRange on this new sheet to reproduce the pivot table. For this, you'd enter <code>=IMPORTRANGE([spreadsheet_url], [range_string])</code>, where <code>spreadsheet_url</code> is the URL of the Google Sheet and <code>range_string</code> is the pivot table sheet name and cell range you want to import.
3. After entering this formula for the first time you'll see the <code>#REF!</code> error in the sheet. Hover over the cell and click Allow access.
4. Use this new sheet to display your pivot table when <a href="https://support.geckoboard.com/en/articles/6055517-connect-your-google-sheet-to-geckoboard">connecting your Google Sheet to Geckoboard</a>.

If you need help using pivot tables in Google Sheets, see <a href="https://support.google.com/docs/answer/1272898?hl=en" rel="nofollow noopener noreferrer" target="_blank">Google Sheets' support center</a>, or get in touch.

If you're using Excel, Geckoboard automatically interprets pivot tables from Excel spreadsheets.

Pivot tables cannot be automatically read from Google Sheets in Geckoboard. Use ImportRange to copy the pivot table in a new sheet.

Using pivot table in Excel