Dashboard apps

Prompts for metrics dashboards — charts, filters, time ranges, real-time updates.

Dashboards combine filters, aggregation, and charts. Foundation prompt:

**Goal**: A metrics dashboard for {domain}.

**User**: Authenticated users; admins see all data, members see only their team's.

**Data**:
- `events`: { teamId, type, payload, timestamp }
- Index: by_team_and_type_and_timestamp

**Behavior**:
- Top filter bar: time range (Last 7 days / 30 / 90 / custom), team selector
- Grid of metric cards: total {metric}, daily average, week-over-week %
- Line chart: {metric} over time
- Bar chart: {metric} broken down by {dimension}
- All charts auto-update on filter change and on new events

**Constraints**:
- For datasets >100k events, use materialized daily aggregates (scheduled function)
- Filter state in URL so dashboards are shareable
- Use Recharts or Tremor for charts

Variations

Cohort analysis

Add: cohort retention chart (% of users active N days after sign-up).

Funnel

Add: conversion funnel showing drop-off between steps.

Comparison mode

Add: side-by-side charts for two time periods.

Export

Add: “Download as CSV” button per chart.

Related

Dashboard recipe

Full build walkthrough.

Caching

Materialized aggregates for performance.

Search patterns

Filter UIs.