Google Sheets embedding, Transpose & measures on rows, Calculations refinement, & more
November 4, 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.
Dynamic Schema
New model configuration for dynamic schema handling (ie a single model that can be configured to different schemas for each user)
Exploring Calculation Usage
Live exploration of early calculation function usage, plus a demo of the calculation UX live doing some string parsing.