The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Calendar componentTemplates: Table of InstructionsUser Retention: Cohort Grid ComponentMultidrag AxisCash FlowTable ValidatorSurvey Visualization SuggestionsSurvey Free Response ComponentSurvey Question SelectorSurvey Matrix CompareSurvey Pie ChartSurvey HistogramSurvey DataSurvey Component LibraryGitHub API HelpersDraggable Cash Flow Curve
Example cohort analysis in SQL
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.
