August 14, 2024 - Improved workbook ergonomics, more dashboard configurations, and a whole lot of magical modeling
August 14, 2024
Improvements in workbook ergonomics #
Reorder Tabs
Drag and drop your workbook tabs to your heart's content! We’ve also improved the scrolling of the tab bar for workbooks with a large amount of tabs. [Watch the demo with some sneak peaks of other features]
In-use toggle for the Field Picker
Streamlining the field picker experience, users can now use a toggle under the search bar to see which fields are in-use. [Read more]
Visualization Improvements #
Auto-vis Improvements
Enormous improvements to stickiness in visualization settings and auto-vis. Now chart settings will retain even after query changes; toggling visualization types will retain settings; and auto visualization will retain tuned settings. [Watch the demo]
More table options
Customize tables to meet your needs, we’ve added new styling and functionality options. Change column widths, truncate or wrap text, customize the colors, and more!
![Table formatting](https://images.ctfassets.net/tg3z0zgy3dgv/7Ch7FOBa1Ml1trW4GGZgpu/668ef5825413c7f3ad0129b4f4281337/Screenshot_2024-08-14_at_12.35.55_PM.png?w=1600&fm=webp)
Adding Boxplot
A favorite custom visualization now comes out of the box! Users can find the option directly from the chart selector. Use the visualization controls to choose if it is Quantitative or Nominal (under X) and the sort order (under both X + Y).
![Boxplot](https://images.ctfassets.net/tg3z0zgy3dgv/3UDeDO0FLSfQgARCHhQW7X/3da7febaa463d20e1d0fb72b3c94fb21/Boxplot.png?w=1600&fm=webp)
More styling options for KPIs
From the visualization controls in a workbook users can now customize the alignment and text sizes for each component of the KPI to make sure they layout just how you want.
![KPI Styling](https://images.ctfassets.net/tg3z0zgy3dgv/60tCXPUjYBv9uftw61JsHo/a425d7bfbec2dd0733f8ac23621497ae/KPI_Styling.png?w=800&fm=webp)
Dynamic Dashboards #
Dashboard Vanity Urls
New settings for vanity dashboard URLs, making navigation simple and contextual - now it's as easy as dashboard/CorporateDash instead of dashboard/1 or dashboard/lkjdfs (unless you want that!). This also means that you can more easily make updates to an embedded dashboard without requiring an engineer to point from one identifier to another, by instead pointing to a fixed, immutable URL.
![Vanity url](https://images.ctfassets.net/tg3z0zgy3dgv/D6qOGQSx6famow06w5JEJ/aed93aac29c977beb426ca9cdeca1c8c/Vanity_url.png?w=800&fm=webp)
Single value dropdown filters
A new filter type is available on dashboards where a user can only select one value for the filter. To create this, go to ‘Edit Filter’ and see the new option called ‘Filter control’. By default Omni uses Advanced filters, but you can now select ‘Single value dropdown’ as a new filter experience.
More Controls now available on dashboards
When editing dashboards, select the ‘Add control’ option to now create more powerful dashboard experiences by leveraging parent controls as well as period over period controls directly on the dashboard.
![PoP Dashboard](https://images.ctfassets.net/tg3z0zgy3dgv/41Vht6yYzi8pFVDbw1rCg4/7021b7a0ec13831d1929fcc0050da751/PoP_Dashboard.png?w=1600&fm=webp)
Faceted filters on dashboards
There’s a new dashboard setting to enable or disable faceted filters. When filter faceting is on, one filter’s selection will limit the values suggested in other filters. For example, the ‘State’ filter will limit the results in a ‘City’ filter to show only relevant city names.
![Faceted filter](https://images.ctfassets.net/tg3z0zgy3dgv/6sw2BzxNLCGf3ioS5r5IMV/daa99c10e181954fc9edc6ed9cb812cc/Faceted_filter.png?w=1600&fm=webp)
Downloads #
Unlimited CSV Downloads
The world’s your oyster! Now you can take as much data as you want (with some time out limits) out of the Omni app in a csv format.
Modeling Magic #
IDE Auto Error Fixing
To speed up development, many of the errors in the IDE now have a button on the right hand side of the error to automatically fix them. This works in branches as well! (Watch the demo)
![IDE Errors](https://images.ctfassets.net/tg3z0zgy3dgv/7y8Zhf9v1ea6NpLXIbZAME/e7b2eaad17c8fc31959b7f28a2ee19f9/IDE_Errors.png?w=1600&fm=webp)
Scheduled Schema Refresh
After establishing a database connection, Admin can use a cron string to schedule a soft refresh of the schema which merges the newly generated schema with the existing one without overwriting it. This will automatically keep your Omni model in sync with changes in your database. (Read more)
![Schema refresh](https://images.ctfassets.net/tg3z0zgy3dgv/3RqIfDJ0IGZTAYeZIi28Jn/6952e86f89e3612170d18094beefdc8a/Schema_refresh.png?w=938&fm=webp)
Semi-additive measures/Omni dimensionalize
Working with data that doesn't aggregate over time (MAUs, credit balances, etc) can be painful. Now we have native operators that can handle all that nuance with minimal effort by creating a field that leverages omni_dimensionalize
. (Read more)
Improvements to the Git Integration
We’re streamlining the integration between Git and Omni by allowing users to commit changes from outside Omni in Git as long as the changes are in valid Omni YAML.