Importing & Summarizing Data - Dec 15, 2021

Описание: Build with Grist is an educational webinar for Grist creators to learn tips and tricks to build their best custom database and app in Grist.
Click SHOW MORE for timestamps.

01:17 Recent Grist updates
02:30 Overview of business credit card expense example
02:52 Importing credit card data to an empty document
05:18 Creating a summary table (aka pivot table) to see spend by employee
08:15 Using a formula to clean up payment and expense data
10:35 Adding more summation formulas to summary tables
12:27 Summarizing totals without grouping by fields
13:46 Drilling into data by linking underlying records to summary tables
15:42 Data cleaning with the split() Python function
17:45 Quickly adding Choices from data
19:09 Summarizing by a Choice column
20:25 Summarizing by multiple columns and linking summary tables
21:55 Converting summary tables into charts
23:15 Importing additional data into an existing structure
28:24 Importing data from a different data source with unmatched columns
29:25 Transforming import data with formulas ✨
33:29 Question: Possible to import pivot tables?
34:22 Question: Webhooks?
36:24 Question: How to find correlated data?
38:40 Question: Useful Python formulas?
42:32 The difference between static charts and dynamic charts
43:27 Question: Version history?