evidence Documentation

Technical Documentation: evidence-dev/evidence

ℹ️ Provenance: Multi-Tier Ingestion · CodeWiki Reference

Overview (`README.md`) Copy Section

How It Works

Evidence is an open-source, code-based alternative to drag-and-drop business intelligence tools.

• Create reports in code using SQL and markdown
• Develop using Evidence's Agent, or on your local machine with Claude Code / Cursor etc
• Self-host or publish on Evidence Studio

Install

macOS / Linux Copy Section

curl -fsSL https://evidence.studio/install.sh | sh
evidence help

Windows Copy Section

irm https://evidence.studio/install.ps1 | iex
evidence help

Create a Project

evidence init my-project
cd my-project
evidence dev

Publish

Publish your project on Evidence Studio for hosted reports, or self-host the generated static site on your own infrastructure. See the publishing docs for options.

Join the Evidence Community

Join our Slack channel to get involved in the community's discussion, share what you're working on, or ask for help.

Contributing

Contributions are welcome — see CONTRIBUTING.md for how pull requests are reviewed and merged.

License

Evidence is licensed under the MIT license. See LICENSE for details.

Overview (`cli/README.md`) Copy Section

EVD

Evidence Studio local development CLI.

Quick Start Copy Chapter

# Install dependencies (from monorepo root)
pnpm install

# Run a CLI command from source — instant, no build (defaults to cli/test-environment)
pnpm evd query "select 1"
pnpm evd help

# Run the dev server from source against the test playground
pnpm evd dev

# Build the CLI binary (requires Bun installed globally)
pnpm cli:build

# Run the binary
./cli/dist/evidence
./cli/dist/evidence --help
./cli/dist/evidence dev --port 8080

Architecture Copy Chapter

/* Detailed source-code truncated for AI context efficiency. */

Project Structure Copy Chapter

.
├── adapter/
│   └── index.js          # Custom SvelteKit adapter
│                         # - Discovers & embeds static assets
│                         # - Generates manifest
│                         # - Compiles binary with Bun
│
├── cli/
│   ├── index.ts          # CLI entry point
│   ├── args.ts           # Argument parsing, help, banner
│   └── server.ts         # Bun HTTP server + SvelteKit integration
│
├── src/
│   ├── routes/           # SvelteKit routes (the actual app)
│   ├── lib/              # Shared components
│   └── app.html          # HTML template
│
├── static/               # Static assets (favicon, etc.)
├── dist/                 # Build output (gitignored)
│   └── evd               # The compiled binary
│
├── svelte.config.js      # SvelteKit config (uses ./adapter)
├── vite.config.ts        # Vite config
└── package.json

How It Works Copy Chapter

1. Asset Embedding Copy Section

The magic that makes a single binary possible. During build:

// adapter/index.js generates imports like:
import favicon_SVG_a1b2 from '../client/favicon.svg' with { type: 'file' };

export const assetMap = new Map([
	['/favicon.svg', favicon_SVG_a1b2]
	// ... all static files
]);

Bun's { type: "file" } import attribute embeds the file contents into the binary.

2. The Adapter Copy Section

adapter/index.js is a custom SvelteKit adapter that:

1. Writes SvelteKit output - client assets, prerendered HTML, server code
2. Generates asset imports - creates assets.generated.ts with embedded file references
3. Generates manifest - SvelteKit's routing manifest
4. Compiles - runs bun build --compile to create the binary

3. The CLI Copy Section

cli/ contains the runtime code that gets compiled:

• args.ts - Parses --port, --help, --version, etc.
• server.ts - Starts Bun.serve(), handles static assets & SSR
• index.ts - Wires it together, handles commands

4. Request Flow Copy Section

Request → Bun.serve()
            │
            ├─→ Static asset? → Serve from embedded assetMap
            │
            ├─→ Prerendered route? → Serve embedded HTML
            │
            └─→ Otherwise → SvelteKit SSR

Development Copy Chapter

Prerequisites Copy Section

• Bun v1.2.18+ (required for running CLI source and for binary compilation)
• pnpm (for package management)

Day-to-day workflow Copy Section

Both scripts default to the cli/test-environment playground regardless of where you invoke them from. Pass --project to override the target directory.

Quick Install: Add `evidence` to Your PATH Copy Section

After building the CLI binary, you can add it to your PATH for convenient global access:

# Symlink the binary to a directory in your PATH (requires sudo)
sudo ln -sf "$(pwd)/cli/dist/evidence" /usr/local/bin/evidence

# Verify it works
which evidence
evidence --version

Benefits of this approach:

• Always reflects the latest dist/evidence after rebuilds (no re-install needed)
• Works everywhere (scripts, subshells, GUI tools)
• Easy to revert (see below)

Undo the symlink:

# Remove the symlink
sudo rm /usr/local/bin/evidence

# If you want to restore the previous binary (backup created during install)
sudo mv /usr/local/bin/evidence.old /usr/local/bin/evidence

Note: If you built the CLI elsewhere, replace the path accordingly. You can also prepend a user bin directory to your PATH instead of using /usr/local/bin if you prefer not to use sudo.

Examples — all run from the monorepo root

pnpm evd help
pnpm evd query "select 1"                  # against cli/test-environment (NDJSON)
pnpm evd --project ./some/dir validate     # override to an arbitrary project
pnpm evd dev --port 5173                   # extra flags forward to the dev server

Output formats Copy Section

Data commands are machine-readable by default; the human view is opt-in via
--verbose. Output is identical whether or not stdout is a terminal (there is
no TTY detection). All formatting is centralized in cli/output.ts
(printResult / renderResult / fail) — commands never call JSON.stringify
or render tables directly.

Defaults (no flags):

• Result sets (query, describe, schema) → NDJSON, one JSON object per line.
• Name lists (tables) → plain schema.table, one per line.
• Structured/list results (connectors, models, lineage, docs) → compact JSON.
• No ANSI color and no box-drawing characters, ever, by default.

Shared flags on every data command:

Errors go to stderr; under --format json/ndjson they are emitted as
{"error":<msg>,"code":<str>}. Status/progress chatter also goes to stderr.

Breaking changes (vs. the previous human-first defaults):

• Default output is now NDJSON/plain/compact-JSON instead of pretty tables.
  Use --verbose for the old human view.
• -v now means --verbose. Use --version (or the version subcommand)
  for the version.
• --columns now takes a value (column selection) instead of being a boolean
  "columns-only" toggle — that role is now describe's default.
• --format is long-form only; -o/--output keeps its "write to
  file" meaning. --json still works as an alias for --format json.
• query no longer pretty-prints by default and caps output at 1000 rows
  unless --all is passed.

evd dev detects that it's running from source (via process.execPath) and routes through vite dev automatically — same auth + Studio health check as the binary, then spawns vite dev. Browser auto-open defaults to off in source mode (pass --open to opt back in); the binary still auto-opens by default.

What works under `evd` (no build)

The commands that are pure TypeScript and don't need the SvelteKit bundle: help, version, login, logout, whoami, orgs, switch, token, query, tables, describe, schema, connectors, models, lineage, upgrade.

What still needs `cli:build` (or the dev server)

validate and docs go through SvelteKit's HTTP layer, which uses import.meta.glob — a vite-only construct. Two options:

• Run pnpm cli:build once, then ./cli/dist/evidence validate reflects the latest source. (You only need to rebuild when SvelteKit-side code changes.)
• Or run pnpm evd dev and hit the same endpoints directly: curl http://localhost:3000/api/validate.

Other commands Copy Section

pnpm cli:build       # Build production binary
pnpm cli:check       # Type check
pnpm cli:lint        # Lint & format check
pnpm --filter @evidence/cli format

Dev vs Production Copy Section

Adding CLI Commands Copy Section

Edit cli/args.ts to add new commands:

// In parseArgs():
if (firstArg === 'mycommand') command = 'mycommand';

// In cli/index.ts:
case 'mycommand':
  // do something
  break;

Data-producing commands should route their results through printResult (from
cli/output.ts) using the shared args.output options, rather than calling
JSON.stringify or rendering tables themselves — this keeps the machine-first
defaults, --format, --columns, --limit, and color handling consistent
across every command.

Modifying the Adapter Copy Section

The adapter in adapter/index.js controls the build process. Key functions:

• discoverAssets() - Finds all files to embed
• generateAssetImports() - Creates the import statements
• adapt() - Main build orchestration

Docker Image Copy Chapter

The CLI is published as a Docker image, evidencedev/serve (Docker Hub), so that self-hosting a project is a two-line Dockerfile:

FROM evidencedev/serve:latest
COPY --chown=evidence:evidence . /project

That's the whole point of the image — a user self-hosting a project should never have to figure out how to install the CLI inside a container. cli/Dockerfile handles fetching the right binary for the architecture, CA certificates (without them, TLS to the warehouse fails at runtime), a non-root evidence user, /project as the working directory, honouring a platform-provided $PORT, and starting evidence serve --host 0.0.0.0. The user's layer is just "copy my project in".

It ships on a version bump Copy Section

The image does not build the CLI. Its first stage downloads an already-published binary from Vercel Blob:

https://.../cli/v${EVIDENCE_VERSION}/evidence-${target}

So a new image only appears when a new CLI version is released. In .github/workflows/cli-release.yml, the docker job has needs: release — it cannot run until the release job has uploaded binaries for that version. There is no way to rebuild the image against unreleased CLI code: bump VERSION in cli/cli/args.ts, add the cli-release label to the PR, and merge.

Also bump the ARG EVIDENCE_VERSION default in cli/Dockerfile to match. CI overrides it, but anyone running docker build -f cli/Dockerfile . by hand gets whatever the default says.

Tags and platforms Copy Section

• evidencedev/serve:<version> on every release.
• evidencedev/serve:latest only for stable versions — a version containing - (0.9.2-alpha.1) never moves latest.
• Built for linux/amd64 and linux/arm64 via QEMU + Buildx. Pushed with the DOCKERHUB_USERNAME / DOCKERHUB_TOKEN secrets.

The docker job lives in the release workflow rather than its own file because the cli-v* tag is pushed with GITHUB_TOKEN, which cannot trigger another workflow.

Telemetry Copy Chapter

The CLI reports anonymous usage — to opt out run evidence telemetry disable, or set EVIDENCE_TELEMETRY_DISABLED=1 or DO_NOT_TRACK=1. The full payload is documented at https://docs.evidence.studio/cli#telemetry.

Events go to POST /api/cli/event in studio (studio/src/routes/api/cli/event/), which allow-lists fields and forwards to PostHog. Three rules keep the "unique users" number honest: serve runs and the daily serve_heartbeat never create a PostHog person (count deployments by project_id instead), a machine id that cannot be persisted is sent as null rather than a fresh UUID per run, and the first run inside an agent sandbox or container is flagged sandbox and recorded personless. Authenticated CLI usage of Studio is captured server-side as cli_studio_request in authenticateCliRequest, keyed to the user's email and organization group, so it is not subject to client opt-out.

License Copy Chapter

MIT

Overview (`docs/README.md`) Copy Section

Evidence Docs

Autogenerated Components and Data Sources Docs Copy Chapter

The following directories are autogenerated by scripts in the scripts/docs:

• components - All user components
• data-sources - All data sources

Do not edit these files manually! Instead run the docs generation scripts:

npm run docs:generate-components
npm run docs:generate-connectors

Development Copy Chapter

Install the Mintlify CLI to preview the documentation changes locally. To install, use the following command

npm i mint

Run the following command at the root of your documentation (where docs.json is)

mint dev

Overview (`cli/test-environment/README.md`) Copy Section

CLI dev playground

This directory is the local Evidence project the CLI is exercised against during development. Drop a connection.yaml here (gitignored) pointing at your dev warehouse and the scripts below will pick it up.

Setup Copy Chapter

Create cli/test-environment/connection.yaml. Snowflake + dbt source files for this directory will be added in follow-up work — for now a minimal config is enough to exercise CLI commands.

Run from the monorepo root Copy Chapter

# A CLI command, against this directory (the default)
pnpm evd help
pnpm evd query --sql "select 1"

# Dev server, against this directory (vite dev under the hood, no binary build)
pnpm evd dev

validate and docs go through the SvelteKit HTTP layer (which uses vite-only constructs), so they need either a binary build (pnpm cli:build) or a running dev server. See the main cli/README.md for the full breakdown.

These scripts work from anywhere inside the monorepo — they don't cd into this directory, they pass --project cli/test-environment to the CLI so process.cwd() semantics still resolve correctly. To target a different project, append --project ./other/path to either script.

Behind the scenes Copy Chapter

• --project chdirs the CLI process and sets EVIDENCE_PROJECT_CWD so the SvelteKit dev server (which runs with cwd = the cli package) can find your project files via getProjectCwd().
• evd dev detects "running from source" via process.execPath and routes through vite dev instead of the compiled Bun server. Browser auto-open is off by default in source mode; pass --open to opt in.

Overview (`docs/components/README.md`) Copy Section

Component Docs

Autogenerated Components Docs Copy Chapter

These docs are autogenerated by the scripts/generate-components-docs.ts script. Do not edit these files manually!

To regenerate the docs, run the following command:

npm run docs:generate-components

Overview (`docs/data-sources/README.md`) Copy Section

Data Source Docs

Autogenerated Data Source Docs Copy Chapter

These docs are autogenerated by the scripts/generate-connector-options.ts script. Do not edit these files manually!

To regenerate the docs, run the following command:

npm run docs:generate-connectors

Overview (`core/src/user-components/UserComponentModel/README.md`) Copy Section

UserComponentModel

UserComponentModel is the foundation for all of our user-facing data components (tables, dimensions, measures, pivots, etc).
Think of it like the blueprint for every component: it defines the rules for how components talk to each other, what data they hold, and how they can be serialized/deserialized during SSR.

Why is it abstract? Copy Chapter

An abstract class is like a "template" that you can't use directly.
You don't create a UserComponentModel on its own—you only create subclasses like TableModel or DimensionModel that fill in the blanks.

This lets us:

• Define shared rules once (e.g. parent/child validation, attribute reactivity, serialization).
• Ensure every subclass plays by the same rules, while still giving them the freedom to customize.

Analogy:

• Abstract class = "You must have wheels, but you can decide if you're a car, a bike, or a skateboard."

Attributes Copy Chapter

Every UserComponentModel accepts a MaybeGetter for the component's attributes in its constructor argument. MaybeGetter is used to allow the attributes to be either a plain value (Record<string, unknown>) or a function that returns a value (a getter: () => Record<string, unknown>). Accepting a function is necessary for reactivity when passing state around. Reactivity isn't always necessary (like on the server during SSR)
so its a MaybeGetter.

In the constructor, the attributes use something called useStable. This prevents reactivity churn when the user is typing in the editor. When the user types, a new Markdoc RenderableTree is generated with every keystroke (after a debounce). This means that every model gets a brand new attributes object each time, which would cause all of the queries to re-run. To prevent this, useStable only returns a new value if the state has actually changed by doing a recursive comparison of values all the way down objects and arrays.

Parents and Children Copy Chapter

2. Parent

   • The "container" this model lives inside.
   • Example: A DimensionModel can only exist inside a TableModel.

3. Children

   • Models that live inside this one.
   • Example: A TableModel can contain multiple DimensionModel and MeasureModel children.

This creates a tree structure with our models that mimics the RenderableTree from markdoc. It enables parents and children to depend on and interact with each other to run queries.

Why we check parent/child at runtime Copy Section

Even though TypeScript checks parent/child relationships at compile time, we also validate them at runtime (isValidParent and isValidChild). This is necessary because the user's input is completely dynamic and they could build components with invalid parent/child relationships, which would result in us creating models with invalid parent/child relationships. By checking the types of parents/children, we make sure we fail fast with a clear error rather than something failing obscurely down the line.

const dimension = new DimensionModel(...);
table.addChild(dimension); // ✅ Works

const measure = new MeasureModel(...);
dimension.addChild(measure); // ❌ Throws runtime error

Serialization and SSR Copy Chapter

Serialization and Deserialization is the process of converting a complex object into a JSON representation and then back again. This process is necessary because only JSON can be sent from the server to the client, not classes, functions, or other complex entities.

