The end-to-end solution for building and hosting better data apps, dashboards, and reports.
events = dc.query(`
SELECT *
FROM events
ORDER BY time
`)
Table(events)
cohorts = dc.query(`
WITH signups AS (
SELECT user_id, DATE(time) AS cohort_date
FROM events
WHERE type = 'signup'
GROUP BY 1, 2
)
SELECT cohort_date, DATE(time) AS period_date, COUNT(DISTINCT e.user_id) as users
FROM events e INNER JOIN signups s ON e.user_id = s.user_id
GROUP BY 1, 2
ORDER BY 1, 2
`)
Table(cohorts)
import {SQLiteDatabaseClient} from "@mbostock/sqlite@259"
import {Table} from "@observablehq/inputs"
function ExampleDatabase() {
const file = FileAttachment("events.db");
return Object.defineProperties(new SQLiteDatabaseClient(file.arrayBuffer()), {
name: {value: "events", enumerable: true}
});
}
dc = ExampleDatabase()
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.
