Quick summary

• Who can do it? Administrators, Editors, Authors, Contributors
• How to reach it? Assets > Data Store

What, Why

Why reinvent the wheel? Data Pack runs off data from the most widely used database for CSV files: Google Sheets.

Connect a published Google Sheet. For more details, scroll down to read how to.

How

Before connecting the Google Sheet URL, ensure that the dataset is clean and structure it as one sizeable horizontal CSV file. Each row should represent the same entity — an incident, a district, a country. Publish the Google Sheet and also ensure that the Google Sheet link is made public.

Name the dataset and enter the published URL of the Google Sheet.

Once you create the dataset, it will take you to edit page where you need to set the properties for each column. Until this step is done, you cannot use the dataset in your 10000ft visualizations.

• Datatype: set what type of data your column holds. We support 16 datatypes – text, select, multi-select, image, date, datetime, number, accounting, percent, country ISO2, state ISO2, district ISO2, latitude, longitude, URL and email.
• Alias: give readable and easy to understand name to the column. This name will be shown in filters, weights, parameters and on tooltips.
• Description: describe the column name. The description of the column will be shown in the filters dropdown. The max length is 140 characters.

Once I create dataset, can I change the column names?

No, you cannot rename, add or remove columns once the dataset is created.

What if rows of my dataset change? How do I ensure it gets reflected in the visualization?

Yes you can show the updated data. Go to Edit page of the dataset and click on save button at the bottom of the page. We will fetch the updated data from the google sheet.