Demos

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.

Jack SweeneyJack SweeneyWorkbook, Dashboard, Analysis Pattern, Embed

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.

Steven TalbotSteven TalbotTable, Visualization, Workbook

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.

Richard CzechowskiRichard CzechowskiCalcs, Workbook

Autovis

Lots of improvements to retain changes to the visualization configuration while adapting to dynamic querying and exploration.

Jamie DavidsonJamie DavidsonVisualization

Timezone Configuration

The launch of timezone configuration in Omni at the query and database level.

Cathy LennonCathy LennonModeling, Administration

Dynamic Schema

New model configuration for dynamic schema handling (ie a single model that can be configured to different schemas for each user)

Conrad SlimmerConrad SlimmerModeling, Administration, Analysis Pattern

KPIs

Some clean-up of the KPIs with value formatting

Elliot ParkElliot ParkVisualization

Exploring Calculation Usage

Live exploration of early calculation function usage, plus a demo of the calculation UX live doing some string parsing.

Colin ZimaColin ZimaCalcs

Dynamic IP Allowlists

New IP allowlist functionality

Brian FrantzBrian FrantzAdministration