daily_orders
Type Table, then Shift-Enter. Ctrl-space for more options.
stores
Type Table, then Shift-Enter. Ctrl-space for more options.
// Filter rows based on the order_date column (keeping only rows from 2022 onwards)
pizzaDataFiltered = daily_orders_product.filter(({ order_date }) => new Date(order_date).getFullYear() >= 2022);
dailyTotalSales = d3.rollup(
pizzaDataFiltered,
(v) => d3.sum(v, (d) => d.revenue),
(d) => d3.timeWeek(d.order_date)
);
// Sorting the data by date
sortedDailySales = Array.from(dailyTotalSales.entries()).sort(
(a, b) => a[0] - b[0]
);
// array: 'salesData'
// Filtrar datos para el año 2022
salesData2022 = daily_orders.filter(({ order_date }) => new Date(order_date).getFullYear() === 2022);
storeTotalSales = Array.from(d3.rollup(
salesData2022,
(v) => d3.sum(v, (d) => d.revenue),
(d) => d.store_id
));
// Filtrar datos para el año 2022
salesPizza2022 = daily_orders_product.filter(({ order_date }) => new Date(order_date).getFullYear() === 2022);
PizzaTotalOrders = Array.from(d3.rollup(
salesPizza2022,
(v) => d3.sum(v, (d) => d.orders),
(d) => d.name
)).sort(
(a, b) => a[1] - b[1]
);
Plot.plot({
title: "2022 WEEKLY REVENUE",
marginLeft: 50,
y: { label: "Weekly revenue $" },
x: { grid: true, label: 'date' },
marks: [
Plot.dot(sortedDailySales, { x: "0", y: "1", stroke: "#9d5bf3", tip: true })
]
})
Plot.plot({
title: "Profitable stores",
x: {tickRotate:-25},
marginBottom: 50,
marginLeft: 80,
marks: [
Plot.barY(storeTotalSales, {
x: "0",
y: "1",
fill: "#4d2d77",
tip: true,
sort: { x: "y", reverse: true},
}),
Plot.ruleY([0])
]
})
Plot.plot({
width: width,
marginBottom: 25,
color: { legend: true, scheme: "Plasma" },
x: {axis:null},
y: {axis:null},
marks: [
Plot.barX(PizzaTotalOrders,
{ x: "1", fill: "0", tip: true, }
),
]
})
//Your second plot here
//Your third plot here
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.
