Public
Edited
Apr 1, 2023
ordersByDayOfWeek = pizzadb.query(`
select
"type",
"day_of_week",
sum("orders") as orderSum
from
orders
group by
"type",
"day_of_week"
order by
"type",
"day_of_week"
`)
ordersByDate = pizzadb.query(`
select
"orderDate",
"type",
sum("orders") as orderSum
from
orders
group by
"orderDate",
"type"
order by
"orderDate"
`)
augmented_pizzaorders = pizzaorders.map((d) => augment(d))
mappings = ({
type: (d) => d.name.split(" Pizza ")[0],
size: (d) => d.name.split(" Pizza ")[1]
})
augment = d => {
const ret = {...d};
for (const [key, mapping] of Object.entries(mappings))
{
ret[key] = mapping(d);
}
return ret;
}
dayLetter = (day_of_week) => ["S", "M", "T", "W", "T", "F", "S"][day_of_week]
lineTooltip = (d) => `${d.type}
${d.orderSum} Orders
(${formatDate(d.orderDate)})`
formatDate = d3.timeFormat("%a %d. %b %Y")
types = [...new Set(pizzaorders.map(mappings.type))].sort()
sizes = [...new Set(pizzaorders.map(mappings.size))].sort()
names = [...new Set(pizzaorders.map((po) => po.name))].sort()
fields = Object.keys(pizzaorders[0])
dateCount = [...new Set(dates.map((d) => "" + d))].length
dateRange = d3.extent(dates)
dates = pizzaorders.map((o) => o.orderDate)
pizzadb = DuckDBClient.of({ orders: augmented_pizzaorders })
import { pizzaorders } from "@observablehq/data-vis-course-assignment"
import { Plot } from "@mkfreeman/plot-tooltip"
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.
