Changelog

Custom SvelteKit Configs: are now enabled, and will overwrite the Evidence defaults.

Bugs

• Fix Bar Chart issue that caused pages to lock

Docs

• Added missing SQL Server env vars

• Markdown partials to reuse markdown fragments in different pages
• Table delta content type for DataTables
• Conditional formatting for DataTables
• Stepped Line Chart & Area Chart property (Thanks @commitsovercoffee)
• Alias for Value component’s column property, value to match other components
• Improved Details component with new styling and open prop
• Improved Tabs component styling (Thanks @commitsovercoffee)
• Column component reactivity to prop changes (Thanks @jdimmerman)

Bugs

• Sankey chart animation duration (Thanks @commitsovercoffee)
• Format Reference Line value based on axis
• Templated pages not built for long Data Tables

Docs

• Add helper note for connection panel
• Update environment variables in deployment panel

• MotherDuck: Connect to MotherDuck with Evidence
• Details: Component to display collapsible content which is hidden by default

Bug Fixes

• BigValue format tag error on data update
• Table sort for NaN, null and undefined values

Docs

• Netlify templated pages issues
• MotherDuck service token guide

• DuckDB 0.8.1: Evidence now supports DuckDB v0.8.1
• Modal: Popup component to display content on top of the page (Thanks @nidhi-kala)
• Accordion: Component to display collapsible content (Thanks @nidhi-kala)

Evidence Labs

• Leaflet Map: Experimental map component that uses Leaflet.js to render a map with a set of points

• Number and date formatting now available within components
  • Use format props like fmt in Value and xFmt/yFmt in charts
  • Accepts Excel-style format codes, Evidence built-in format tags, or custom format tags
  • Full list of built-in formats here
