Loading data
Last updated
Was this helpful?
Last updated
Was this helpful?
You must load data before you can configure charts. There are three ways to load data:
Upload a data file
Connect to a database table
Connect to sample data
The data drawer is where you set up your data. To open the data drawer, click the bar at the bottom of the editing panel. Click the bar again to close the data drawer.
To upload the report's first data file, open the data drawer and drag a flat file (CSV, XLS, or XLSX) containing your data onto the data upload box or click Upload CSV or Excel and select the file to be uploaded. The file will be loaded to a BigQuery table and connected to the report.
To load additional data files, first click the + and then drag-and-drop or select your CSV or Excel file.
This feature is not available on all plans.
For databases that are not maintained on a cloud platform, we support the latest two release versions. Earlier versions may work with Juicebox, but are not supported.
Juicebox also provides a selection of sample data tables if you want to start exploring before you have your own data. To load sample data, open the data drawer, select the Sample Data button, and choose one of the available datasets.
Choose a sample data table and select Add Table.
The sample data includes the following tables.
Sample Data
Description
lego_sets
movie_trends
olympic_medals
video_game_sales
world_happiness_report_2020
When loading data files, it is important that your data be nice and clean. Here are some tips for .
If your report is connected to a database, you can select the schema and table (or view) to use as the data source. To set up a database connection, . The following databases are supported:
🎛 LEGO sets ( or see the data in a ). Source:
🎬 Movie Trends ( or see the data in a ). Source:
🥇Olympic Medals 1896-2012 ( or see the data in a ). Source: International Olympic Committee, The Guardian Datablog, and
🎮 Video Game Sales ( or see the data in a ). Source: . A helpful getting started to create a dynamic bar chart.
😀 World Happiness Report 2020 ( or see the data in a ). Source: and
