> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# November 15, 2024

> Flexible Totals (Including Dimensions and Calc), Calculations with Controls, Better SQL, and More

<Note>
  **Stay in the loop!** Subscribe to the [demo RSS feed](/demos/rss.xml) to be notified when we post new demos.

  Demos highlight what we are working on or experimenting with, but are not a guarantee of release. Let us know your thoughts at [support@omni.co](mailto:support@omni.co).
</Note>

## Totals for everything

*Cathy Lennon · `Calcs` `Workbook`*

Totals for everything!  Now users can toggle between native totals (ungrouped aggregates), simple totals, min, max, and count on any field.  This includes bring flexible totals to dimensions (!) and calculations (!).

<Frame>
  <iframe src="https://www.youtube.com/embed/FFcJY2eEkgA" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Controls with calcs (calcs with field swappers)

*Jamie Davidson · `Calcs` `Workbook` `Dashboards`*

Now calcs work seamlessly with controls (field swappers).  So dashboards with dynamic timeframes, dimension swappers, and measure swappers can seamless build calculations on top.

<Frame>
  <iframe src="https://www.youtube.com/embed/HQo9ybr7lmc" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Better SQL autocomplete + run highlighted SQL

*Richard Czechowski · `Sql` `Workbook`*

More work to polish up our SQL autocomplete system, then a demo of run highlighted SQL for folks that need to test as they build larger SQL statements.

<Frame>
  <iframe src="https://www.youtube.com/embed/-SgxbOMZ4mo" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## in\_query

*Steven Talbot · `Modeling` `Workbook`*

Now in\_query works with both fields and views, plus a quick demo of how join trees are handled for in\_query.  Making sure whatever crazy dynamic field handlers you need are buildable.

<Frame>
  <iframe src="https://www.youtube.com/embed/98HWcihgZMM" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Embedded dashboard sharing demo

*Elliot Park · `Embed` `Workbook` `Dashboards`*

A first look at the embedded dashboard building and sharing workflow (embedded content management).  Now embedded users can build their own dashboards and share with co-workers just like native app users.

<Frame>
  <iframe src="https://www.youtube.com/embed/ZsykJewHtYw" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Dashboard CSS docs that are beautiful

*Jared Hardy · `Embed` `Dashboards`*

Jared gives us a preview of the new documentation explaining all of the CSS  control for dashboards in Omni.

<Frame>
  <iframe src="https://www.youtube.com/embed/kgirwSB16xA" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Better form entry

*Luke Bowerman*

Some polish to make forms always focus to complete / save on Enter

<Frame>
  <iframe src="https://www.youtube.com/embed/CMlbAaQhJNo" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## Sort favorites alphabetically

*Luke Bowerman*

<Frame>
  <iframe src="https://www.youtube.com/embed/24KFfNeHfZQ" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>

## New toast system

*Luke Bowerman*

A quick demo of our new in-app toast system

<Frame>
  <iframe src="https://www.youtube.com/embed/HoiebAjCk_k" width="100%" height="400" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />
</Frame>