If a component needs to be serializable, it should specify its serialized type via the Serialized generic, implement the toSerialized function to return its serialized data, and perform necessary deserialization using the serialized data in the model constructor.

Note: We don't have to serialize all the way down to JSON! SvelteKit uses devalue under the hood which supports some more complex types like Date and Map.

Generics Copy Chapter

What even are generics? Copy Section

Generics are a way of writing code that is flexible but still type-safe.

Think of them as placeholders for types. Instead of hard-coding "this must always be a string" or "this must always be a number," we say "this can work with any type, but once you pick the type, it stays consistent."

For example, imagine we need a function that ensures something is always an array. We can pass it an argument that may or may not be an array, and it will ensure that what is returned is an array. This kind of function doesn't care if we're dealing with an array of strings, numbers, or anything else. We can use generics to make the types behave nicely with any kind of input.

function makeArray<T>(input: T | T[]): T[] {
	return Array.isArray(input) ? input : [input];
}

const example1 = makeArray(1); // -> number[]
const example2 = makeArray(['a', 'b', 'c']); // -> string[]
const example3 = makeArray(new SomeClass()); // -> SomeClass[]

UserComponentModel's generic types work fundamentally the same. They ensure consistency between the types of attributes, parents, children, and the serialized version of a model.

Why do they look weird/extra complex for UserComponentModel? Copy Section

You'll notice the type definition uses a big object of options rather than simple type parameters:

type TableModelGenerics = WithDefaults<{
	Attributes: TableAttributes;
	Serialized: SerializedTableModel;
	ValidChildren: [typeof DimensionModel, typeof MeasureModel, typeof PivotModel];
}>;

Why?

1. Clarity - Instead of positional generics (<A, S, P, C>), we structure them in an object where each type has an explicit name from its key. This is more readable when there are a lot of generic types.
2. Flexibility - You don't always need to set all options. Using the WithDefaults helper, you can override just the parts you need, and leave the rest at defaults.

State in models Copy Chapter

For reactivity, use $state and $derived (or $derived.by) for models' member variables.

Use $state for data that is changed during reactivity (e.g. page, search, order in TableModel)

Use $derived (or $derived.by) for state that is computed (derived) from other state like $state declarations, the model's attributes, etc (e.g. queryConfig in TableModel)

Note: Use $derived or derived.by for computed state, NOT getters (get myField() { }). Getters will be re-executed whenever they are read resulting in performance issues.

Overview (`core/src/user-components/common/README.md`) Copy Section

Common Utilities

This directory contains shared utility functions used across user components.

Date System Architecture Copy Chapter

The Problem We Solved Copy Section

When building a data visualization platform, dates are everywhere but behave differently depending on context. Users want to:

• Filter data by date ranges ("Show me last 30 days")
• Compare time periods ("How does this month compare to last month?")
• Group data by time periods ("Monthly sales trends")

The challenge: date logic was scattered across components with inconsistent behavior. Some components parsed "Last 30 days" differently, comparison tooltips showed placeholder dates, and we had duplicate parsing logic everywhere.

Our Solution: Three Clear Use Cases Copy Section

We identified that all date operations fall into three distinct patterns, each requiring different technical approaches:

1. Explicit Date Filtering ("Show me sales from last month")

The Use Case: User wants to see data from a specific time period. They select "Last 30 days" from a dropdown, and we filter the entire dataset.

Why This Exists: Most basic date filtering - users want to slice data by time ranges. Common in dashboards where you want to focus on recent data.

How It Works: We convert "Last 30 days" into SQL like WHERE date >= '2024-01-01' AND date <= '2024-01-31'

For Comparisons: We shift the date boundaries - if current period is "last month", comparison period becomes "two months ago"

2. Time-Series Analysis ("Monthly sales trends with comparisons")

The Use Case: User wants to see data grouped by time periods (daily, monthly, yearly) and compare each period to its predecessor. A table showing "Monthly Revenue" where each row is a month, and they want to see how each month compares to the previous month.

Why This Exists: Time-series analysis is core to business intelligence. Users don't just want to see monthly totals - they want to see "Is this month better than last month?" for every month.

How It Works: Instead of filtering dates, we group by time periods using date_grain="month". For comparisons, we shift the date expressions themselves: toStartOfMonth(date - INTERVAL 1 MONTH).

The Tricky Part: Each row represents a different time period, so the comparison logic needs to be applied per-row, not per-query.

3. Dashboard-Wide Date Controls ("Apply this date range to everything")

The Use Case: User sets a date range at the dashboard level and wants it applied to all components. Common in executive dashboards where you want to see "Q3 performance" across all metrics.

Why This Exists: Consistency - users want to change one date filter and have it affect multiple charts/tables simultaneously.

How It Works: Similar to explicit filtering but propagated across multiple components. The date range logic is reused but applied at a higher level.

Key Technical Decisions Copy Section

MIN/MAX Aggregates for GROUPING SETS

Problem: Comparison tooltips showed "Jan 1/70" (ClickHouse null date placeholders) for total rows.

Solution: Wrap date expressions in MIN/MAX aggregates:

-- Before
formatDateTime(toStartOfMonth(date), '%b %e/%y')

-- After
formatDateTime(MIN(toStartOfMonth(date)), '%b %e/%y')

Why: GROUPING SETS automatically calculates correct date ranges for both individual rows and totals without manual conditional logic.

Centralized Date Parsing

Problem: Duplicate parsing logic across multiple files.

Solution: Single parseDateRange() function in date-options.ts handles all patterns:

• "Last X days/months/years"
• "MTD/WTD/YTD"
• Case insensitive matching
• Singular/plural forms

Structured Return Values

Problem: Functions returned SQL strings that were then parsed with regex.

Solution: Return structured objects:

{ whereClause: string; startDate: string } | undefined

Functions Overview Copy Section

`processDateRange(date_range)`

• Converts date range objects to SQL WHERE clauses
• Returns both SQL and parsed start date
• Handles all supported date range patterns
• Uses date column from the DateRangeObject

`calculateComparisonDateRange(dateRange, offset)`

• Calculates comparison date ranges
• Handles both range-based and dimension-based shifting
• Uses centralized parsing logic

`parseDateRange(dateRange)`

• Central parsing for all date range strings
• Returns structured ParsedDateRange object
• Includes ClickHouse-specific fields

Common Patterns Copy Section

Date Range Patterns

• "Last 30 days" → 30 days ago to today
• "Last month" → Previous calendar month
• "MTD" → Month to date
• "YTD" → Year to date

Comparison Calculations

• Range-based: Shift boundaries by offset periods
• Dimension-based: Shift expressions by adding/subtracting intervals

When to Use What Copy Section

Use Normal Range when:

• Adding explicit date filters to components (date_range="Last 30 days")
• User selects a date range from a dropdown
• You want to filter the entire dataset

Use Dynamic Range when:

• Component has date_grain and you want period-over-period comparisons
• Data is already grouped by time periods
• Each row represents a different time period

Use Table Range when:

• Applying dashboard-wide date filters
• Multiple components need the same date range

Common Gotchas Copy Section

1. "Jan 1/70" in tooltips → Use MIN/MAX aggregates around date expressions
2. Comparison dates off by one → Check if you need the +1 day adjustment in processDateRange
3. Case sensitivity → All parsing is case-insensitive, but double-check your strings
4. MTD/YTD not working → Ensure you're using the startDateFunction from parseDateRange

Migration Notes Copy Section

• Eliminated generateDateSql wrapper function
• Consolidated calculatedateDimensionComparisonDateRange into main function
• Removed string parsing in favor of structured returns
• No backwards compatibility maintained (as requested)

Other Utilities Copy Chapter

• comparisons.ts - Comparison query generation
• sql-options.ts - SQL expression utilities
• format-options.ts - Value formatting helpers

Index (`docs/index.mdx`) Copy Section

title: What is Evidence?
keywords:

• business intelligence
• BI tool
• business intelligence and analytics (ABI)
• data products
• dashboards
• reporting platform
• analytics platform
• data visualization
• business intelligence tools
• SQL reports

Evidence is a business intelligence and analytics (ABI) platform for building data products with SQL, markdown, and AI. Use it as a BI tool to write SQL reports, build dashboards, and publish an analytics platform your team can explore. It's a reporting platform for data visualization — one of the business intelligence tools your whole organization can use. Evidence comes in two parts: an open-source framework you can run yourself, and a hosted platform built on top of it.

Evidence Core Copy Chapter

Evidence Core is an MIT-licensed framework for building data apps from SQL and Markdown. You write reports in Markdown with embedded SQL and components, query your own warehouse through direct connectors, and preview locally with the CLI. It builds to a static site you can self-host anywhere — Vercel, Netlify, Docker, or your own infrastructure. No account required.

Evidence Studio Copy Chapter

Evidence Studio is the hosted platform built on Evidence Core. Alongside everything in Core, it adds:

• A collaborative editor and publishing with preview deployments
• The Evidence Agent for building reports with AI
• Access rules and page-level access control for controlling who sees what
• Scheduled reports and embedded analytics

Studio-only pages in these docs are marked with a badge.

Getting Started Copy Chapter

Create your first report in minutes.

Learn More Copy Chapter

Build reports to share with your team.

Quickstart (`docs/quickstart.mdx`) Copy Section

title: 'Quickstart'
keywords:

• getting started
• build a dashboard
• business intelligence example
• business report example
• data analytics tutorial

Create an Account Copy Chapter

This quickstart is the getting started guide for Evidence — a hands-on data analytics tutorial that walks you through building a business report example from scratch, taking you from an empty report to a published page in under 5 minutes. By the end, you'll build a dashboard and have a working business intelligence example you can share with your team.

Cli Index (`docs/cli/index.mdx`) Copy Section

title: 'CLI' Copy Chapter

The Evidence CLI lets you run and develop Evidence projects locally from the command line.

It includes a development server for previewing your reports locally as you work, commands for running queries, viewing metadata, and validating your code.

If you are going to use the CLI for development, you should set up the GitHub Integration.

Install Copy Chapter

Installs to `/usr/local/bin` (falls back to `~/.local/bin` if not writable).

Installs to `%LOCALAPPDATA%\Evidence\bin` and adds it to your user PATH. Restart your terminal after install.

Both evidence and evd commands are available after install.

Supported Platforms Copy Section

• macOS arm64 (Apple Silicon)
• macOS x64 (Intel)
• Linux x64
• Linux arm64
• Windows x64

Verify Installation Copy Section

evidence version

Getting Started Copy Chapter

1. Create a project in Evidence Studio and connect it to a GitHub repo.
2. Clone the repo to your local machine.
3. Log in to your Evidence account via the CLI:
   bash Copy

   evidence login

4. Start developing from inside your cloned project directory:
   bash Copy

   evidence dev

5. Open a pull request on the repo. Evidence Studio will reply with a preview link. Merging the PR releases your changes.

Upgrade Copy Chapter

evidence upgrade

The CLI checks for updates on startup. If a newer version is available, you'll see a warning. If your version is below the minimum supported version, the CLI will require an upgrade before running.

Telemetry Copy Chapter

The CLI reports anonymous usage so we can tell how many people use Evidence, which commands matter, and which versions are still in the wild. Nothing about your data, queries, file paths, or repository is ever sent.

Opting out Copy Section

Any one of these turns telemetry off:

evidence telemetry disable      # persists in ~/.evd/telemetry.json
export EVIDENCE_TELEMETRY_DISABLED=1
export DO_NOT_TRACK=1           # the cross-tool convention

evidence telemetry status shows the current state and why. Telemetry is also skipped automatically on CI (CI, GITHUB_ACTIONS, GITLAB_CI, CIRCLECI, BUILDKITE, TF_BUILD, JENKINS_URL).

What is sent Copy Section

One cli_command event per invocation, one cli_installed event from the install script, and — for evidence serve only — a serve_heartbeat once every 24 hours so long-running deployments stay counted, plus a serve_preflight_failed event (with a reason such as no_connection_yaml) when serve refuses to start, so we can spot broken self-host deployments.

Requests carry your IP like any HTTP request; it is used for country-level geolocation only.

Project id Copy Section

evidence init writes a random telemetry.id into evidence.config.yaml. It identifies the project, not you or your machine, and is what lets us count a self-hosted deployment once rather than once per container restart. Delete the key to opt a project out of that count.

When you are logged in Copy Section

Commands that talk to Evidence Studio (launch, link, publish, models, and others) are authenticated API calls, and Studio records that your account and organization used the CLI, the same way it records use of the web app. Anonymous local usage is never linked to an account.

Mcp Overview (`docs/mcp/overview.mdx`) Copy Section

title: 'Overview' Copy Chapter

What is MCP? Copy Chapter

The Model Context Protocol is an open standard that enables AI applications to connect to external data sources and tools. Evidence provides two MCP servers.

Which one do I want? Copy Chapter

• Querying your own data and reports? Use the Studio MCP — it connects to your live workspace with your permissions.
• Developing reports? Use the Docs MCP — it searches the docs and component reference.

Self Host Index (`docs/self-host/index.mdx`) Copy Section

title: 'Self Host' Copy Chapter

Evidence projects can be self-hosted with the official Docker image.

The image runs evidence serve, which is similar to evidence dev but hardened as a production server.

Self-hosted projects must use a direct connector (configured in connection.yaml).

Docker containers can run on many platforms, major cloud providers or your own machine. See the below guides for some tested options:

• Vercel
• Render
• Fly.io
• Railway

Should you self host? Copy Chapter

Self hosting is appropriate if:

1. Your organization requires data does not leave your infrastructure
2. You have a hobby project and do not want to pay for a managed service

However, you should be aware that there are tradeoffs associated with self hosting Evidence projects:

• Several platform features (e.g. User Auth, Access Controls, Evidence Agents) are not built in
• There are no platform fees, but you will incur costs from infrastructure and maintenance
• You need to handle security, monitoring, and scaling on your own

Generic Docker Deployment Copy Chapter

Details may differ, but these steps are required for all Docker deployments.

1. Add a Dockerfile:

   docker filename="dockerfile" Copy

   FROM evidencedev/serve:latest
   COPY --chown=evidence:evidence . /project

2. Move secrets out of connection.yaml, replacing them with ${VAR} environment references

3. Commit connection.yaml (it is gitignored by default)

4. Add environment variables

   Env Var	Purpose	Required?
   EVIDENCE_BASIC_USER	HTTP Basic Auth username	Yes*
   EVIDENCE_BASIC_PASSWORD	HTTP Basic Auth password	Yes*
   ${VAR} references	All variables referenced in connection.yaml	Yes
   EVIDENCE_AUTH_DISABLED	Skip auth entirely on trusted private networks	-
   PORT	Port the server listens on (default: 3000)	-
   EVIDENCE_TELEMETRY_DISABLED	Turn off the anonymous startup event and daily heartbeat (details)	-

   * Unless auth disabled

5. Start the server

Self Host vs. Evidence Studio Copy Chapter

Self-hosting allows you to render your SQL + markdown into interactive reports — but the Evidence Studio platform has many additional features:

Authentication Copy Chapter

Self-hosted sites are protected by HTTP Basic Auth. The browser caches credentials in memory until the browser is exited (there is no logout button).

To force all viewers to re-authenticate, change EVIDENCE_BASIC_PASSWORD and redeploy.

For deployments only reachable over a trusted private network (VPN, Tailscale, internal VPC), set EVIDENCE_AUTH_DISABLED=true to skip authentication entirely.

To authenticate users against your organization's identity provider, deploy evidence serve behind an authenticating reverse proxy — see Authentication & SSO.

Changelog (`docs/changelog.mdx`) Copy Section

title: 'Changelog' rss: true Copy Chapter

{/* THIS FILE IS AUTOMATICALLY GENERATED - DO NOT MODIFY DIRECTLY */}

✨ AI chat in embedded reports Copy Section

Embedded reports can now show the Evidence AI chat, so your users can ask questions about a report without leaving your application. Embedding customers opt in per session with the enableAIChat parameter on the embed API.

🐛 Organization switching for viewers Copy Section

Fixed an issue that blocked viewers from switching organizations in the published app.

🚀 Big values fit two to a line on phones Copy Section

On phones, big values now sit two to a line instead of stacking one per line.

