CSV / Excel
Drop in a spreadsheet and ask. Dot checks it against your data.
Attach a file to a question, or upload it as a table everyone can query.
Lisa Park9:41 AM
@Dot Which shipments on this bill were billed above our weights?
freight-bill.xlsxExcel spreadsheet1 reply
DotAPP9:42 AM
6 steps · 42s · Access Online
64 of 1,900, overbilled by $5,200 in total.
Sources: freight-bill.xlsx and shipments.
Here is the data.
| Shipment | Billed | Recorded |
|---|---|---|
| SH-20418 | 48 kg | 31 kg |
| SH-20533 | 26 kg | 18 kg |
| SH-20611 | 92 kg | 80 kg |
Today
Lisa Park9:41 AM
Dot Which shipments on this bill were billed above our weights?
freight-bill.xlsxExcel spreadsheetDot9:42 AM
6 steps · 42s · Access online
64 of 1,900, overbilled by $5,200 in total.
Sources: freight-bill.xlsx and shipments.
- SH-20418: 48 kg billed, 31 kg recorded
- SH-20533: 26 kg billed, 18 kg recorded
- SH-20611: 92 kg billed, 80 kg recorded
David Mensah9:41 AM
@Dot Attached are our NPS survey results. How do scores differ by customer plan and tenure?
nps-survey.csvCSV1 reply
DotAPP9:42 AM
4 steps · 20s · Access Online
Enterprise scores highest. Customers past two years score 20 points higher.
Sources: nps-survey.csv and accounts.
Chart
Today
David Mensah9:41 AM
Dot Attached are our NPS survey results. How do scores differ by customer plan and tenure?
nps-survey.csvCSVDot9:42 AM
4 steps · 20s · Access online
Enterprise scores highest. Customers past two years score 20 points higher.
Sources: nps-survey.csv and accounts.
Sarah Chen9:41 AM
@Dot Here’s the list of stores we plan to close. What share of revenue do they bring in?
store-closures.xlsxExcel spreadsheet1 reply
DotAPP9:42 AM
8 steps · 42s · Access Online
6% of revenue, about $4.2M a year.
Sources: store-closures.xlsx and store_sales.
Here is the data.
| The 14 stores | Share |
|---|---|
| Revenue | 6% |
| Returns | 11% |
Today
Sarah Chen9:41 AM
Dot Here’s the list of stores we plan to close. What share of revenue do they bring in?
store-closures.xlsxExcel spreadsheetDot9:42 AM
8 steps · 42s · Access online
6% of revenue, about $4.2M a year.
Sources: store-closures.xlsx and store_sales.
- Revenue: 6% share
- Returns: 11% share
More in Databases & spreadsheets
Connect your data.
Start for Free
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL