XLOOKUP, Embedded Workbooks, Dynamic Fields / Select Fields From Filters, & more
May 3, 2024
Absolutely massive week.
XLOOKUP
Launched behind a flagThe launch of xlookup, bringing cross-tab analysis to any user. Now time series joins across tabs, fact lookups, etc are trivial in the workbook - continuing the strategy of bringing the best of spreadsheets into Omni.
Embedded Workbooks
LaunchedA first look at the embedded workbook experience; now customers can share full analytical experiences with their customers alongside curated dashboards in embedded use cases
Dynamic Fields / Select Fields From Filters
LaunchedThe launch of dynamic fields in Omni, allowing tables columns to be controlled by filters entirely in the front-end - timegrain swappers, dimension swappers, and measure swappers are now available for flexible analysis workflows (dashboard support coming soon)
Parameters / Filter Passing into Fields
LaunchedFilters can now be injected into fields for parameterized reporting - opening up use cases like dynamic formatting, forecasting, or simply filters that can pass to calcs in the UI
Filter Passing Between Dashboards
LaunchedNow model urls arguments can accept dashboard filters for complete context on cross-drilling experiences (passing the full filter context from one dashboard to another)
dbt Dynamic Schema Migration
LaunchedNew tooling to migrate a data model to dynamic schemas. This opens up the ability to test dbt changes on test schemas across the full app.
More Tables - Descriptions, Conditional Formatting Bars
LaunchedLots of work on tables: optional field descriptions in the table; touch-up to allow conditional formatting on table bar charts, and a bunch of polish across the table experience
Period-Over-Period Clean-Up
LaunchedSome touch-ups to the period-over-period experience to clearly explain the time slices