• fmt function now accepts the same formats as format props. Example: { fmt(value, #,##0€) }
• VS Code Slash Commands: type / in VS Code to see a list of available components and markdown syntax you can insert into your page (Evidence VS Code extension v1.3.4)
• Auto-import custom components: you no longer need to use a script tag to import custom components
• Reduce size of builds for template pages: removes redundant data files during build for templated pages, which should significantly speed builds up
• Upgraded & standardized icons: makes icons more consistent across Evidence and makes it easier for contributors to find and use icons

Bug Fixes

• Code block spacing fix - 🙏🏼 @lorinaX!
• Grouped bar chart fix
• Fix for hot module reloading
• Breadcrumb and BigValue visual fixes
• Fix for sources folder in template

Evidence Labs

• New experimental components added
  • WorldMap
  • Cohort Analysis
  • Summarizer
  • GitHub Stars
  • Google Sheet Embed
  • PDF Embed
  • Footnote
  • Grid

• Specify Schema and Role in Snowflake: Allows you to add optional role and schema fields for all queries.
• VSCode Extension Updates (v1.2.0)
  • Install and use Evidence from VSCode: without touching the command line
  • Keyboard Shortcuts: Ctrl+(Shift)+R to start (stop) Evidence
  • Prompt to Install Node: if you don’t have it installed
  • Evidence Opens to the Side: by default
  • Extension Walkthrough: to show you around

Bug Fixes

• UI issues with Breadcrumbs and Big Value
• Multiple Queries Running on Startup

• Component Plugins: allow you to add third party components to your Evidence project.
• Evidence Labs: is a demo plugin we’ve created to show how plugins work, and includes a new France Map component.
• New ways to Connect to BigQuery & Snowflake: including key-pair, OAuth, External Browser connections and the gCloud CLI.
• Deprecated Environment Variables: to prevent name collisions between certain variables. You might notice warnings with your existing configurations, check the settings page of your Evidence app for the updated environment variable options.
• Customise Area Chart Line Color: with the lineColor prop to help make your lines pop.
• Wrap Text in DataTable: for when your fields are extra long.

The latest version of the Evidence VS Code extension includes:

• Lightning Fast New Evidence project Command: to create a project
• Auto-Connect: to the included DuckDB packaged with the extension
• Detects and Activates the Extension: when you open an Evidence project
• Auto-Boot: Evidence in the browser when you open an Evidence (or turn this off in the settings)
• Configure Default Port: for Evidence to run on

and more! (🙏🏼 @RandomFractals)

• Upgraded VSCode Extension: Adding in-built commands to create a new project, start/stop the dev server, run builds, clear the query cache and more (🙏🏼 @RandomFractals)

• Support for DuckDB 0.8.0: if you get an error about your DuckDB database being outdated, follow the instructions in the error message to upgrade.

A lot of new functionality coming out today!

• Annotations: using the new ReferenceLine and ReferenceArea components add custom highlighting, show targets and thresholds.
• Format function: to format numbers used outside of Evidence components.
• Adjust Chart Heights: using chartAreaHeight prop on Bar, Line, Area, Scatter, and Bubble charts.
• SQL Server connector: awaited by the Microsoft users out there.
• Click handler for Echarts: to allow custom actions on chart click. (Thanks @jjagielka)

Bug Fixes

• Error icon in value component (Thanks @nidhi-kala)
• Chart width on PDF export
• Collapsible section dropdown’s transition animation
• Component copy-paste in Firefox
• Update DataTable paginated property when dataset size changes (Thanks @jdimmerman)

We’ve released a few fixes the community identified recently with the latest release

• CSV connector: should now work without any hacks.
• BigQuery Wide Numeric Type: columns should appear properly in Evidence now
• Design and Styles:
  • Added back some list styling which got dropped in the last version
  • Windows bugs with the query viewer have been resolved
    • Horizontal Scroll bars when queries are hidden
    • Data disappearing when scrolling horizontally in query viewer
  • Funnel Chart tweaked to be more legible

• Standalone .sql Files: great for when you need the same query in multiple pages in your app
• Markdown Frontmatter Support: which allows you to specify page metadata (for social previews and unfurls), as well as which queries to import
• Alert Component: for when you need a reader to really pay attention.
• Tabs Component: allows you to show different information in user-selectable panels

Bug Fixes

• Visual regressions with sizing and positioning
• Auto close settings menu when you click outside it

This release includes breaking changes, as we upgrade to SvelteKit 1.0. Node 14 is no longer supported, use Node >= 16.

• Upgrade DuckDB to 0.7.1: The most recent DuckDB file format is now supported (🙏 @gregwdata)
• Display Non-SQL Code Blocks: (Non-executable) code blocks will now display if you use the name of the language for the code fence.
• Sankey Diagram: Added (🙏 @nidhi-kala)
• Upgrade SvelteKit to 1.0: This unlocks lots of cool new features for the future, stay tuned! (🙏 @csjh)
  • Custom SvelteKit syntax and custom layout files may need to be renamed if you use them.

• Fix for sources directory (CSV connector): eliminates an error and unexpected behaviour that occurs when a sources directory is added to a project
• Fix breadcrumb capitalization: some words were not being capitalized in breadcrumbs

• CSV Support: new connector that lets you query CSV files directly in your SQL (using duckdb under the hood!)

• Fixes for DataTable:

  • Value formatting: fixes unit summaries in DataTable (e.g., 12,000 ---> 12k)
  • Download button fixes: download button was not appearing in tables without pagination; downloadable prop now works in all scenarios (turn on or off download ability for your users)

• Testing & dev process improvements in our core open source repo:

  • Playwright implemented in the core Evidence repo: the start of our UI test suite for our open source repo
  • “Next” package: new features and fixes now get released under a “next” package before they’re released to everyone

• Fail builds on error: new option to fail builds when there are errors in components or queries -️ US state map + Map links: choropleth map component for US states, includes feature to click on a state and have it follow a link
• Minimal Venn diagram: 3-circle venn diagram with ability to label each dataset/overlaps -️ Column error handling in DataTable: gives an inline error when column references are missing -️ Funnel chart upgrades: adds legend, labels, and modifies the height of funnel charts (🙏 @nidhi-kala)
• Bug Fixes
  • Enable various MySQL SSL options (🙏 @hooopo)
  • Fix table of contents links for parameterized pages

• Table Images & Links: Include images and clickable links in your tables, for both internal navigation and to external sites.
• Table Sort, Search and Customization Options: as well as better control of how data is displayed in your table
• Project Styles & Themes: Edit the colors, fonts, and page layout of your Evidence project with the app.css and __layout.svelte files.
• Bug Fixes
  • Fix null labels in chart legends and tooltips
  • Remove header bar from print view
  • CSS leaking from settings page to other pages

• Revamped DataTable: with better defaults, and more customization options.
• Bug Fixes:
  • Redundant queries executed when building parameterized pages

• Improved Visual Hierarchy: of H1-H6 and lists to separate content more clearly -️ Multi Environment Support: so you can use dev data when developing reports in Evidence. -️ Funnel Chart: component added (🙏🏼 @dhrjarun)
• Scroll Support on Query Viewer (🙏🏼 @afzalsayed96) -️ Improved Accessibility: of our UI components (🙏🏼 @yukseltron) -️ Download Data from Charts: so users can export chart data to wherever they need it (🙏🏼 @yukseltron)
• Optional Postgres Schema Field: which makes using data environments separated by schema easier
• Turn Off Default Chart Sort: which users were finding confusing (Bar, Line, Area)
• Bug Fixes
  • Reactivity for 100% stacked charts

• DuckDB Connector: so you can use the “SQLite for Analytics”. (🙏🏼 @jwills, @mause)
• Bug Fixes:
  • Hardcoded number of rows in DataTable
  • Erroneous console logs

• Styled Blockquotes: so you can add emphasis to quotes and text.
• Faster Install on Mac Silicon: with an upgrade to SQLite. -️ Better Contributor Experience: with automated testing, a clearer contributing guide, and simpler install experience.
• Docs Updates
  • How to reference queries (🙏🏼 @roveo)
  • Using parameterized pages
  • Inserting images and static files
• Bug Fixes
  • Unclickable Breadcrumbs
  • Charts stretching too wide (🙏🏼 @afzalsayed96)
  • Parameterized pages showing up in sidebar (🙏🏼 @quoid)

• Custom chart examples: showing how to create custom charts outside the core Evidence library.
• More intuitive custom components: organized in /components/, with better docs.
• Better date parsing and handling in components: so you can always get the date format just right. -️ Redshift connector in UI: no more guessing using Postgres settings.
• Bug Fixes: To Remove breadcrumb links to non-existent pages, Stop format tags applying to strings and Ensure charts copy nicely.

• Native markdown table formatting: to make your tables look slick. Plus a VSCode shortcut to speed up markdown tables - try typing table. -️ Updated Evidence diagram: explaining more clearly what Evidence does.
• Titles for tooltips: for Scatter Plots and Bubble Charts.
• Tutorial in new projects: which shows when run for the first time - it’s optional and less than 5 mins.
• Bug fixes: For time-based bar charts and boolean appearance in tables.

A lot of users have styled some version of this into their projects using CSS, but the new <BigValue/> offers a lot more than just styling.

• BigValue includes support for colour coded comparison, and a sparkline. They look great on their own, or arranged in a set.

Users told us our mobile experience could be improved, so we’ve reworked it.

• Top-right hamburger menu: Access all the pages in your Evidence project on mobile using the hamburger
• Fewer bugs: We’ve introduced end-to-end tests which means we catch bugs before we release them!

-️ Format tags: covering a wide range of dates / times, many major currencies, numbers and percentages

• Auto formats tags: which infer the number of decimal places and units (k, M, B) to display based on the input numbers
• Custom formats: if you can’t find what you need in our standard tags, you can make any format supported by excel format strings eg ”$” ##0,000, “k”
• Static folder: so you can add images and other static files to your project

• Improved chart tooltips: cleaner-looking tooltips with formatted titles and numbers
• Type system: all data types from our supported data warehouses now map cleanly to Evidence’s 4 data types: string, number, date, and boolean
• See column types in query viewer table: below each column name, you can now see the data type for each column in your query -️ Formatted data in query viewer tables: when looking at your data in a query viewer, you’ll now see formatted data based on the format tags you include in your query (e.g., _usd)
• Bug Fixes: Changing names of queries caused errors, Missing .gitignore file caused errors when setting up SQLite

• More intuitive query data syntax: before {data.my_query} , after {my_query}
  -️ Updated Snowflake connector: so everything you need is now in the settings menu
• Copy-Paste “just works”: just Ctrl-C, Ctrl-V to get Evidence images and text to documents and emails
• No false untitled query warnings: squashing a bug where ghost queries were being detected

• Fixed sorting issues: queries results now always sort as specified in your SQL
• Auto-open a browser tab: when you npm run dev
  -️ VSCode Extension shortcuts improved: cmd-shift-V/cmd-K V to open Markdown Preview mode
• Evidence has a new demo project! Check out how business is going for Needful Things Inc.

This release makes it easier to share your Evidence project outside Evidence.

• Component download options: Download DataTables and query results as CSVs, save charts to PNG
• Export to PDF: Save reports to PDF from each Evidence page
• Telemetry opt-out: We record anonymous data to help us figure out when things are broken, and count the number of Evidence projects. If you’d rather we didn’t, you can now easily turn this off in the settings menu

• Deploy to Vercel: Added to settings panel
• Persistent show/hide of SQL and query results: Rather than expanding queries after each page refresh - Evidence will now remember the state before reload.
  -️ Pass Evidence command line arguments to Svelte-kit: Allows configuring Svelte-kit options from the command line. E.g. to change the port Evidence runs on, use npm run dev -- --port 4000

Users told us they wanted a simpler project structure and easier options to connect to their databases and deploy.

This release revamps the UI, strips back the project structure, adds UI options for connection and deployment. Read the PR in Github.

• Simplified Evidence project structure - fewer confusing files cluttering your project directory
• UI refresh - auto-generated sidebar nav, better errors and breadcrumbs
• Slick database connections - now just use the settings menu in your Evidence project
• Deploy straight from Evidence - get your Evidence project online from the settings menu
• Updated, easier tutorial - a faster, funner start to using Evidence