🚀 Render html blocks without a card Copy Section

On pages with card mode enabled, {% html card=false %} renders the block directly on the page background instead of inside a card.

✨ Preview pages at mobile width in the editor Copy Section

A new toggle on the editor's preview pane narrows the preview to phone width, so you can check how a page reads on mobile without resizing your browser.

• Mobile-specific behavior shows in the preview too: details honors open_mobile, and modals open as they would on a phone, inside the preview.
• dimension_grid now wraps based on its own width rather than the browser's, so it lays out correctly in narrow columns as well as on phones.

🐛 Stacked areas no longer have holes Copy Section

Fixed gaps in stacked area charts on date axes when a series has no data for some dates.

✨ Hide or show content in print without grouping it Copy Section

New {% hidden_in_print %} and {% only_in_print %} blocks control what appears in printed pages and PDFs, without the blank gaps print_group can leave.

🐛 Reopening an invitation link takes you to your organization Copy Section

Reopening an invitation you've already accepted while signed in now takes you into that organization instead of showing an error.

🐛 Improved PDF exports Copy Section

Fixed charts that could be missing from PDF exports.

✨ Commentary per input selection Copy Section

Commentary can now be kept separately for each selected value of one or more inputs, alongside the reporting period.

View Documentation

✨ Page download options Copy Section

Hide download options from a published page's menu with the downloads page setting.

✨ Period selector component Copy Section

Added a period selector input, which can also place a page's reporting period anywhere on the page.

View Documentation

✨ Print-only content Copy Section

Show content only in printed pages and PDFs with {% print_group print_only=true %}.

🚀 Improved row layout Copy Section

Rows can now spread their contents across the full width, for example a heading on the left and a button on the right.

View Documentation

✨ Generate Excel Report Copy Section

A new Generate Excel Report option exports the page as an Excel workbook with a snapshot of the report on the first sheet and a data sheet per component; Download Data now also appears in the CLI.

• Download Data is unchanged and still exports data only; pick Generate Excel Report when you want the report snapshot included.
• Hide it with downloads: { excel: false } in page frontmatter. It is also hidden when image or data downloads are turned off.
• The local CLI viewer now has Download Data and Generate Excel Report in its page menu.

🚀 Improved info tooltips Copy Section

Info tooltips now support text across multiple lines.

🐛 Improved date axis labels Copy Section

Improved the layout of date labels on chart axes.

✨ Attach files to reports Copy Section

Drop or paste a file into the editor to upload it and insert a file card showing its icon, name, type, and date.

🚀 Set down_is_good for a whole page Copy Section

Add down_is_good: true to a page's frontmatter to treat decreases as good for every delta on that page.

• Applies to big_value, delta, and table delta columns. A component's own down_is_good still overrides it.
• down_is_good=true on a benchmark_comparison or target_comparison option is now respected when a component uses that comparison_selector.

🐛 Tables inside repeat blocks now read page inputs Copy Section

A table inside a {% repeat %} block now resolves page inputs referenced in its where, having, order, and qualify attributes instead of running with the value missing.

• Previously the table only looked at the repeat's own scope, so {{my_input}} in these attributes interpolated as empty and the query failed with a syntax error.
• Titles and other text attributes on the same table also resolve page inputs correctly now.

🐛 CLI runs direct-connector projects without reaching Evidence Studio Copy Section

evidence dev no longer refuses to start when evidence.studio is unreachable for projects with a connection.yaml, evidence upgrade now works on Windows, and the home page honours page_width and cards like every other page.

• Projects with a connection.yaml skip the Studio reachability check entirely; projects on the Evidence Warehouse get a warning (with the failure reason and a proxy hint) instead of a hard exit.
• evidence dev prints which mode it is in — direct connector or managed warehouse — so it is clear whether a login is needed.
• evidence upgrade supports Windows x64 and Linux arm64, keeps evd.exe in sync on Windows, and points to the installer when the update check fails.
• evidence serve is listed in evidence help.
• pages/home.md now respects page_width, cards, table_of_contents and frontmatter theme, matching subpages.

🐛 Viewer log out fix Copy Section

Fixed logging out from a published report showing a "Page not found" error and leaving you signed in.

🚀 Details start state on mobile Copy Section

The details component has a new open_mobile attribute to choose whether it starts open or collapsed on mobile screens, independently of open

View Documentation

✨ Validation summary in the editor Copy Section

A new indicator in the editor toolbar shows how many validation errors are on the open file. Click it to see every error with its line number, and click an error to jump to it in the editor.

• Covers component errors, inline SQL query errors, and config file (yaml) validation.
• Each entry is labeled with the component, query, or config key it belongs to.
• Clicking an error scrolls the editor to the line and highlights it.

🐛 CLI keeps input selections in the URL Copy Section

Input components in evidence dev and self-hosted CLI pages now write their selections to the URL and restore them from it, so filtered views can be refreshed, bookmarked and shared like in Studio.

🐛 Commentary save fix Copy Section

Fixed an issue where some commentary saves did not persist.

View Documentation

🐛 Filter defaults no longer appear in URL Copy Section

A table_filter with initial_values no longer writes its default into the page URL, so other pages keep showing their own data instead of inheriting that default and filtering against the wrong values.

✨ Commentary supports workflow periods Copy Section

Commentary components can now keep separate notes for each reporting period with scope="period".

• Period-scoped commentary follows the page's workflow.period picker, including in PDF renders.
• Commentary without scope remains page-wide.

View Documentation

✨ Waterfall chart Copy Section

The waterfall_chart component is now available - useful for growth decomposition, revenue bridges, and reconciliations

View Documentation

✨ Search team members Copy Section

Filter your team settings page by name or email with a new search field.

🐛 Slack channel picker finds every channel the bot is in Copy Section

Fix the scheduled report Slack channel dropdown missing channels the Evidence bot had joined in large workspaces with many channels.

🚀 Improved content selection in PDF download menu Copy Section

Simpler click behaviour to select and deselect content in nested sections.

🐛 Table cells only merge within their parent group Copy Section

Fix table dimension cells merging across rows whose parent dimension values differ, such as after sorting by a measure.

🚀 Resume GitHub Enterprise connections Copy Section

GitHub Enterprise Cloud connections can now resume after another organization owner installs the app, with clearer errors and controls for unfinished attempts.

• Finish connecting from GitHub integration settings when the installation callback is missed.
• Allow up to seven days for installation after app registration.
• Resume or cancel an unfinished connection instead of creating another app on each retry.
• See an error message and request ID when a connection needs support.

✨ Reporting periods Copy Section

Turn a page into a periodic report with a workflow.period block in frontmatter.

• Adds a period picker at the top right of the page, listing complete calendar periods (day, week, month, quarter or year)
• The selected period is available as the period variable — {{ period.label }} in markdown, {{ period.between }} in SQL
• Only finished periods are offered, so a published report doesn't change while its period is still running
• The selection is kept in the URL, so a link points at a specific period

View Documentation

🐛 Dropdown options on Cube Copy Section

Fix data-driven dropdowns returning no options when connected to a Cube warehouse.

✨ Scheduled report using email or Slack Copy Section

Scheduled report using email or Slack

View Documentation

✨ More control over color scales Copy Section

Color scales in tables and map layers now support diverging midpoints and custom value-to-color breakpoints, and behave consistently across both.

• Set midpoint to anchor a diverging scale at a value such as 0, and min/max to fix the scale bounds.
• Use color_stops to pin specific colors to specific values.
• Diverging scales stay correct even when every value falls on one side of the midpoint.

🚀 Improved error display Copy Section

Components now display syntax and query errors more prominently in the editor.

🐛 Reliable map layer filter updates Copy Section

Area, point, and heatmap layers now reliably update when filters change their data.

🐛 Table filter values on Snowflake Copy Section

Fix the table filter returning no selectable values on Snowflake and other uppercase-folding warehouses.

✨ Folder-Level Access Rules Copy Section

Add folder-level access rules to access.yaml — grant or restrict every page in a directory subtree with a single entry.

✨ Scheduled Reports Copy Section

Email reports to your users on a regular schedule, or send one-off reports on demand.

View Documentation

✨ Access Viewer AI inside Slack Copy Section

Connect a Slack workspace in Integration settings and message the Evidence bot to get answers from your data without leaving Slack.

• An admin adds the app from Settings → Integrations → Slack, then each person connects their own account — the bot only reads what you can already see.
• Direct message the bot, or @mention it in a channel.
• Answers can display charts, save insights to your library, and link back into Evidence.
• Admins can turn the bot off for the whole organization, and choose whether each person's first answer in a channel is shown to them before the channel sees it.

🐛 Partial filter initial values now apply on parent pages Copy Section

Fixed an issue where filter initial values defined in partials could be empty when rendered on parent pages.

🐛 Filters load in partial page previews Copy Section

Filters in partials now load when using View another page in the editor.

🐛 Link buttons support relative page URLs Copy Section

Link buttons now navigate correctly with portable relative URLs across edit, preview, and published reports.

🐛 Table filters close safely without selections Copy Section

Table filters now remain visible when a numeric or date picker is closed without a selection.

🐛 Sorting a table by a column it does not show Copy Section

Sorting a table by a column that is not one of its dimensions or measures no longer splits the rows into extra groups, and no longer fails on Postgres, Fabric and Cube.

🐛 ClickHouse conditional aggregates Copy Section

Fix sumIf and its -If siblings breaking date-filtered measures and comparison targets on ClickHouse, and no longer warn that they are missing an aggregation.

🐛 Snowflake table conditional colors Copy Section

Fix conditional colors on table dimensions in Snowflake for literal colors and SQL expressions.

🐛 Sorting a table by a grouped date column Copy Section

Sorting a table by a date column that has a date_grain now sorts by the grouped date instead of failing with a grouping error.

• order="my_date desc" alongside {% dimension value="my_date" date_grain="day" /%} sorted by the raw column, which the warehouse never grouped. ClickHouse rejected the query and the table rendered empty.
• A hidden sort column on a table with subtotals is now aggregated, so it no longer breaks the subtotal and total rows.

🐛 Creating files and folders is disabled on protected branches Copy Section

The sidebar's create page, partial, SQL, component, folder, and agent-file actions are now disabled when the current branch is protected on GitHub, matching the existing branch-protection guard on Commit.

✨ Bring your own model API key Copy Section

Enterprise organizations can now point both AI agents at their own OpenAI, Anthropic, AWS Bedrock, or Google Vertex account from Settings → AI Agent.

• Both the editor agent and the viewer agent use your provider and model, so your provider bills you for inference directly and Evidence AI credits are neither consumed nor charged.
• Credentials are stored in the WorkOS Vault and never sent back to the browser. Saving verifies the credential against your provider first, so a wrong key or model ID is rejected rather than stored.
• There is no fallback to Evidence's models: if your credential stops working, chat reports a clear error instead of quietly switching back and billing you for credits.

🚀 Big value titles are clickable when linked Copy Section

Setting link on a big value now turns the title into a styled link instead of the number, matching typical score card conventions.

✨ Metrics Copy Section

