You can now rename columns in all tables, including joins and pivots. All column names are now also humanized by default, e.g.  Cost Per Click where COST_PER_CLICK once was. New functions * NUMBERVALUE for converting values to numbers Improvements * Date filters are now inclusive by default * Added sub-organization

We added date, multi-select and search filters you can add to your canvases to make it easier for yourself and others on your team filter every table, pivot, and chart without having to filter individual tables. Improvements * Hidden columns now get removed from downloaded CSVs as well * Added slugs to

You can now aggregate dates in pivot columns instead of just dates. Especially useful for financial models (e.g., P&Ls). New functions * DATEADD for adding intervals to date values Improvements * Added the ability to pivot pivots

You can now save your complex tables as reusable models for the rest of your team. For example, if you enriched a table with a series of complicated joins and pivots, you can now save that and reuse it instead of recreating it every time. Improvements * Added the ability to

We added horizontal bar charts, as well as the ability to toggle bar totals on all bar chart types. We also now support Okta SSO and magic links! Improvements * Added the ability to move columns in joins * Added medians in Snowflake and Redshift * The sidebar is now automatically closed in

This might be familiar: a new month rolls in and you get a pit in your stomach. The numbers went down significantly. You look a bit deeper and it turns out they didn't; it's just that the data for this new month is incomplete. To make this situation clearer, we

Charts can now be resized freely. You can make them as tall or wide as you wish, which adds a whole new level of freedom to dashboard design! We also now support uploading CSVs directly to the warehouse as new tables. New formulas * EXTRACTJSON for extracting data out of JSON

Added support for bar charts scaled to 100%. They are especially useful for seeing how the distribution of values changes over time. In design news, we switch the in-app font to Inter by Rasmus Andersson. We tried a lot of options, and Inter was the most suited for interfaces. Bye

You can now aggregate dates directly while making a chart, without having first to create a pivot! While we were at it, we also made it possible to create pivots and charts from scratch without starting with another table first. Improvements * Searching in the data library now searches columns as

Added a fun new chart type: funnels! New formulas * TEXTCONTAINS: check if a string contains a specific string Improvements * Simple pivot tables without rows or columns now allow formulas * Added warehouse selection when creating a new canvas for customers with multiple warehouses * Made query retries smarter * Allow undo on text

You can now mass show or hide columns. Useful for those pesky tables with a hundred columns. Improvements * Support connecting to Postgres via SSH tunnel * Cleaned up chart sidebar UX * Improved chart performance * Charts will now autosuggest series

Canvas now lets you search for any action in the tool by entering command + K.  Here, you can see all actions you can take along with their keyboard shortcuts. In addition, you can also search for terms and get quick access to our documentation. Improvements * Made improvements to tables so

Canvas now lets you see the lineage behind any chart or table so you can understand what underlying tables, pivot tables, or join tables were used to construct it. Click on any of the items in the lineage tree and Canvas will direct you automatically to that table to view

Ever wish you could add a calculated field to your tables? You can now do that easily with formula columns! Formulas let you use familiar spreadsheet syntax to do complex calculations based on other columns and other tables, all without opening up the SQL editor. We're initially launching with a

We made major performance upgrades to warehouse queries. They now run asynchronously, which means we handle slow queries better. We also added the ability to duplicate canvases, so you don't have to start from scratch to create a dashboard similar to the one you already have. Improvements * Fixed handling for

We added columns to pivots. This makes it easy to make stacked charts with multiple series. We also made it possible to sort pivots by values. Improvements * Added support for QUALIFY in Postgres * Made clone SQL cleaner * Fixed minor chart display bug * Added better error handling for Postgres and Snowflake

We added dbt column definitions to the table info sidebar. This lets you reuse the documentation you worked so hard to maintain in your models! We also improved query performance by batching multiple queries together. Improvements * Fixed joins with ambiguous columns * Fixed boolean filters * Fixed pivoting when a cell is