The avatar for @ryanfchase
Ryan Chase
Public
Edited
Jul 25, 2023
Fork of Public Request Data Demo
•
1 fork
1
Insert cell
Insert cell
db = DuckDBClient.of({requests: FileAttachment("data_0_to_100000.csv")})
Insert cell
db
SELECT * FROM requests
Insert cell
db
SELECT
RequestType,
CreatedDate,
ServiceDate,
ClosedDate,
DATE_DIFF('day', CreatedDate, ClosedDate) AS DaysToClose
FROM requests
WHERE (YEAR(ServiceDate) = 2023) AND ClosedDate IS NOT NULL;
Insert cell
daysToClose
X
servicedate
Y
—
Color
—
Size
—
Facet X
—
Facet Y
—
Mark
Auto
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
daysToClose
X
closeddate
Y
—
Color
—
Size
—
Facet X
—
Facet Y
—
Mark
Auto
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
daysToClose
X
createddate
Y
—
Color
—
Size
—
Facet X
—
Facet Y
—
Mark
Auto
Type Chart, then Shift-Enter. Ctrl-space for more options.

Insert cell
createdDateModifier = ['Jan', 'March']
Insert cell
viewof toggle = Inputs.toggle({ label: "createdDateModifier", value: true })
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