Evidence now has a metrics layer. Define metrics in metrics/*.yaml and reference them in charts and tables. Ask the agent to build one for you to get started.

✨ MCP Visualize Tool Copy Section

The Evidence Studio Claude Connector and ChatGPT Plugin can now generate charts inline in the chat with the new visualize tool.

✨ Reports page for run history and schedules Copy Section

A new top-level Reports page (next to Models) for viewing report run history and managing schedules.

• History tab: View all report runs with status, trigger type (manual/schedule/API), author, timing, and recipient count
• Schedules tab: View and manage recurring report schedules with pause/resume and delete actions
• Admin-only actions: Pause/resume schedules, delete schedules, re-run past reports, download PDFs
• Developer access: Developers (members) can view the page; admins can take all actions
• Entitlement gate: Available on Team, Pro, and Enterprise plans

View Documentation

✨ GitHub Enterprise Cloud support Copy Section

Enterprise organizations can now connect Evidence Studio and the Evidence CLI to GitHub Enterprise Cloud accounts hosted on dedicated *.ghe.com domains.

• Create and install a private, organization-owned GitHub App through Organization Settings.
• Select accessible enterprise repositories in Project Settings and use Studio branches, pull requests, checks, and publishing as usual.
• Run evidence launch or evidence link from HTTPS and SSH GHE.com remotes.

🐛 Feature request dialogs remain accessible with long descriptions Copy Section

Feature request dialogs now constrain long descriptions to a scrollable area so their controls remain accessible.

🐛 Table links now work in fullscreen reports Copy Section

Table links now navigate to their destination while viewing a report in fullscreen presentation mode.

✨ MotherDuck direct connector Copy Section

Connect Evidence directly to a MotherDuck database to build reports on live data without syncing it first.

View Documentation

✨ Custom Maps Copy Section

Use the custom_map component to build fully customized maps with Mapbox GL or MapLibre GL.

• Write map code directly in the component body — pull page data with evidence.query, read and write page filters, and react to variables and theme changes.
• No key needed by default: keyless MapLibre out of the box, or Mapbox using Evidence's shared token under the hood.
• Import map-ecosystem plugins (mapbox-gl-draw, deck.gl, turf, and more) straight from a CDN.

🐛 Custom HTML and ECharts blocks work in the CLI Copy Section

{% html %} and {% custom_echart %} blocks now render when running a project locally with the Evidence CLI.

• Both blocks previously rendered blank in evidence dev — the sandbox runtime they load was only built by the hosted app, so the CLI served nothing for it
• Requires CLI v0.7.4 or later
• If a sandbox runtime is ever missing, the block now reports an explicit error instead of staying blank

🚀 AI chat now consumes far fewer credits Copy Section

We've significantly reduced how many credits AI chat consumes, so your balance goes much further.

✨ Cube Connector Copy Section

Connect Evidence directly to your Cube semantic layer through its Postgres-wire SQL API.

• Query your cubes and views live from Evidence — metrics stay defined in Cube.
• Configure it in Connectors → Warehouse → Cube (host, port, user, password, SSL), or via connection.yaml (type: cube) in the CLI.
• The SQL editor validates expressions against Cube's documented function subset, so unsupported functions are flagged before you run a query.

✨ PDF "Use page colors" option Copy Section

Preserve the exact colors from your page when generating PDFs.

• New "Use page colors" checkbox in the PDF settings modal (Cmd+P)
• When enabled, PDFs retain the theme's actual background colors (including dark mode or custom theme backgrounds)
• When disabled (default), PDFs use white backgrounds optimized for printing
• Preview updates to show how the PDF will look with the selected option

✨ Postgres Direct Connector Copy Section

Connect Evidence directly to Postgres — including Amazon RDS/Aurora, Supabase, Neon, and Timescale — and query it live.

• Add Postgres under Settings → Warehouse: enter host, port, database, user, password, and SSL mode, test the connection, and save.
• Works with any Postgres-wire source: generic Postgres, Amazon RDS / Aurora, Supabase, Neon, and Timescale.
• Full SSL/TLS support with disable / require / verify-ca / verify-full modes, plus an optional CA bundle and mutual-TLS client certificate.
• The schema browser lists tables, views, and materialized views.
• Also available from the CLI via connection.yaml (type: postgres) or evidence init --warehouse postgres, with certificates referenced by file path.

✨ Search across your reports with Cmd+K Copy Section

Press Cmd/Ctrl+K to instantly search across every report you have access to.

✨ Viewer AI & Insights Copy Section

Report viewers can now ask questions of your data in a chat assistant and save the answers as insights to revisit later.

🐛 Fixed editor inserting characters at the wrong position on older reports Copy Section

Typing in the editor now appears where you clicked on reports created before mid-2026.

✨ Evidence Studio MCP Server Copy Section

Search your reports and query your data from your favorite AI client. Connect Claude, ChatGPT, and other MCP clients to your live Evidence workspace — every request runs as the signed-in user, so access policies and page controls are respected.

View Documentation

🐛 CLI dev server no longer crashes when a subfolder has an index.md Copy Section

Nested index.md / home.md / README.md files are no longer treated as the home page in the sidebar, so evidence dev renders normally instead of crashing with a duplicate-key error when a project has a root home page plus an index.md in a subfolder.

✨ Point Map Clustering Copy Section

You can now include up to 100,000 points in a point layer by using cluster=true. Nearby points are grouped into aggregated bubbles that split apart as you zoom in, so large datasets stay fast and readable.

✨ 50 New Data Connectors Copy Section

Connect 50 more data sources to Evidence, including Zendesk, Intercom, Mixpanel, Amplitude, Square, QuickBooks, Recurly, Pipedrive, Gong, LinkedIn Ads, and more. Set them up in a few clicks from the Connectors page.

✨ 50 More Data Connectors Copy Section

Another 50 data sources are now available, including Jira, Airtable, Asana, Notion, Slack, Klaviyo, Mailchimp, Braze, SendGrid, TikTok Ads, Amazon Ads, Google Search Console, ServiceNow, and Okta. Set them up in a few clicks from the Connectors page.

✨ Lemlist Connector Copy Section

Connect your Lemlist data to Evidence. Sync campaigns, leads, and activities from your email outreach.

View Documentation

🚀 Improved chart x-axis and tooltip labels Copy Section

Better handling of dates and numbers on chart x-axes and tooltips.

✨ Table Access Restrictions Copy Section

Restrict tables to a chosen set of users

Restrict specific tables to a chosen set of users from the Access Rules settings page. Unrestricted tables stay open to everyone in the organization, and restricted tables show a lock badge in the editor's schema list.

View Documentation

✨ Image component accepts data queries Copy Section

Add data and column props to the image component to load the image URL from a query and respond to filter changes — e.g. show the top-selling product's photo, a client logo driven by a dropdown, or a dark-mode variant via dark_column.

✨ Radar, Treemap, and Chord charts Copy Section

Three new charts now available: radar_chart, treemap, and chord_chart

✨ Mix single and multi select columns in table filters Copy Section

Add single_select and multi_select to table_filter to set the selection mode per column — e.g. restrict a client column to one value at a time while keeping region and product filters multi-select.

🐛 Y-axis titles stay legible above chart data Copy Section

Chart contents no longer overlap the y-axis title — bars, areas, and lines that reach the top of the axis now render beneath the title instead of covering it. Gridlines are cut off cleanly behind the title rather than showing through the text, the title is vertically aligned with the top axis tick label, and a subtle text outline keeps it readable when data passes directly beneath it. Applies to both left and right (y2) axis titles.

🐛 range_calendar "all time" no longer breaks raw SQL Copy Section

Referencing {{ date_filter.between }} in a where or SQL template while "all time" was selected previously produced an empty string, which broke the query (where date → syntax error). .between now emits IS NOT NULL for "all time", so where="date {{ date_filter.between }}" matches all rows and just works.

The new all_time_range attribute controls what "all time" means for a specific range_calendar:

• all_time_range="none" restores the previous empty-string behavior — pair it with [[ ]] conditional blocks or a | fallback when the whole clause should drop (e.g. to keep NULL-date rows, which IS NOT NULL otherwise excludes).
• Set it to a bounded range — a preset key ("last 12 months"), a custom_ranges label, or a range expression ("from 2022-12-01") — and "all time" resolves to that range everywhere (.between, .start, .end, and the date_range value). If you were faking this with a | fallback in your where clause, set all_time_range to that range and delete the fallback.

.start / .end stay empty for unbounded "all time" (so date spines and axes fail loudly rather than silently wrong), and .filter / a filters=[...] reference stay a true no-op that keeps NULL rows.

🐛 Fix for AI chat losing conversation context Copy Section

Fixed an issue where the AI chat could respond to an earlier message in long conversations instead of the one you just sent.

🐛 Sparkline hover values now use theme foreground Copy Section

Sparkline hover values and the vertical tracking line follow the theme's foreground and muted-foreground tokens, restoring contrast in light mode (most visible on big_value sparklines).

✨ AI Agent Multi-File Edits Copy Section

The AI dev assistant can now edit multiple files in a single turn — as well as create, rename, and move files.

✨ Extra tooltip rows on chart series Copy Section

Add tooltip_fields to any bar_chart / line_chart / area_chart / scatter_chart / bubble_chart — or to bar, line, area, scatter, bubble inside a combo_chart — to surface additional aggregated values on hover, with optional labels, format codes, and color_by_sign / down_is_good for delta-style coloring.

✨ Link charts together Copy Section

Add connect_group to charts to sync their tooltips, axis-pointer, and zoom across any charts sharing the same id — e.g. stack a price chart above a volume chart, align KPIs that share a time axis, or coordinate small multiples.

✨ Customize built-in charts with ECharts options Copy Section

Override any ECharts option on built-in charts via echarts_options (chart-wide) or echarts_series_options (looped across every series).

✨ Attach images to editor AI chat Copy Section

Click the image button in the editor chat composer to attach screenshots or other images for the AI agent to see alongside your message.

✨ Custom components Copy Section

Build your own Markdoc tags from components/*.md files — each component declares its attributes in frontmatter and gets autocomplete, slash-command, and AI-tool support just like a built-in.

✨ Pin color scale values in tables Copy Section

Anchor a measure's color scale to specific data values with color_stops.

✨ Custom HTML in reports Copy Section

Embed your own HTML and JavaScript anywhere in a report with the new {% html %} block. Build custom visualizations that integrate with Evidence's filters, queries, and theme — using any library, like D3 or deck.gl.

🐛 Hide unneeded subtotal rows in tables Copy Section

Tables now hide duplicative subtotal rows that only summarize a single item, while keeping the grand total.

✨ Expanded theme options Copy Section

Themes now include fonts, colors, corner roundness, spacing density, and chart defaults, applied consistently across the whole report. Override the theme for a single page when you need to.

✨ Custom date ranges Copy Section

Add custom_ranges to {% range_calendar %} to generate named presets — e.g. fiscal years, seasons, and retail calendars.

🐛 Smoother schema panel refresh Copy Section

The refresh button no longer pushes content down or hides the schema list while reloading, and long table or column names truncate instead of forcing horizontal scroll.

✨ Show size dimension in bubble and scatter chart tooltips Copy Section

Bubble and scatter chart tooltips now display the size dimension value, with a new size_fmt attribute for formatting.

🐛 Faster, more reliable editor preview on heavy pages Copy Section

Fixed an issue where the editor could lock up on pages with many charts and tables.

🐛 Fix heatmap collapsing at wider screen widths Copy Section

Fixed heatmap charts collapsing into a small box at certain screen widths.

✨ Impersonate Copy Section

Create and manage access tokens for programmatic API access from the new Access Tokens settings page. Admins and developers can impersonate team members to see exactly what they see (disabled by default).

🐛 Fix dropdown search failing on BigQuery Copy Section

Fixed an issue with searching a dropdown or table filter for BigQuery direct connections.

✨ Failed Publishes No Longer Affect Viewers Copy Section

If a publish fails, your project keeps serving the last successful version — viewers never see broken content.

🐛 Fix spurious markdown validation errors on PRs Copy Section

Fixed the PR markdown-validation check reporting false-positive undefined-translation-key and undefined-frontmatter-variable errors on pages using translations and on partials that receive variables from the pages including them.

✨ Publish History & Rollback Copy Section

View your project's publish history and roll back to any previous version.

✨ ClickHouse direct connector Copy Section

Connect Evidence directly to your own ClickHouse instance to build reports on live data without syncing it first.

View Documentation

✨ Make the selected option in `button_group` and `input_tabs` more noticeable Copy Section

The selected button in button_group and the active tab in input_tabs now stand out more clearly.

✨ New share menu and additive page access Copy Section

The redesigned share menu lets you grant page-level access on top of project access, so you can share a single dashboard with a stakeholder who shouldn't see anything else.

✨ Vibe code any visualization with the custom_echart component Copy Section

Need a chart Evidence doesn't have out of the box — a waterfall, a bridge, a radar, something bespoke? The new custom_echart component lets you build any visualization you can imagine. Describe what you want to the assistant and it writes the chart for you, wired up to your data, filters, and theme automatically.

✨ Pre-select the top N options in a multi-select dropdown Copy Section

Multi-select dropdowns now accept a default_top_n attribute that pre-selects the first N options on load. Combine it with order to control which N are selected by default — which viewers can then change.

✨ New Publish Menu in Editor Copy Section

View pending changes and open pull requests directly from Studio.

✨ See what each user, group, and customer can access Copy Section

Admins and developers can now see every project and page a user, group, or customer can access, plus how that access was granted.

🐛 Share menu now lets you grant page access to any team member Copy Section

The Page tab of the share menu now lists every internal team member, so you can grant page access directly without first adding them to the parent project.

🚀 Add users to groups when inviting, and see group memberships in the team table Copy Section

Admins can now pick groups when inviting or manually creating users, and the Team settings page shows each member's group memberships in its own column.

🚀 HubSpot Connector Copy Section

Updated the HubSpot connector with more reliable syncs and broader table coverage.

View Documentation

✨ Microsoft Fabric direct connector Copy Section

Connect Evidence directly to a Microsoft Fabric Warehouse or Lakehouse SQL endpoint to build reports on live data without syncing it first.

View Documentation

🐛 PDF exports preserve dropdown filter values Copy Section

PDF exports of pages with a select_first=true dropdown no longer revert the filter to its auto-selected default when the URL specifies a different value.

✨ Map area layer min, max, and midpoint Copy Section

Map area_layer and point_layer now accept min, max, and midpoint props so you can pin a diverging color scale at zero (or any other value).

🐛 Fixed bar chart tooltip not displaying point_title Copy Section

Fixed an issue where the point_title attribute on bar, line, and area charts was ignored in the tooltip.

✨ File change indicators in editor sidebar Copy Section

Files with uncommitted changes now show colored status badges (M/A/D) in the editor sidebar file tree, so you can see which files have been modified without switching to the Version Control tab.

✨ Copy link to pages Copy Section

Copy a shareable link to the current page from the page menu, with option to include the current filters.

✨ Download report as PNG Copy Section

Save a full page as a PNG image from the page menu.

🚀 Dedicated Groups settings page Copy Section

Groups now have their own page under Settings → Groups, separate from team members, with a detail view for managing each group's members and access.

✨ Snowflake and BigQuery direct connectors Copy Section

Link Evidence to Snowflake or BigQuery directly to build reports without syncing data.

View Documentation

🚀 Improved discoverability of date input components in AI chat Copy Section

Added search keywords to range_calendar, date_grain_selector, and comparison_selector so the AI assistant can find them when users ask for "date range filter", "date picker", "date input", etc.

🚀 Long chart label rotation Copy Section

Charts now rotate long x-axis labels automatically so category names are easier to read without hovering.

🐛 Map area layer filter updates Copy Section

Fixed a bug where area charts did not respond to filter changes.

🚀 Data download title filenames Copy Section

Data downloads now use titles in file names.

🐛 Horizontal bar chart axis bound validation Copy Section

The horizontal_bar_chart now reports a validation error when x_axis_options.min is greater than or equal to x_axis_options.max.

✨ Evidence CLI now available on Windows Copy Section

The Evidence CLI now ships a Windows x64 binary, installable via PowerShell: irm https://gaamozau3jchzs3r.public.blob.vercel-storage.com/cli/install.ps1 | iex.

View Documentation

🚀 Default tab selection Copy Section

Add default=true to a {% tab %} to pre-select it on page load instead of always defaulting to the first tab.

🐛 Data labels render on area and line charts Copy Section

Fixed data_labels not appearing on area_chart, line_chart, and combo_chart line/area series.

✨ Add today and yesterday range calendar presets Copy Section

Range calendars can now opt into Today and Yesterday preset ranges.

🚀 Faster Page Create and Rename Copy Section

Creating, renaming, and reorganizing pages and folders in the editor sidebar is noticeably faster.

🐛 Mobile sidebars close after navigation Copy Section

Fixed mobile sidebars staying open after selecting a navigation link.

🐛 Improved SQL file support in GitHub integration Copy Section

Improved how SQL files sync between Studio and GitHub.

🐛 Branch-aware link autocomplete and validation Copy Section

Editor link autocomplete and validation now include pages that exist only on the current branch, and AI chat no longer flags them as broken.

🐛 AI chat current date awareness Copy Section

Fixed AI chat date context so the agent knows today's date when answering in editor and viewer chats.

🐛 Locally-authored pages now appear in Studio Copy Section

Fixed an issue where files created locally and synced to GitHub were not appearing in Studio.

🐛 Stable heading logo sizing Copy Section

Fixed an issue where logos inside headings could briefly render at the wrong size on page load.

🐛 Fix unquoted variables in partial attributes Copy Section

Fixed an issue where unquoted variable references in component attributes failed when rendered from partials.

🐛 Fix x_sort="data" imposing an x-axis sort Copy Section

Fixed an issue where setting x_sort="data" on bar and line charts still sorted by the x-axis instead of preserving the source query's row order.

🐛 Embedded page centering without TOC Copy Section

Fixed an issue where embedded pages could stay shifted to the left after the table of contents was turned off.

🐛 Stable logo sizing on load Copy Section

Fixed an issue where logos in headings could briefly render at the wrong size while the page was loading.

🐛 Improved models table readability Copy Section

Fixed an issue where the models table was not sorted by name by default and long descriptions were hard to scan.

✨ Select content for PDF exports Copy Section

Choose which sections and components to include when exporting a PDF.

🐛 Source failure modal fix Copy Section

Fixed an issue where opening a failed source status could show a blank blocking modal instead of the failure details.

🚀 Longer AI chat sessions Copy Section

Increased the maximum AI chat response time so longer agentic conversations no longer time out.

🚀 Collapsible projects in published and preview sidebars Copy Section

Projects in the sidebar can now be collapsed and expanded by clicking the project name, with state persisted across sessions.

🚀 Table Actions Copy Section

Download and Fullscreen buttons now available in Table footers.

🚀 Claude Opus 4.7 Copy Section

The Evidence agent now uses Claude Opus 4.7 by default.

✨ Connector renaming Copy Section

You can now rename connectors directly from the connectors page or the connector detail page by clicking the pencil icon next to the name.

🐛 Dropdown search now handles nullable values safely Copy Section

Fixed an issue where searching in a dropdown could fail when the value or label column contained empty values.

✨ Data lineage Copy Section

See where your connectors and tables are used across projects, pages, models, and queries. Available in the connectors page, connector detail pages, models page, AI chat, and the CLI.

🚀 Resizable SQL console schema panel Copy Section

The SQL console schema panel can now be resized by dragging its edge so long table names are easier to inspect.

✨ Connector and model health status Copy Section

Connectors page now shows health status and sync schedule for all connector types. New connectors and models CLI commands let you check health statuses from the command line.

🐛 Fixed theme settings loading state while editing colors Copy Section

Fixed an issue where editing theme color values could cause a broken loading state in settings.

🐛 Fixed inline SQL editor query references Copy Section

Fixed an issue where inline SQL editor queries could fail when referencing other inline queries.

🐛 Fixed unexpectedly large branch diffs Copy Section

Fixed an issue where small edits in Git-connected branches could appear as much larger diffs than expected.

🐛 Fixed stacked combo charts on time-based axes Copy Section

Fixed an issue where stacked combo charts on time-based axes could render blank or incorrect series data.

🐛 Fixed filter bar not floating on scroll in published pages Copy Section

Fixed an issue where the filter bar would not stay pinned to the top of the page when scrolling in published mode.

✨ Usage Analytics Copy Section

Track how your team uses Evidence with built in analytics tables for sessions, users and page views.

🐛 AI theme updates apply instantly Copy Section

Fixed an issue where theme changes made by the AI assistant only appeared after a page refresh.

✨ Audio Component Copy Section

Embed an audio player in your reports with {% audio url="..." /%}. Supports mp3, wav, ogg, and other formats, with options for looping, autoplay, and preload behavior.

🐛 Calendar heatmap dark mode colors Copy Section

Fixed an issue where calendar heatmaps could show white empty-day cells in dark mode instead of blending with the page or card background.

✨ Conditional colors for dimensions and rows Copy Section

Apply conditional background colors to entire rows or individual dimension cells using SQL expressions.

🐛 Fixed table SQL error overlay spacing Copy Section

Fixed an issue where table SQL errors could overlap content below the table.

🐛 Expanded background color options for AI theme updates Copy Section

Expanded the background color options the AI agent can change in theme updates.

✨ YouTube Analytics Connector Copy Section

Connect your YouTube Analytics data to Evidence. Sync channel reports, content owner reports, and metadata tables.

View Documentation

🐛 Fixed combo chart SQL with toggle-driven inline queries Copy Section

Fixed an issue where combo charts could fail when inline queries used toggle values in SQL conditions.

✨ Multiplayer editor Copy Section

Collaborate with your team in real-time with live cursors and presence indicators.

✨ Axis titles for heatmaps Copy Section

Heatmaps now support x_axis_title and y_axis_title so you can label both axes directly on the chart.

🐛 Fix for table column groups with link attribute Copy Section

Fixed an issue where adding a link attribute to a table dimension would cause all column groups to disappear.

🐛 Fixed spacing in the back-to-partial label Copy Section

Fixed an issue where the "Back to partial" label appeared without a space in preview mode.

🐛 Horizontal bar chart axis min/max now apply exactly Copy Section

Fixed an issue where x_axis_options.min and x_axis_options.max on horizontal bar charts could be ignored instead of enforcing the requested axis range.

✨ SAP HANA Connector Copy Section

Connect your SAP HANA data to Evidence. Sync data from SAP ECC and SAP S/4HANA systems running on the HANA platform.

View Documentation

🐛 Fix slider lockup with invalid step values Copy Section

Fixed an issue where sliders could freeze the page when configured with an invalid step value.

✨ Third-party analytics for published pages Copy Section

You can now add your own Google Analytics (GA4) or PostHog tracking to published and embedded pages. Configure your analytics provider in Organization Settings under Third-Party Analytics. Available on Enterprise plans.

🚀 Collapsible folders in published and preview sidebars Copy Section

Added click-to-expand and collapse behavior for sidebar folders in published and preview pages to make navigation easier in larger projects.

✨ Added This Month and Next Month date presets Copy Section

Range calendars now support this month and next month presets so you can filter full calendar months including upcoming dates.

🐛 Dropdown options now support numeric values for initial selection Copy Section

Fixed an issue where dropdown initial values could fail to apply when option values were provided as numbers.

🚀 Loading indicator for map components Copy Section

Map components now show a loading indicator while map data is being fetched so blank maps are less confusing during slow queries.

🐛 Fix for occasional AI chat timeouts Copy Section

Fixed an issue where the AI agent could appear to run out of time when working with large queries.

🐛 Fix for table search Copy Section

Fixed an issue where searching in tables could produce errors or fail to recover after clearing a search.

🐛 Fix table sorting when subtotal rows are hidden Copy Section

Fixed an issue where sorting by measure columns in tables could produce incorrect order when subtotal rows were hidden.

🚀 Add mmm-yy date format Copy Section

Added a built-in mmm-yy format code so dates can be displayed as month and two-digit year, like Jan-22.

🐛 Fix mobile sidebar close animation flicker Copy Section

Fixed an issue where the sidebar would briefly flash back into view at the end of its close animation on mobile devices.

🚀 Resizable Sidebar Copy Section

The sidebar can now be resized by dragging its edge.

🐛 Comparison column formatting fix Copy Section

Fixed an issue where prior period comparison columns in tables did not apply the same number format as the main value column.

✨ Evidence CLI Copy Section

Develop Evidence Studio projects locally from the command line with evidence dev.

View Documentation

🐛 Improve filter value visibility in the editor sidebar Copy Section

Fixed an issue where filter values in the editor sidebar could be hard to read by showing each value on its own line.

🐛 Recent AI chats update instantly Copy Section

Fixed an issue where new AI chats would not appear in Recent chats until the page was refreshed.

🐛 Improved spacing for small tables Copy Section

Fixed an issue where tables with only a few rows could show unnecessary empty space.

🚀 Clearer error when defining queries inside components Copy Section

Added a validation error when inline queries are defined inside components like tabs, accordion, or details. Queries should be defined at the top level of the page.

🐛 Accordion items now maintain their original order Copy Section

Fixed an issue where accordion items could reorder themselves based on when they were last updated instead of their original document order.

🐛 Support for branch names with slashes in GitHub integration Copy Section

Fixed an issue where branches containing slashes (e.g., feature/my-branch) would break navigation across the editor, preview, published views, and PDF generation.

🐛 Button group and dropdown initial value fix Copy Section

Fixed an issue where button groups and dropdowns could not set an initial value when using a numeric value column.

🐛 Fixed organization logo display in dark mode on published pages Copy Section

Fixed an issue where the organization logo in the sidebar could appear as a dark image on a dark background when viewing published pages in dark mode.

🚀 Option to hide axis title arrow Copy Section

Added a title_arrow option to x_axis_options that lets you hide the arrow (→) on chart axis titles.

🚀 Demo data table references updated Copy Section

Demo data tables have moved to the demo schema (e.g. demo_daily_orders → demo.daily_orders). You may need to update references in existing projects and models.

🐛 Fixed model save failing after validation Copy Section

Fixed an issue where saving a model could fail if the SQL query contained leading or trailing whitespace.

🐛 PDF downloads from editor now use working version Copy Section

Fixed an issue where downloading a PDF from the editor would always produce the committed version instead of the current working draft.

🐛 Print group cards spacing fix Copy Section

Fixed an issue where wrapping components in a print group with cards layout enabled would remove the spacing between cards.

🐛 Google Analytics setup links to Evidence docs Copy Section

Fixed an issue where the Google Analytics connector setup page linked only to the Fivetran docs instead of the Evidence docs page.

🚀 More reliable PDF generation Copy Section

Improved PDF generation reliability, especially for pages with conditionals, partials, and many components.

🐛 PDF downloads from preview now use working version Copy Section

Fixed an issue where downloading a PDF from the preview route would always produce the published version instead of the working draft.

🐛 Fixed chart rendering error on published pages with point_title Copy Section

Fixed an issue where charts using the point_title attribute could fail to render on published pages.

🐛 Fixed scatter chart tooltip with point_title and series Copy Section

Fixed an issue where the point_title attribute on scatter charts was ignored in the tooltip when a series attribute was also set.

🐛 Fixed scatter chart size attribute Copy Section

Fixed an issue where the size attribute on scatter charts was ignored, causing all points to render at the same size.

✨ Date range support for map layers Copy Section

Map layers (point_layer, area_layer, and heatmap_layer) now support the date_range attribute for filtering data by time period.

✨ PayPal Connector Copy Section

Connect your PayPal data to Evidence. Sync transactions, invoices, payments, subscriptions, and billing plans.

View Documentation

🚀 Connection string autofill for PostgreSQL connections Copy Section

You can now paste a PostgreSQL connection string into any field when setting up a PostgreSQL connection, and all fields will be automatically filled in.

✨ RevenueCat Connector Copy Section

Connect your RevenueCat subscription data to Evidence. Sync subscribers, transactions, entitlements, offerings, and products.

View Documentation

🚀 Invite team members from the Share menu Copy Section

Added a quick link to Team Settings from the Share menu so you can invite new team members while managing page or project access.

🐛 Fix for dimension grid with inline queries Copy Section

Fixed an issue where the dimension grid component could not use inline SQL queries as its data source.

🐛 Fix legend color for lines with explicit color in combo charts Copy Section

Fixed an issue where lines in combo charts with an explicit color option (e.g., options={color="black"}) would display the palette color in the legend instead of the specified color.

🚀 Improved component search with keyword aliases Copy Section

Added search keywords to component schemas so components can be found by common alternative names (e.g., "scatter plot" for scatter chart, "donut" for pie chart, "KPI" for big value).

🐛 Fix filters with multiple consecutive spaces in values Copy Section

Fixed an issue where filter values containing multiple consecutive spaces would fail to match data correctly.

🐛 Fix collapsible table arrows not showing with hide_row_totals Copy Section

Fixed an issue where collapsible table arrows were not visible when measures had hide_row_totals enabled.

🐛 Fix branch deletion when branch was already deleted on GitHub Copy Section

Fixed an issue where deleting branches from the Evidence UI would fail with an error when the branch had already been deleted on GitHub (e.g., by GitHub's auto-delete on merge feature).

✨ Candlestick chart component Copy Section

Added a new candlestick chart component for visualizing OHLC financial data with optional volume bars.

View Documentation

🐛 Fix for overlapping content in PDF exports Copy Section

Fixed an issue that could cause overlapping content in PDF exports.

✨ Percentage labels for pie charts Copy Section

Added pct and pct_fmt options for pie charts to display percentage values directly on slice labels.

View Documentation

🐛 Fix AI chat generating dropdowns and date range filters Copy Section

Fixed an issue where AI chat could fail when generating dropdowns or date range filters.

✨ Salesforce Connector Copy Section

Connect your Salesforce CRM data to Evidence. Sync accounts, contacts, opportunities, leads, and campaigns.

View Documentation

🐛 Fix x_fmt not applying to chart tooltips Copy Section

Fixed an issue where setting x_fmt on charts would format the axis labels but not the date value shown in the tooltip.

🐛 Improved AI chat reliability Copy Section

Fixed an issue where AI chat could error out during longer conversations.

✨ Date Range Support for Input Components Copy Section

Input components (dropdown, button_group, input_tabs, slider, dimension_grid) now support the date_range attribute, allowing you to filter options by a specific time period or a range_calendar selection.

🐛 Fix dropdown with manual options showing SQL error Copy Section

Fixed an issue where dropdowns using manual child option tags (no data attribute) would show an "Unknown table function WHERE" error.

✨ Multiplayer editor now in beta Copy Section

Multiplayer editor is now available in beta. Turn it on from Project Settings to collaborate with your team in real-time.

🐛 Graceful redirect when page not found after branch switch or rename Copy Section

Fixed an issue where switching branches or renaming a page could result in a 404 when the current page doesn't exist on the target branch or at the old URL.

🐛 Fix dimension link navigation resulting in 404 Copy Section

Fixed an issue where clicking dimension links in tables would result in a 404 when navigating between pages, because the URL wasn't being resolved relative to the current project context.

🐛 Automatic chart padding for data labels Copy Section

Charts now automatically add top padding when data labels are positioned above bars or points, preventing labels from being cut off at the top of the chart.

✨ External GitHub branch support and PR preview links Copy Section

Projects connected to GitHub now show all repository branches in the branch switcher, not just branches created through Evidence Studio. When a pull request is opened or reopened, Evidence automatically posts a preview link comment on the PR.

🚀 SQL Console Table Grouping Copy Section

Tables in the SQL console sidebar are now organized by schema/connection in a collapsible tree structure for easier navigation.

✨ Customizable Total Label for Tables Copy Section

Tables now support a total_label attribute that allows customizing the text displayed in total/subtotal rows and columns, useful when using non-sum aggregations like avg, min, max, or count.

✨ Editor Sidebar Copy Section

Enhanced editor sidebar, with diff viewer, search, table schema, and page filters.

🚀 Pivot Table Performance Copy Section

Significant performance improvements for pivoted tables and increased row/column limits.

🐛 Fix dropdowns closing modals Copy Section

Fixed an issue where clicking on dropdown menus inside a modal would cause the modal to close unexpectedly.

🐛 Stable AI Edit Previews Copy Section

Prevent AI edits from causing full refresh

✨ Gradient fill for area charts Copy Section

Area charts now support a gradient fill option that fades from the series color at the top to transparent at the bottom. Enable it with area_options={ gradient=true }.

View Documentation

✨ Clock Component Copy Section

Display a live clock with running seconds and the current date using {% clock /%}. Supports 12h/24h format, monospace font variant, and left/right alignment.

✨ Branching Copy Section

Work on multiple versions of your reports at the same time. Create and switch between branches, commit your work, and publish when you're ready.

✨ Heat Grid Copy Section

Visualize metrics across categories with color-coded cells based on configurable thresholds. Cells are colored red, yellow, or green depending on where values fall relative to your thresholds, with an optional lower_is_better mode.

🚀 Model Engine and Primary Key Settings Copy Section

The model edit page now includes configurable refresh schedules, table engine selection, and primary key configuration with helpful tooltips explaining each engine type, data locations, and nullable primary key handling.

View Documentation

✨ Progress Bars Copy Section

Display progress toward goals with horizontal bars showing numerator/denominator ratios. Supports threshold-based coloring and custom color gradients.

✨ PDF Export Options Copy Section

PDF export now supports custom orientation, margins, and card styling options.

✨ Datadog Connector Copy Section

Connect your Datadog monitoring and analytics data to Evidence. Sync metrics, dashboards, monitors, hosts, and usage data from your Datadog account.

View Documentation

✨ Custom Title for Table Filter Copy Section

Customize the Table Filter button text using the new title attribute.

✨ Table Repeat Dimension Values Copy Section

Tables and dimensions now support a repeat_values attribute that forces dimension values to display on every row instead of being collapsed.

🚀 Improved code editor font Copy Section

The code editor now uses Geist Mono, a modern monospace font designed for better readability and aesthetics.

✨ Custom AI Instructions Copy Section

Configure custom instructions for the AI assistant in Settings > AI Agent.

✨ RDS PostgreSQL Connector Copy Section

Connect your RDS PostgreSQL database to Evidence and sync your data automatically.

View Documentation

🚀 PostgreSQL TLS Requirement Documentation Copy Section

Added documentation note for PostgreSQL and Azure PostgreSQL connectors specifying that TLS/SSL must be enabled on the database for secure connections.

✨ Collapsible Tables Copy Section

Tables with subtotals can now be collapsed. Click subtotal rows to expand or collapse their children.

View Documentation

🐛 Fixed row link chevron styling for total and subtotal rows Copy Section

Fixed chevron column styling in tables with row links to match total/subtotal row backgrounds.

✨ Total and Subtotal Position Copy Section

Control where totals and subtotals appear with total_position and subtotal_position. Set to "top" or "bottom".

View Documentation

🚀 Table Filter Initial Values and Required Selections Copy Section

Table filters now support initial_values to set default filter values when the page loads, and require_selection to prevent specific filters from being cleared.

🚀 Automatic Unit Formatting for Numbers Copy Section

BigValue, Value, and Table components now auto-format large numbers with compact units (e.g., $1.2M instead of $1,234,567)

✨ Text Size Option for Big Value Copy Section

The big_value component now supports a text_size attribute with predefined options (sm, base, lg, xl, 2xl, 3xl, 4xl, 5xl) for reliable text sizing.

🚀 Clear Table Sorting with Third Click Copy Section

Click a column header a third time to clear sorting and return to the original order.

View Documentation

✨ Azure SQL Database Connector Copy Section

Sync data from Azure SQL Database directly into Evidence.

View Documentation

✨ Logo Attribute for Table Dimensions Copy Section

Display company logos in table dimension columns. The new logo attribute accepts a column containing domains to look up logos, and logo_options lets you customize size, grayscale mode, and label visibility.

View Documentation

✨ PDF Export for Viewers Copy Section

Viewers can now download published pages as PDFs using the page menu or the keyboard shortcut (Cmd/Ctrl+P).

✨ Twilio Connector Copy Section

Connect your Twilio data to Evidence. Sync calls, messages, accounts, and usage records.

View Documentation

🚀 BigQuery 1 Minute Incremental Syncs Copy Section

BigQuery data connector now supports 1 minute incremental syncs for faster data freshness.

View Documentation

✨ Column Groups in Tables Copy Section

Group related columns under shared headers using the new column_group attribute on measures and dimensions. Useful for organizing metrics by category, such as revenue metrics vs volume metrics.

🐛 Dark Mode Empty Circle Markers Fix Copy Section

Fixed emptyCircle markers in charts to properly use the background color in dark mode instead of white.

✨ Databricks Data Connector Copy Section

Sync data from Databricks directly into Evidence.

View Documentation

✨ Google Ads & Facebook Ads Connectors Copy Section

Connect your Google Ads and Facebook Ads data to Evidence. Sync campaigns, ad groups, ads, and performance metrics to build marketing analytics dashboards.

View Documentation

🐛 Horizontal Bar Chart Sorting Fix Copy Section

Horizontal bar charts now default to sorting by value descending, showing the largest values at the top instead of the bottom.

✨ Logo Component Copy Section

New logo component to display company logos using logo.dev. Supports light/dark theme switching, configurable sizes, and grayscale mode.

✨ MySQL Data Connector Copy Section

Sync data from MySQL directly into Evidence.

View Documentation

✨ PostHog Connector Copy Section

Connect your PostHog product analytics data to Evidence. Sync events, persons, cohorts, feature flags, insights, and more from your PostHog account.

View Documentation

🚀 Snowflake 1 Minute Incremental Syncs Copy Section

Snowflake data connector now supports 1 minute incremental syncs for faster data freshness.

View Documentation

✨ SQL Server Data Connector Copy Section

Sync data from SQL Server directly into Evidence.

View Documentation

✨ Dimension Grid Copy Section

New dimension_grid component for interactive multi-dimensional filtering.

🐛 Fix for frozen columns row shading Copy Section

Frozen columns in tables now display the correct alternating row shading when row_shading=true is enabled. Previously, frozen columns would not show the shading because they had a solid background that overrode the row-level shading.

✨ Series colors for pie charts Copy Section

Map specific category values to specific colors in pie charts using the series_colors option in chart_options. This ensures consistent, meaningful coloring regardless of which categories are present in the data.

🐛 Export Data Retains Filters Copy Section

Table exports now correctly include filtered and sorted data, matching the visual display on screen.

🐛 PDF Export Now Retains Filters Copy Section

When downloading a PDF, any selected filter values are now preserved in the exported PDF.

🚀 Adjusted Developer Role Privileges Copy Section

Previously, developers and admins could manage users, groups and customers. This is now restricted to Admins only.

✨ Motherduck Connector Schema Support Copy Section

You can now use schema with the Motherduck connector

🐛 Dropdown Component Now Supports 'where' Attribute Copy Section

The dropdown component now supports the where attribute for filtering dropdown options with custom SQL WHERE conditions, bringing it to feature parity with other filter components like button_group and input_tabs.

🐛 Horizontal Bar Chart X-Axis Formatting Copy Section

Fixed issue where the x_fmt parameter was not being applied to axis labels in horizontal bar charts. Formatting now works consistently for both axis labels and tooltips.

✨ Add your organization logo Copy Section

Add your organization's logo in settings

✨ Github Data Connector Copy Section

Sync data about your Github repos directly into Evidence.

✨ Deltalake (S3) Connector Copy Section

Connect using your S3 with Delta Lake format your data remains at rest in your S3 bucket.

✨ Smooth Line Option Copy Section

New smooth attribute inside line options lets you create a line with rounded corners

View Documentation

✨ Chart `height` attribute Copy Section

Control the height of your charts using the height attribute

View Documentation

✨ Customer Groups Copy Section

Create customers, and invite customer users to view reports that you choose.

View Documentation

✨ Groups Copy Section

Add team members to groups to simplify permissions on projects and pages

View Documentation

🚀 Improved Excel Export Copy Section

Excel exports now use component titles to create tab names, and exclude logic and filter components

✨ User Variables Copy Section

Access the user's name, email and organization using variables in markdown.

View Documentation

✨ Themes Copy Section

Set color themes at the organization, project, and page level - including background, chart, and card colors

Access theme settings in page settings, project settings, or org settings. You can override theme colors at each level (e.g., project can override org theme, page overrides project and org themes)

View Documentation

🚀 Improved Translation Validation Errors Copy Section

Incorrect structures for translation maps will provide useful errors

🚀 Translations Editor Copy Section

Modify translations with a fully featured text editor

🚀 Improved bucket docs Copy Section

Adds more information about using bucket connectors

View Documentation

✨ Translation Management Copy Section

Define variables with different translations for multi-language apps.

View Documentation

✨ Standalone Horizontal Bar Chart Component Copy Section

New dedicated horizontal_bar_chart component makes it easier to create horizontal bar charts

We recommend migrating any existing horizontal bar charts to this new component

View Documentation

✨ Display control for total and subtotals in table Copy Section

Choose which totals or subtotals to display in your table

View Documentation

✨ Dark Mode Chart Colors Copy Section

Configure colors for both light and dark mode in your project and org settings

✨ Input tabs full_width and align attributes Copy Section

Input tabs now allows the same styling configuration as the Tabs component, including full width and right align

View Documentation

✨ Conditional Formatting Copy Section

Apply conditional logic to choose colors for visualizations

✨ Series Color Mapping Copy Section

Option to select specific colors for series in your charts

View Documentation

🚀 Assign access to pending users Copy Section

You can now grant project and page access to users who have not yet accepted invitations to join the Evidence organization.

🚀 Control order of series in combo chart Copy Section

Combo chart now displays your series in the order you define them in your markdown

✨ Draft Diff Viewer Copy Section

Review your changes using the diff viewer before you publish

🚀 Icons in Autocomplete Copy Section

Find components more easily in component autocomplete menus using the mini-icons

🚀 Smoother chart loads on input changes Copy Section

Improved chart loading behaviour and animation when changing inputs on your page

🐛 Fix for table pivoting issues Copy Section

Fixed issue where tables were not pivoting in certain situations

✨ `fmt` property for input options Copy Section

Use dynamic formats in viz components when creating an input to select a metric - e.g., show 'usd' for sales or 'pct1' for growth

View Documentation

✨ Variable `label` property Copy Section

You can now reference the label property of a variable - useful when adding labels to viz components based on input selection

View Documentation

🐛 Fix for custom date range end dates Copy Section

Fixes issue where custom end date defined in SQL was not taking effect

🐛 Fix for scale_column Copy Section

Fixes issue where scale_column in the measure component was not properly assigning colors

🚀 Improved handling of date grains in charts Copy Section

Automatically handles formatting and positioning of labels on x-axis for date grains including month of year and day of week

✨ Table of Contents Copy Section

A generated table of contents from the headings in your report. Enable from page settings.

✨ Top padding option for charts Copy Section

Top padding override option to allow more room for data labels - helps in cases where labels are cut off

✨ x_sort attribute Copy Section

Choose a specific sort order for your x-axis, including specifying explicit strings

🐛 Histogram support for inline queries Copy Section

Fix for Histogram issue where it could not accept inline queries

🚀 Toggle `invert` attribute Copy Section

Invert attribute added to make toggled state = false instead of true

✨ Slider Input Copy Section

New slider input component to filter on numeric values

View Documentation

✨ Query timing metadata Copy Section

Queries in the SQL Console, and the pop out component inspector at the bottom of the editor now display how long the query took to run in the Evidence query engine

✨ Zoomable charts Copy Section

Adds a new "zoom" chart option to enable zooming into the data

✨ Toggle input Copy Section

New toggle input component which sets a boolean variable you can use in queries and components

View Documentation

✨ Button group and input tabs Copy Section

New input components as visual alternatives to dropdowns: button_group and input_tabs

Note that this update also deprecates the dropdown_option component in favour of the more general option component. The option component can be used inside dropdown, button_group, or input_tabs

View Documentation

🚀 Info Links Copy Section

Add links to info text popovers using info_link and info_link_title atttributes.

🚀 User Management Performance Copy Section

Adding and removing users from reports is now faster

🐛 Fix for custom pivot formatting Copy Section

Formatting for pivots now works as expected for custom date formats - e.g., fmt="yyyy-mm"

✨ Select all in dropdown Copy Section

New button to select all options in a dropdown

✨ Text input component Copy Section

Input component accepting free text input

View Documentation

✨ Feature Requests Copy Section

Submit and track feature requests directly in your settings menu

From Settings > Feature Requests, you can create requests or bug reports, and set their priority. This integrates directly with the Evidence team's roadmap, with status changes synced into your view

✨ Stacked bar series in combo charts Copy Section

Bar series in combo charts can now be stacked using the new stack_id attribute. Bars with the same stack_id will be stacked together, allowing for flexible combinations of stacked and grouped bars.

View Documentation

✨ Max label length for x-axis labels Copy Section

Truncate labels after a certain number of characters using the max_label_length attribute inside x_axis_options

✨ Rotate x-axis labels Copy Section

Use the new label_rotate option in x_axis_options to rotate the labels on your x-axis

View Documentation

🚀 Sidebar Icons and Sorting Copy Section

Add custom icons and adjust the sort order of projects and pages in the sidebar

✨ Jump to Code Copy Section

In the editor preview, Cmd/Ctrl + click on a component to jump to the code for that component

You can jump to code by Cmd/Ctrl + clicking a component in the preview pane, or you can jump to the component preview by Cmd/Ctrl + clicking the code in your editor

🐛 Fixes for table pivoting Copy Section

Fixed issue where columns were not properly pivoting in tables

🚀 Drag and drop image support Copy Section

Drag, or paste images into the editor to add them to your page.

✨ Models (Beta) Copy Section

Join sources together and materialize the results to improve performance

Models can be used to execute joins across sources, centralize type casting, and create clean tables to use when building reports. Models are run and materialized every 8 hours

View Documentation

✨ Set custom end date for date ranges Copy Section

Use a dynamic end date for date ranges based on your data or a standard offset

By default, date ranges end as of today's date, but this setting allows you to choose a date based on a standard offset (e.g., 1 day ago) or by passing a sql query to calculate the date (e.g., select max(date) from my_table)

✨ Bar chart opacity setting Copy Section

Customize the opacity of bars in bar chart and combo chart components

🚀 Project Sections Copy Section

Organize projects into sections for easier navigation during development

Sections will not impact how projects are arranged in the app published to Viewer users

🐛 Version control overflow Copy Section

Fixes a bug where if you changed lots of files it overflowed the Version History panel

✨ Option to choose first day of week Copy Section

In project settings, you can now choose whether weeks start on Sunday or Monday

🚀 Better SQL Autocomplete Suggestions Copy Section

Improved SQL suggestions for columns, and tables after joins

🚀 Variable name shortcuts + use in markdown Copy Section

Variables no longer require specifying a property - simply use the name, like {{ my_var }}

You can also use variables directly in markdown, including in headers and lists. You still have access to variable properties and can reference them like this: {{ my_var.selected }}

🚀 Performance improvement for table comparisons Copy Section

Tables containing comparisons should now load much faster

🚀 More source sync info Copy Section

View the number of rows in a source, and the amount of time it took for the source sync from the Sources page.

✨ Use variables inside components Copy Section

You can now reference filter variables directly in component attributes

Supports the following attributes: title, subtitle, info, where, date_grain, date_range.range, comparison.compare_vs

✨ Icon support for dropdowns Copy Section

Include an icon in your dropdown using the icon option

✨ Selector components for date grain and comparisons Copy Section

Special components for selecting date grain and comparisons

🚀 Dynamic date ranges Copy Section

Input arbitrary ranges into the date_range attribute in components, like "last 14 weeks" or "2023-01-14 to 2025-11-30"

🐛 Filter scroll fix Copy Section

Fixed a bug where selecting a filter caused the page to jump back to the top.

✨ Select preset ranges in range calendar Copy Section

Choose which preset ranges you want your users to see when clicking the range calendar component

🐛 SQL comments in inline queries Copy Section

You can now add comments to inline queries without breaking them

✨ Option to turn legend off in charts Copy Section

You can now turn off chart legends with legend=false

🚀 Conditional component render instantly Copy Section

When previewing or viewing published pages, the initial state of any if/else_if/else conditions will be pre-calculated before the page loads.

🚀 Better label spacing on x-axis Copy Section

Improvement to the alignment and spacing of labels on the x-axis

🐛 Fix target comparison totals in table Copy Section

Fixed an issue where target comparisons were hidden in total rows

🐛 Improved date behaviour Copy Section

Previously, database columns that returned Date type would return DateTime precision, which is confusing in the UI. Now dates will return no additional time component

Values that are Date type will no longer display time component in Tables, Values, and in various input components. Eg a Date previously formatted 2025-09-22T14:05:23Z would now be returned as 2025-09-22.

🐛 Fix Explore table resize and scroll Copy Section

Fixes an issue where tables on the Explore page would resize and cut off content

🚀 Comparison Tooltip Improvements Copy Section

Fixed issue with percentage calculations for negative values. Added support for custom formats.

✨ Make Feature Requests in AI Chat Copy Section

Now you can ask the Evidence chat to submit a feature request to the Evidence team

🐛 Fixed unexpected date offsets Copy Section

In certain timezones, dates were being transposed by a small number of seconds in Chrome and Safari. This could cause date formats to render incorrectly, for example showing the day before the expected date.

🚀 RLS Enhancements Copy Section

Added variable support for IN/NOT IN operators, 'Apply All' rule option, new panel interface, and per-user variable editing capabilities.

🚀 Improved Inline SQL Editor Copy Section

See available variables, inline queries, and a preview of compiled SQL when editing queries in the inline SQL editor

🚀 Improved international character support in SQL queries Copy Section

You can now include Japanese, Chinese, emoji, and other non-Latin characters directly in SQL passed to components

✨ Page Loading (table) Copy Section

Tables now load instantly on preview and published pages

This is the first change in a journey to fully enable Server-Side Rendering in Evidence pages. The table is the first component to support this behavior, which enables the following features:- Tables load instantly on preview and published pages (no more loading spinner when the page loads)- Chat can now debug SQL query errors in Table componentsThis change lays the groundwork for other components to opt into this new Server-Side Rendering system.

✨ Add optional dark_url prop to image component Copy Section

Image components can now display different images in light and dark modes using the new dark_url prop.

✨ Themes Copy Section

Define a custom color palette to apply to all charts in a project

🚀 Improved Default Funnel Chart Styling Copy Section

Funnel Charts are more intuitive to read, with a squared off style

View Documentation

🐛 Fix Comparison Issues Copy Section

Fixed bug for target comparisons which resulted in undefined error

✨ Inline SQL Editor Copy Section

A new SQL editor for running and modifying inline queries on your page

✨ Icon Component Copy Section

Add icons inline into markdown, with configuration for color and size

View Documentation

✨ Row Level Security Copy Section

Add rules to restrict which rows of are visible to users from sources

Add RLS rules to data source columns, and add user variables to determine which values in these columns allow access.

View Documentation

🚀 Custom Color Palettes Copy Section

All charts now support custom color palettes via the "chart_options" attribute

Pass an array of hex codes to the color_palette option e.g. color_palette=["#ff0000","#00ff00"]

View Documentation

🐛 Fix Editor Overwriting Bug Copy Section

Fixed bug where switching pages and then hitting Ctrl+Z would overwrite your page with the content of the previous page.

🚀 Sidebar Hover Text Copy Section

Adds hover text to sidebar items that are truncated due to length

🐛 Table Filter Option Overflow Copy Section

Fixed a bug where long string values in the table filter overlapped each other

🚀 Charting Library Upgrade Copy Section

Upgraded to ECharts 6, fixed some issues where labels got cut off

🐛 Expose SQL Errors Copy Section

Exposes some SQL errors that were not being shown

🐛 Fix High Precision Decimals in Postgres Copy Section

Resolves issue where tables containing decimal columns with more that 9 digits of precision were failing to publish

🚀 Editor Loading Speed Copy Section

We've significantly improved the load speeds when switching between pages in the editor.

✨ Link Button Copy Section

Use the link button to link to another page in Evidence or an external location

View Documentation

✨ Print Format Components Copy Section

Add page breaks, print groups, and hide elements from PDF downloads

✨ PDF Download Copy Section

Download your page as a PDF

🐛 If / Else Behaviour Fix Copy Section

Fixed some issues with the if /else components which sometimes caused them to not display information when they should

✨ Accordian components Copy Section

Organize content into collapsible accordian sections

✨ Axis Label Interval Control Copy Section

More control over the intervals between labels on charts

🐛 Long Page Name Overflow Copy Section

Long page and directory names now truncate in the sidebar to prevent the action button being hidden

✨ Range Calendar Input Copy Section

New range calendar component for date filtering.

✨ Tabs Copy Section

New Tabs, and Tab components for tabbed layouts.

✨ Variables Copy Section

Define variables in frontmatter and use them in markdown, SQL and components

View Documentation

✨ Column-level control for tables Copy Section

Control formatting for each column in a table

✨ Conditional formatting in tables Copy Section

Use color scale to conditionallyformat values in a table

✨ Image support in tables Copy Section

Add images to columns in a table

🚀 Improved Explore page Copy Section

Supports more date grain options and improved share experience

🚀 Improved pivot table Copy Section

Table now supports more complex pivot table scenarios

✨ Link support in tables Copy Section

Add links to columns in a table, or set up row links

🚀 New date grain options Copy Section

Inclues special grains like 'day of week' and 'month of year', with built-in labels

✨ New table visualizations Copy Section

Add bar charts, sparklines, and deltas to your columns

✨ Period over period comparisons Copy Section

Automatically compare values vs. prior year, prior period, or target. Available in table and big value.

🐛 Delete Connections Fix Copy Section

Fixed a bug which only allowed you to delete the most recently added connection

✨ Hubspot Connector Copy Section

Import data from Hubspot directly into Evidence

View Documentation

✨ Modals Copy Section

New modal component that can contain content in a dialogue or drawer.

View Documentation

✨ Motherduck Connector Copy Section

Add data sources from your Motherduck DB

View Documentation

✨ Page linking Copy Section

Link to other Evidence pages using markdown links []() with Intellisense support

View Documentation

🐛 Respect columns option in table filter Copy Section

Fix bug which ignored columns selection in table filter

🐛 Table filter responsiveness Copy Section

Fix bug which prevented table filter inputs from taking effect immediately after adding the table filter to the page.

✨ Filter interpolation Copy Section

Reference filter values inside of inlined queries, and view the state of your filters in the new filters pane of the devtools sidebar.

View Documentation

🚀 Agent Keyboard Shortcut Copy Section

Ctrl+Alt+I (Mac: Cmd+Shift+I) to open a chat with the Evidence agent from anywhere in the Editor

✨ If, Else If, Else Copy Section

Use conditional blocks to choose what to render based on data.

View Documentation

✨ Reference Components Copy Section

Use reference_line, reference_area, and reference_point to add reference annotations to your charts

View Documentation

🚀 Postgres Schema Support Copy Section

Use tables in any Postgres schema (not just the default "public" schema)

✨ Import Views as Sources Copy Section

All supported DBs now allow importing views as sources

🚀 Public Documentation Copy Section

We've published full documentation at https://docs.evidence.studio

✨ Card Option for Row and Stack Components Copy Section

Added card option to row and stack components to display their contents as a single card.

✨ Data Point Labels Copy Section

Label each data point in your chart with the data_labels option

✨ Downloadable Data Copy Section

Right click any chart to download its data, or use the kebab menu in the top left of the published page to download a whole page's data.

✨ Chart, Axis, and Series Options Copy Section

New chart_options, x_axis_options, y_axis_options, y2_axis_options, and series options for customizing your charts.

✨ Partials Copy Section

Define sections of markdown for re-use across pages.

✨ Polar Chart Copy Section

Added a new polar chart component.

✨ Table Search Copy Section

Search bar for the Table component.

🐛 Inline Query Date Validation Copy Section

Fixes issue creating visualizations using inline queries with dates

✨ Histogram Copy Section

Added a new histogram chart component.

✨ Markdown Comments Copy Section

Adds support for mardown comments with <!-- -->. Mac: Cmd + / Windows: Ctrl + /

✨ Calendar Heatmap Copy Section

Added a new calendar heatmap chart.

✨ Combo Chart Copy Section

Added a combo_chart component that allows you to combine area, bar, bubble, line, and scatter series on one chart.

✨ Accept and Reject Changes Panel in Diff View Copy Section

Added accept and reject buttons to the top of the diff view.

🚀 Connection Documentation Copy Section

Added generaldocumentation for data connections.

🐛 Fix to give AI agent knowledge of inline queries Copy Section

Fixed the issue where the AI agent did not know about inline queries on your page.

🐛 Fix to Maintain Chart Height Copy Section

Fixed the issue where the chart height was shrinking when title and legend were added.

✨ Heatmap Chart Copy Section

Added a new heatmap chart component.

🚀 Link to All Docs in Sidepane Copy Section

Added a link to all docs in the docs tab of the editor.

✨ Custom X and Y Chart Titles Copy Section

Added the ability to customize x_title and y_title for charts.

✨ Funnel Chart Copy Section

Added a new funnel chart component.

✨ Sankey Chart Copy Section

Added a new sankey chart component.

✨ Changelog Copy Section

We're shipping features and fixes very quickly. Keep an eye out here for updates.

🐛 Fix Slash Commands When Inside Parent Component Copy Section

Fixed the issue where slash commands were not working when inside a parent component.

🚀 Helpful Warning for Aggregating Columns Copy Section

Added a warning to consider aggregating a column for a chart.

✨ Open Chat Automatically for Fix in Chat Copy Section

When the fix in chat button is pressed, the chat window will open automatically.

✨ Pie and Donut Charts Copy Section

Added a new pie chart component.

🚀 Collapse the Sidebar Copy Section

Added the ability to collapse and expand the sidebar on all screen sizes.

🚀 Faster Sources Page Copy Section

Significantly improved loading performance on the sources page.

🚀 Fix in Chat Now Available on All Error Messages Copy Section

Error messages throughout the platform now include the fix in chat feature.

🚀 More Readable SQL Errors Copy Section

SQL error messages have been redesigned to be clearer and more actionable.

🐛 Row and Stack Components Copy Section

Fixed issues with Row and Stack components rendering and layout behavior.

✨ European Number Formatting Copy Section

Support for European number format using comma as the decimal separator (e.g., 1.234,56 instead of 1,234.56).

✨ Azure Postgres Connector Copy Section

Connect your Azure Database for PostgreSQL to Evidence and sync your data automatically.

View Documentation

✨ SQL Files Copy Section

Create reusable SQL queries as standalone files. SQL files can be referenced from components using data="path/to/query" and from inline queries using {{path/to/query}} syntax.

Docs.Json (`docs/docs.json`) Copy Section

{
"$schema": "https://mintlify.com/docs.json",
"theme": "maple",
"thumbnails": {
"fonts": {
"family": "Geist"
}
},
"icons": {
"library": "lucide"
},
"name": "Evidence Docs",
"colors": {
"primary": "#2c5282",
"light": "#2c5282",
"dark": "#15803D"
},
"integrations": {
"posthog": {
"apiKey": "phc_5gRFl1Rp6a01CZM9CX3qDvFwyxp7YzdWvdGAgi8a1fq"
}
},
"favicon": "/favicon.svg",
"redirects": [
{
"source": "/features/embedded",
"destination": "/features/embedded-analytics"
},
{
"source": "/features/code-managed-access",
"destination": "/features/page-level-access-control"
},
{
"source": "/features/page-frontmatter",
"destination": "/features/page-settings"
},
{
"source": "/features/access-control",
"destination": "/features/row-level-security"
},
{
"source": "/features/access-rules",
"destination": "/features/row-level-security"
},
{
"source": "/features/project-configuration",
"destination": "/features/project-settings"
},
{
"source": "/features/mcp-server",
"destination": "/mcp/docs"
},
{
"source": "/features/evidence-mcp",
"destination": "/mcp/studio"
},
{
"source": "/install-evidence",
"destination": "/quickstart"
},
{
"source": "/getting-started/install-evidence",
"destination": "/quickstart"
},
{
"source": "/build-your-first-app",
"destination": "/quickstart"
},
{
"source": "/core-concepts/queries",
"destination": "/evidence-warehouse"
},
{
"source": "/core-concepts/formatting",
"destination": "/core-concepts/value-formatting"
},
{
"source": "/core-concepts/filters",
"destination": "/components/filter_bar"
},
{
"source": "/core-concepts/themes",
"destination": "/features/themes"
},
{
"source": "/core-concepts/templated-pages",
"destination": "/features/page-settings"
},
{
"source": "/core-concepts/exports",
"destination": "/components/download"
},
{
"source": "/core-concepts/syntax",
"destination": "/core-concepts/markdown"
},
{
"source": "/core-concepts/pages",
"destination": "/features/page-settings"
},
{
"source": "/core-concepts/query-functions",
"destination": "/core-concepts/models"
},
{
"source": "/core-concepts/if-else",
"destination": "/components/if"
},
{
"source": "/core-concepts/loops",
"destination": "/components/repeat"
},
{
"source": "/core-concepts/data-sources/duckdb",
"destination": "/evidence-warehouse"
},
{
"source": "/core-concepts/data-sources/bigquery",
"destination": "/direct-connectors/bigquery"
},
{
"source": "/core-concepts/data-sources/postgres",
"destination": "/direct-connectors/postgres"
},
{
"source": "/core-concepts/data-sources/javascript",
"destination": "/evidence-warehouse"
},
{
"source": "/core-concepts/data-sources/csv",
"destination": "/evidence-warehouse"
},
{
"source": "/core-concepts/data-sources/snowflake",
"destination": "/direct-connectors/snowflake"
},
{
"source": "/core-concepts/data-sources/google-sheets",
"destination": "/evidence-warehouse"
},
{
"source": "/core-concepts/data-sources/databricks",
"destination": "/direct-connectors/databricks"
},
{
"source": "/core-concepts/data-sources/trino",
"destination": "/evidence-warehouse"
},
{
"source": "/core-concepts/data-sources/mssql",
"destination": "/evidence-warehouse"
},
{
"source": "/core-concepts/data-sources/motherduck",
"destination": "/direct-connectors/motherduck"
},
{
"source": "/components/charts/echarts-options",
"destination": "/components/custom_echart"
},
{
"source": "/components/charts/custom-echarts",
"destination": "/components/custom_echart"
},
{
"source": "/components/charts/bar-chart",
"destination": "/components/bar_chart"
},
{
"source": "/components/charts/line-chart",
"destination": "/components/line_chart"
},
{
"source": "/components/charts/sankey-diagram",
"destination": "/components/sankey_chart"
},
{
"source": "/components/charts/heatmap",
"destination": "/components/heatmap"
},
{
"source": "/components/charts/calendar-heatmap",
"destination": "/components/calendar_heatmap"
},
{
"source": "/components/charts/mixed-type-charts",
"destination": "/components/combo_chart"
},
{
"source": "/components/charts/funnel-chart",
"destination": "/components/funnel_chart"
},
{
"source": "/components/charts/annotations",
"destination": "/components/reference_line"
},
{
"source": "/components/charts/scatter-plot",
"destination": "/components/scatter_chart"
},
{
"source": "/components/charts/area-chart",
"destination": "/components/area_chart"
},
{
"source": "/components/charts/histogram",
"destination": "/components/histogram"
},
{
"source": "/components/charts/sparkline",
"destination": "/components/sparkline"
},
{
"source": "/components/charts/bubble-chart",
"destination": "/components/bubble_chart"
},
{
"source": "/components/data/data-table",
"destination": "/components/table"
},
{
"source": "/components/data/big-value",
"destination": "/components/big_value"
},
{
"source": "/components/data/value",
"destination": "/components/value"
},
{
"source": "/components/data/delta",
"destination": "/components/delta"
},
{
"source": "/components/inputs/dropdown",
"destination": "/components/dropdown"
},
{
"source": "/components/inputs/date-range",
"destination": "/components/range_calendar"
},
{
"source": "/components/inputs/date-input",
"destination": "/components/range_calendar"
},
{
"source": "/components/inputs/dimension-grid",
"destination": "/components/dimension_grid"
},
{
"source": "/components/inputs/button-group",
"destination": "/components/button_group"
},
{
"source": "/components/inputs/slider",
"destination": "/components/slider"
},
{
"source": "/components/inputs/text-input",
"destination": "/components/text_input"
},
{
"source": "/components/inputs/checkbox",
"destination": "/components/toggle"
},
{
"source": "/components/inputs",
"destination": "/components/dropdown"
},
{
"source": "/components/maps/area-map",
"destination": "/components/area_layer"
},
{
"source": "/components/maps/point-map",
"destination": "/components/point_layer"
},
{
"source": "/components/maps/bubble-map",
"destination": "/components/point_layer"
},
{
"source": "/components/maps/us-map",
"destination": "/components/map"
},
{
"source": "/components/maps/base-map",
"destination": "/components/map"
},
{
"source": "/components/ui/embed",
"destination": "/components/iframe"
},
{
"source": "/components/ui/link",
"destination": "/components/link"
},
{
"source": "/components/ui/grid",
"destination": "/components/row"
},
{
"source": "/components/ui/tabs",
"destination": "/components/tabs"
},
{
"source": "/components/ui/big-link",
"destination": "/components/link_button"
},
{
"source": "/components/ui/link-button",
"destination": "/components/link_button"
},
{
"source": "/components/ui/image",
"destination": "/components/image"
},
{
"source": "/components/ui/info",
"destination": "/components/info"
},
{
"source": "/components/ui/alert",
"destination": "/components/callout"
},
{
"source": "/components/ui/download-data",
"destination": "/components/download"
},
{
"source": "/components/ui/details",
"destination": "/components/details"
},
{
"source": "/components/ui/print-format-components",
"destination": "/components/print_group"
},
{
"source": "/components/ui/accordion",
"destination": "/components/accordion"
},
{
"source": "/components/ui/modal",
"destination": "/components/modal"
},
{
"source": "/components/ui/note",
"destination": "/components/note"
},
{
"source": "/components/custom/custom-component",
"destination": "/core-concepts/custom-components"
},
{
"source": "/components/custom/component-queries",
"destination": "/core-concepts/custom-components"
},
{
"source": "/components/all-components",
"destination": "/core-concepts/components"
},
{
"source": "/reference/layouts",
"destination": "/features/layouts"
},
{
"source": "/reference/markdown",
"destination": "/core-concepts/markdown"
},
{
"source": "/reference/cli",
"destination": "/cli/commands"
},
{
"source": "/deployment/overview",
"destination": "/publishing"
},
{
"source": "/deployment",
"destination": "/publishing"
},
{
"source": "/deployment/self-host",
"destination": "/self-host"
},
{
"source": "/deployment/self-host/vercel",
"destination": "/self-host/vercel"
},
{
"source": "/deployment/self-host/github-pages",
"destination": "/self-host"
},
{
"source": "/deployment/self-host/netlify",
"destination": "/self-host"
},
{
"source": "/deployment/self-host/gitlab-pages",
"destination": "/self-host"
},
{
"source": "/deployment/self-host/hugging-face-spaces",
"destination": "/self-host"
},
{
"source": "/deployment/self-host/azure-static-apps",
"destination": "/self-host"
},
{
"source": "/deployment/self-host/firebase",
"destination": "/self-host"
},
{
"source": "/deployment/self-host/aws-amplify",
"destination": "/self-host"
},
{
"source": "/deployment/configuration/rendering-modes",
"destination": "/features/project-settings"
},
{
"source": "/deployment/configuration/environments",
"destination": "/features/project-settings"
},
{
"source": "/deployment/configuration/base-paths",
"destination": "/self-host"
},
{
"source": "/guides/system-requirements",
"destination": "/self-host"
},
{
"source": "/guides/updating-your-app",
"destination": "/migration-guide"
},
{
"source": "/guides",
"destination": "/quickstart"
},
{
"source": "/plugins/source-plugins",
"destination": "/evidence-warehouse"
},
{
"source": "/plugins/component-plugins",
"destination": "/core-concepts/custom-components"
},
{
"source": "/plugins/create-component-plugin",
"destination": "/core-concepts/custom-components"
},
{
"source": "/plugins/create-source-plugin",
"destination": "/evidence-warehouse"
},
{
"source": "/plugins",
"destination": "/core-concepts/custom-components"
},
{
"source": "/components/charts/box-plot",
"destination": "/components/custom_echart"
},
{
"source": "/components/ui/last-refreshed",
"destination": "/components/html"
},
{
"source": "/deployment/cloud/evidence-cloud",
"destination": "/publishing"
},
{
"source": "/guides/troubleshooting",
"destination": "/"
},
{
"source": "/guides/best-practices",
"destination": "/"
},
{
"source": "/deployment/self-host/cloudflare-pages",
"destination": "/self-host"
},
{
"source": "/getting-started/what-is-evidence",
"destination": "/"
},
{
"source": "/markdown",
"destination": "/core-concepts/markdown"
},
{
"source": "/themes-and-layouts",
"destination": "/features/layouts"
},
{
"source": "/plugins/creating-a-plugin",
"destination": "/core-concepts/custom-components"
},
{
"source": "/guides/updating-your-project",
"destination": "/migration-guide"
},
{
"source": "/components/area-map",
"destination": "/components/area_layer"
},
{
"source": "/components/us-map",
"destination": "/components/map"
},
{
"source": "/components/bubble-map",
"destination": "/components/point_layer"
},
{
"source": "/components/point-map",
"destination": "/components/point_layer"
},
{
"source": "/components/base-map",
"destination": "/components/map"
},
{
"source": "/components/download-data",
"destination": "/components/download"
},
{
"source": "/components/last-refreshed",
"destination": "/components/html"
},
{
"source": "/components/alert",
"destination": "/components/callout"
},
{
"source": "/components/big-link",
"destination": "/components/link_button"
},
{
"source": "/components/link-button",
"destination": "/components/link_button"
},
{
"source": "/components/print-format-components",
"destination": "/components/print_group"
},
{
"source": "/components/grid",
"destination": "/components/row"
},
{
"source": "/components/bubble-chart",
"destination": "/components/bubble_chart"
},
{
"source": "/components/mixed-type-charts",
"destination": "/components/combo_chart"
},
{
"source": "/components/funnel-chart",
"destination": "/components/funnel_chart"
},
{
"source": "/components/bar-chart",
"destination": "/components/bar_chart"
},
{
"source": "/components/custom-echarts",
"destination": "/components/custom_echart"
},
{
"source": "/components/box-plot",
"destination": "/components/custom_echart"
},
{
"source": "/components/annotations",
"destination": "/components/reference_line"
},
{
"source": "/components/calendar-heatmap",
"destination": "/components/calendar_heatmap"
},
{
"source": "/components/area-chart",
"destination": "/components/area_chart"
},
{
"source": "/components/line-chart",
"destination": "/components/line_chart"
},
{
"source": "/components/sankey-diagram",
"destination": "/components/sankey_chart"
},
{
"source": "/components/echarts-options",
"destination": "/components/custom_echart"
},
{
"source": "/components/scatter-plot",
"destination": "/components/scatter_chart"
},
{
"source": "/components/custom-components",
"destination": "/core-concepts/custom-components"
},
{
"source": "/components/component-queries",
"destination": "/core-concepts/custom-components"
},
{
"source": "/components/big-value",
"destination": "/components/big_value"
},
{
"source": "/components/data-table",
"destination": "/components/table"
},
{
"source": "/components/dimension-grid",
"destination": "/components/dimension_grid"
},
{
"source": "/components/checkbox",
"destination": "/components/toggle"
},
{
"source": "/components/date-range",
"destination": "/components/range_calendar"
},
{
"source": "/components/text-input",
"destination": "/components/text_input"
},
{
"source": "/components/button-group",
"destination": "/components/button_group"
},
{
"source": "/deployment/github-pages",
"destination": "/self-host"
},
{
"source": "/deployment/aws-amplify",
"destination": "/self-host"
},
{
"source": "/deployment/azure-static-apps",
"destination": "/self-host"
},
{
"source": "/deployment/cloudflare-pages",
"destination": "/self-host"
},
{
"source": "/deployment/firebase",
"destination": "/self-host"
},
{
"source": "/deployment/gitlab-pages",
"destination": "/self-host"
},
{
"source": "/deployment/hugging-face-spaces",
"destination": "/self-host"
},
{
"source": "/deployment/netlify",
"destination": "/self-host"
},
{
"source": "/deployment/vercel",
"destination": "/self-host/vercel"
},
{
"source": "/deployment/rendering-modes",
"destination": "/features/project-settings"
},
{
"source": "/deployment/base-paths",
"destination": "/self-host"
},
{
"source": "/deployment/environments",
"destination": "/features/project-settings"
},
{
"source": "/core-concepts/data-sources",
"destination": "/evidence-warehouse"
},
{
"source": "/data-sources",
"destination": "/evidence-warehouse"
},
{
"source": "/warehouses/evidence-warehouse",
"destination": "/evidence-warehouse"
}
],
"navigation": {
"global": {
"anchors": [
{
"anchor": "Evidence Studio",
"href": "https://evidence.studio",
"icon": "app-window"
},
{
"anchor": "Community",
"href": "https://slack.evidence.dev",
"icon": "slack"
},
{
"anchor": "Legacy Docs",
"href": "https://legacy-docs.evidence.dev",
"icon": "book"
}
]
},
"tabs": [
{
"tab": "Docs",
"groups": [
{
"group": "Get Started",
"pages": [
"index",
"quickstart",
"migration-guide",
"editing",
"publishing"
]
},
{
"group": "Core Concepts",
"pages": [
"core-concepts/markdown",
"core-concepts/components",
"core-concepts/models",
"core-concepts/metrics",
"core-concepts/value-formatting",
"core-concepts/variables",
"core-concepts/partials",
"core-concepts/custom-components"
]
},
{
"group": "Features",
"pages": [
"features/version-control",
"features/project-settings",
"features/page-settings",
"features/themes",
"features/layouts",
"features/sql-files",
"features/page-level-access-control",
"features/row-level-security",
"features/evidence-agent",
"features/translations",
"features/embedded-analytics",
"features/scheduled-reports"
]
},
{
"group": "MCP",
"pages": [
"mcp/overview",
"mcp/studio",
"mcp/docs"
]
},
{
"group": "CLI",
"pages": [
"cli/index",
"cli/connections",
"cli/commands"
]
},
{
"group": "Self Host",
"pages": [
"self-host/index",
"self-host/authentication",
"self-host/vercel",
"self-host/render",
"self-host/fly",
"self-host/railway"
]
},
{
"group": "Direct Connectors",
"pages": [
"direct-connectors/snowflake",
"direct-connectors/fabric",
"direct-connectors/clickhouse",
"direct-connectors/bigquery",
"direct-connectors/databricks",
"direct-connectors/postgres",
"direct-connectors/cube",
"direct-connectors/motherduck"
]
},
{
"group": "Evidence Warehouse",
"pages": [
"evidence-warehouse",
{
"group": "Databases",
"expanded": false,
"icon": "database",
"pages": [
"data-sources/athena",
"data-sources/motherduck",
"data-sources/redshift"
]
},
{
"group": "Object Storage",
"expanded": false,
"icon": "hard-drive",
"pages": [
"data-sources/abs",
"data-sources/backblaze",
"data-sources/custom",
"data-sources/gcs",
"data-sources/r2",
"data-sources/s3"
]
},
{
"group": "Data Lakes",
"expanded": false,
"icon": "layers",
"pages": [
"data-sources/deltalake_s3",
"data-sources/iceberg"
]
},
{
"group": "Flat Files",
"expanded": false,
"icon": "file",
"pages": [
"data-sources/file"
]
}
]
},
{
"group": "Components",
"pages": [
{
"group": "Values",
"expanded": false,
"icon": "shapes",
"pages": [
"components/value",
"components/big_value",
"components/delta",
"components/heat_grid",
"components/progress_bars"
]
},
{
"group": "Tables",
"expanded": false,
"icon": "table-2",
"pages": [
"components/table",
"components/dimension",
"components/measure",
"components/pivot"
]
},
{
"group": "Charts",
"expanded": false,
"icon": "chart-column-increasing",
"pages": [
"components/area_chart",
"components/bar_chart",
"components/bubble_chart",
"components/calendar_heatmap",
"components/candlestick",
"components/chord_chart",
"components/combo_chart",
"components/custom_echart",
"components/funnel_chart",
"components/heatmap",
"components/histogram",
"components/horizontal_bar_chart",
"components/line_chart",
"components/pie_chart",
"components/polar_chart",
"components/radar_chart",
"components/sankey_chart",
"components/scatter_chart",
"components/treemap",
"components/waterfall_chart",
"components/area",
"components/bar",
"components/bubble",
"components/line",
"components/reference_area",
"components/reference_line",
"components/reference_point",
"components/scatter",
"components/sparkline"
]
},
{
"group": "Maps",
"expanded": false,
"icon": "map",
"pages": [
"components/custom_map",
"components/map",
"components/area_layer",
"components/heatmap_layer",
"components/point_layer"
]
},
{
"group": "Inputs",
"expanded": false,
"icon": "text-cursor-input",
"pages": [
"components/button_group",
"components/comparison_selector",
"components/benchmark_comparison",
"components/target_comparison",
"components/date_grain_selector",
"components/dropdown",
"components/filter_bar",
"components/input_tabs",
"components/option",
"components/range_calendar",
"components/slider",
"components/table_filter",
"components/text_input",
"components/toggle",
"components/dimension_grid",
"components/period_selector"
]
},
{
"group": "Custom",
"expanded": false,
"icon": "code-xml",
"pages": [
"components/html"
]
},
{
"group": "UI",
"expanded": false,
"icon": "layout-template",
"pages": [
"components/accordion",
"components/accordion_item",
"components/accordion_title",
"components/audio",
"components/callout",
"components/clock",
"components/commentary",
"components/details",
"components/download",
"components/fence",
"components/file",
"components/hidden_in_print",
"components/icon",
"components/iframe",
"components/image",
"components/info",
"components/line_break",
"components/link",
"components/link_button",
"components/logo",
"components/modal",
"components/note",
"components/only_in_print",
"components/page_break",
"components/partial",
"components/print_group",
"components/row",
"components/stack",
"components/tab",
"components/tabs"
]
},
{
"group": "Logic",
"expanded": false,
"icon": "trending-up-down",
"pages": [
"components/if",
"components/else_if",
"components/else",
"components/repeat"
]
}
]
}
]
},
{
"tab": "Changelog",
"groups": [
{
"group": "Changelog",
"pages": [
"changelog"
]
}
]
}
]
},
"logo": {
"light": "/logo/wordmark-light.png",
"dark": "/logo/wordmark-dark.png"
},
"footer": {
"socials": {
"x": "https://x.com/evidence_dev",
"github": "https://github.com/evidence-dev",
"linkedin": "https://linkedin.com/company/evidence-dev",
"slack": "https://slack.evidence.dev",
"bluesky": "https://bsky.app/profile/evidence.dev"
}
}
}

Editing (`docs/editing.mdx`) Copy Section

title: 'Editing' Copy Chapter

import StudioOnly from '/snippets/studio-only.mdx';

3.21.143.81
3.209.193.182
3.215.195.233
18.189.109.43
34.56.211.45
35.192.240.48
35.192.240.49
35.192.240.50
35.192.240.51
35.192.240.52
35.192.240.53
35.192.240.54
35.192.240.55
35.234.176.144
35.234.176.145
35.234.176.146
35.234.176.147
35.234.176.148
35.234.176.149
35.234.176.150
35.234.176.151
104.197.50.84
*.us-east4.gcp.proxy.prod.fivetran.com
*.us-central1.gcp.proxy.prod.fivetran.com

/* Detailed source-code truncated for AI context efficiency. */

