Google Sheets embedding, Transpose & measures on rows, Calculations refinement, & more
November 3, 2023
Google Sheets Embedding
A quick demo of what the dynamic embedding in Omni opens up. Here we show an embedded Google Sheet for end-user input on dashboards. The results are auto-pushed to BQ and joined into other queries dynamically.
Transpose and Measures on Rows
Fresh controls for transposing tables, or even just transposing metrics independently. All of the goodness around calculations and charting comes along with the new measure controls.
Calculations Refinement
More refinement of the Excel/Sheets syntax. Dynamic column naming and formatting, easier empty calculation columns, and more elegant loading of results on only changed functions.
Autovis
Lots of improvements to retain changes to the visualization configuration while adapting to dynamic querying and exploration.
Timezone Configuration
The launch of timezone configuration in Omni at the query and database level.
Dynamic Schema
New model configuration for dynamic schema handling (ie a single model that can be configured to different schemas for each user)
KPIs
Some clean-up of the KPIs with value formatting
Exploring Calculation Usage
Live exploration of early calculation function usage, plus a demo of the calculation UX live doing some string parsing.
Dynamic IP Allowlists
New IP allowlist functionality