When you use ImportData, ImportJSON, BigQuery, or any other method to get CSV, JSON, or database data into Google Sheets, you often end up with what can be described as raw data or a data dump. To illustrate this, take the following example of someone’s running data from a Fitbit, which shows raw, unprocessed data:
From the above example, you might want to see how many times you’ve run in each city or how many times you’ve gone for morning, afternoon, evening, or night runs. This is possible by using formulas such as UNIQUE, COUNTIF, and other Statistical or Math functions.
Building visualizations from data dumps isn’t straightforward, so we recommend creating a new tab in your sheet to analyze the data and get the metrics that you need.
As a reference, you can view and copy this example sheet. On the Analysis for Geckoboard tab, you'll find a series of example calculations (as seen below).
Once you've made calculations, you can connect your sheet to Geckoboard, and then build visualizations like these:
Learn how to manipulate raw data using Pivot Tables.