evidence init my-project
evidence init my-project --warehouse snowflake

evidence dev
evidence dev --port 8080

evidence launch
evidence launch --name "My Project" --upload-credentials

evidence link my-project
evidence link --project my-project

evidence unlink
evidence unlink --project my-project

evidence query "SELECT * FROM orders LIMIT 10"
evidence query --file query.sql
cat query.sql | evidence query -

evidence tables

evidence describe demo_daily_orders

evidence schema

evidence connectors
evidence connectors --json

evidence models
evidence models --json

evidence lineage
evidence lineage table orders
evidence lineage --branch dev/alex
evidence lineage --json

evidence validate
evidence validate --json

evidence docs                         # Overview
evidence docs search "chart"          # Search docs
evidence docs component bar_chart     # Component details

evidence signup

evidence login

evidence logout

evidence whoami

evidence orgs

evidence switch "My Organization"

evidence token

evidence version

evidence upgrade

evidence help

evidence telemetry            # same as status
evidence telemetry status
evidence telemetry disable
evidence telemetry enable

evidence serve
evidence serve --port 8080
evidence serve --host 0.0.0.0

evidence init my-project --warehouse snowflake
# or
evidence init my-project --warehouse bigquery

Provide exactly one of `password`, `private_key`, or `private_key_path`. Paths (`private_key_path`) are resolved relative to `connection.yaml`.

