Public
Edited
Feb 16, 2024
Insert cell
Insert cell
data = [
{
FY: "17/18",
"concession operating revenues": 158.594,
"total passengers": 57_747_186,
"passenger food and beverage spend rate": 9.07,
"SFO concession revenue from Tastes on the Fly San Francisco LLC": 5.448
},
{
FY: "18/19",
"concession operating revenues": 161.889,
"total passengers": 57_444_558,
"passenger food and beverage spend rate": 9.6,
"SFO concession revenue from Tastes on the Fly San Francisco LLC": 6.112
},
{
FY: "19/20",
"concession operating revenues": 129.127,
"total passengers": 40_542_936,
"passenger food and beverage spend rate": 9.76,
"SFO concession revenue from Tastes on the Fly San Francisco LLC": 5.884
},
{
FY: "20/21",
"concession operating revenues": 56.528,
"total passengers": 13_674_730,
"passenger food and beverage spend rate": 8.29,
"SFO concession revenue from Tastes on the Fly San Francisco LLC": 0.708
},
{
FY: "21/22",
"concession operating revenues": 113.261,
"total passengers": 34_812_040,
"passenger food and beverage spend rate": 10.4,
"SFO concession revenue from Tastes on the Fly San Francisco LLC": 3.821
},
{
FY: "22/23",
"concession operating revenues": 128.091,
"total passengers": 46_905_174,
"passenger food and beverage spend rate": 11.26,
"SFO concession revenue from Tastes on the Fly San Francisco LLC": 7.221
}
]
Insert cell
data
X
FY
Y
concession operating revenues
Color
Size
Facet X
Facet Y
Mark
line
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
data_w_rates
X
FY
Y
total passengers (millions)
Color
Size
Facet X
Facet Y
Mark
line
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
data_w_rates
X
FY
Y
concession revenue per passenger ($ per 100 passengers)
Color
Size
Facet X
Facet Y
Mark
line
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
data
X
FY
Y
passenger food and beverage spend rate
Color
Size
Facet X
Facet Y
Mark
line
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
data
X
FY
Y
SFO concession revenue from Tastes on the Fly San Francisco LLC
Color
Size
Facet X
Facet Y
Mark
line
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
data_w_rates
X
FY
Y
SFO concession revenue from Tastes on the Fly San Francisco LLC per passenger ($ per 100 passengers)
Color
Size
Facet X
Facet Y
Mark
line
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
data_w_rates = data.map((x) => ({
...x,
"total passengers (millions)": x["total passengers"] / 1_000_000,
"concession revenue per passenger ($ per 100 passengers)":
(x["concession operating revenues"] * 100_000_000) / x["total passengers"],
"SFO concession revenue from Tastes on the Fly San Francisco LLC per passenger ($ per 100 passengers)":
x["SFO concession revenue from Tastes on the Fly San Francisco LLC"] * 100_000_000 /
x["total passengers"]
}))
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