The avatar for @credmond
Charles Redmond
Public
aaa-Database550Fall23
Edited
Dec 1, 2023
17 forks
1
Insert cell
Insert cell
Insert cell
Plot.plot({
marginLeft: 80,
x:{domain:[new Date(`${year}-01-01`),new Date(`${year}-12-01`)]},
y:{domain:[0,700000]},
marks:[
Plot.ruleX([new Date('1992-01-01')]),
Plot.ruleY([0]),
Plot.line(retail,{x:'sales_month',y:'sales'})
]
})
Insert cell
Plot.plot({
marginLeft: 80,
x:{domain:[new Date(`1992-01-01`),new Date(`2020-12-01`)]},
y:{domain:[0,60000]},
marks:[
Plot.ruleX([new Date('1992-01-01')]),
Plot.ruleY([0]),
Plot.line(retail2,{x:'yr',y:'total',filter:d => d.kind_of_business == 'Sporting goods stores',strokeDasharray:'5,5'}),
Plot.line(retail2,{x:'yr',y:'total',filter:d => d.kind_of_business == 'Hobby, toy, and game stores',strokeDasharray:'1,5'}),
Plot.line(retail2,{x:'yr',y:'total',filter:d => d.kind_of_business == 'Book stores'}),
Plot.text(['Sporting goods stores'],{x:new Date('2019'),y: 55000}),
Plot.text(['Hobby, toy, and game stores'],{x:new Date('2018'),y: 15000}),
Plot.text(['Book stores'],{x:new Date('2020'),y: 5000})
]
})
Insert cell
Plot.plot({
marginLeft: 80,
x:{domain:[new Date(`1992-01-01`),new Date(`2020-12-01`)]},
y:{domain:[0,60000]},
marks:[
Plot.ruleX([new Date('1992-01-01')]),
Plot.ruleY([0]),
Plot.line(retail3,{x:'yr',y:'sporting'}),
Plot.line(retail3,{x:'yr',y:'hobby'}),
Plot.line(retail3,{x:'yr',y:'books'}),
]
})
Insert cell
db
SELECT sales_month,sales
from sales
WHERE kind_of_business = 'Retail and food services sales, total' AND date_part('year',sales_month) = ${year}
Insert cell
db
SELECT min(sales_month) as yr, sum(sales) as total, date_part('year',sales_month) as part,kind_of_business
FROM sales
WHERE kind_of_business in ('Sporting goods stores','Hobby, toy, and game stores', 'Book stores' )
GROUP BY kind_of_business,part
ORDER BY part
Insert cell
db
SELECT min(sales_month) as yr,
sum(sales) as total,
sum(
CASE kind_of_business
WHEN 'Sporting goods stores' then sales
ELSE 0
END
) sporting,
sum(
CASE kind_of_business
WHEN 'Hobby, toy, and game stores' then sales
ELSE 0
END
) hobby,
sum(
CASE kind_of_business
WHEN 'Book stores' then sales
ELSE 0
END
) books,
FROM sales
WHERE kind_of_business in ('Sporting goods stores','Hobby, toy, and game stores', 'Book stores' )
GROUP BY date_part('year',sales_month)
Insert cell
d3.max(retail2,d => d.total)
Insert cell
db = DuckDBClient.of({
sales:sales
})
Insert cell
sales = FileAttachment("us_retail_sales.csv").csv({typed:true})
Insert cell
db
SELECT DISTINCT kind_of_business
FROM sales
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more