See the [Snowflake direct connector](/direct-connectors/snowflake) for the full field reference and how to create a read-only Snowflake user.

Provide exactly one of `keyfile` or `keyfile_json`. The `keyfile` path is resolved relative to `connection.yaml`.

See the [BigQuery direct connector](/direct-connectors/bigquery) for the full field reference and the service-account setup steps.

{% accordion %}
  ...
{% /accordion %}

{% accordion %}
    {% accordion_item title="Section 1" open=true %}
        Content for section 1.
    {% /accordion_item %}
    {% accordion_item title="Section 2" %}
        Content for section 2.
    {% /accordion_item %}
    {% accordion_item title="Section 3" icon="settings" %}
        Content for section 3 with an icon.
    {% /accordion_item %}
{% /accordion %}

{% accordion %}
    {% accordion_item title="Section 1" open=true %}
        Content for section 1.
    {% /accordion_item %}
    {% accordion_item title="Section 2" %}
        Content for section 2.
    {% /accordion_item %}
    {% accordion_item title="Section 3" icon="settings" %}
        Content for section 3 with an icon.
    {% /accordion_item %}
{% /accordion %}

{% accordion %}
    {% accordion_item %}
        {% accordion_title padding_top=8 padding_bottom=8 %}
            {% big_value data="orders" value="sum(sales)" fmt="usd" /%}
        {% /accordion_title %}
        Body content for this section.
    {% /accordion_item %}
{% /accordion %}

{% combo_chart data="demo.daily_orders" x="date" date_grain="month" %}
    {% area y="sum(total_sales)" /%}
{% /combo_chart %}

{% combo_chart data="demo.daily_orders" x="date" date_grain="month" %}
    {% area y="sum(total_sales)" /%}
{% /combo_chart %}

{% combo_chart data="demo.daily_orders" x="date" date_grain="month" %}
    {% area y="sum(total_sales)" series="category" stacked=false /%}
{% /combo_chart %}

{% combo_chart data="demo.daily_orders" x="date" date_grain="month" %}
    {% area y="sum(total_sales)" stacked=false options={
        gradient=true
    } /%}
{% /combo_chart %}

data_labels={
  position = "above"
  fmt = "date"
  size = 0
  distance = 0
  rotate = 0
  color = "string"
  border_color = "string"
  show_overlap = true
}

options={
  step = "start"
  smooth = true
  gradient = true
}

echarts_options={
    endLabel={ show=true }
    markPoint={ data=[{ type="max" }, { type="min" }] }
}

{% area_chart
	data="demo.daily_orders"
	x="date"
	y="sum(total_sales)"
	date_grain="month"
/%}

{% area_chart
	data="demo.daily_orders"
	x="date"
	y="sum(total_sales)"
	date_grain="month"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    series="category"
    date_grain="month"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    title="Sales Over Time"
    subtitle="Monthly sales performance"
    date_grain="month"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    series="category"
    stacked="100%"
    date_grain="month"
    title="Sales Distribution by Category"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    date_grain="day of week"
    title="Revenue by Day of Week"
    subtitle="Weekday vs weekend sales patterns"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    date_grain="month of year"
    title="Seasonality Analysis"
    subtitle="Sales patterns across months"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    date_grain="quarter of year"
    title="Quarterly Performance"
    subtitle="Q1 through Q4 comparison"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    date_grain="day of month"
    title="Daily Revenue by Day of Month"
    subtitle="Identify billing cycle patterns"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    date_grain="week of year"
    title="Revenue by Week of Year"
    subtitle="Weekly performance across the year"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    date_grain="day of year"
    title="Revenue by Day of Year"
    subtitle="Identify patterns across 365 days"
/%}

{% area_chart
    data="demo.daily_orders"
    x="date"
    y="sum(total_sales)"
    y_fmt="usd"
    date_grain="month"
    stacked=false
    area_options={
        gradient=true
    }
/%}

date_range={
  range = "today"
  date = "string"
}

y_axis_options={
  title = "string"
  title_position = "top"
  ticks = true
  baseline = true
  labels = true
  gridlines = true
  min = 0
  max = 0
  fit_to_data = true
  interval = 0
}