> ## 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.

# April 5, 2024

> Dynamic dbt Schema Swapping, 3-Argument SUMIF, Cell References in SUMIF AND COUNTIF, & 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>

## Dynamic dbt schema swapping

*Buck Ryan · `dbt` `modeling`*

Dynamic schema swapping for dbt development. Now you can test dbt changes in separate schemas trivially in the Omni front-end via branches.

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

## 3-argument SUMIF, cell references in SUMIF AND COUNTIF

*Cathy Lennon · `calcs` `workbook`*

3-argument SUMIF, COUNTIF including field references. Dynamic SUMs are now trivial in Omni.

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

## Selective workbook promotion (model cherry picking)

*Jamie Davidson · `workbook` `modeling`*

Selective promotion in the workbook. Now portions of the workbook can be promoted to the main model directly from the front-end - no more model plumbing to cherry-pick.

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

## Collapsible subtotaling tables

*Richard Czechowski · `table` `visualizations` `workbook`*

New collapsible subtotals in the data table.

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

## Pull requests and Git

*Conrad Slimmer · `git` `modeling`*

More development on pull requests and git in Omni

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

## Soft calculation errors

*Cathy Lennon · `calcs` `workbook`*

Better calculation errors. Sometimes your Excel formulas aren't right. Now they don't blow up the original query and you can share them to debug together.

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

## Case insensitive filtering

*Steven Talbot · `workbook` `dashboard`*

Case insensitive filtering for when the database isn't as clean as you wish.

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

## Looker dashboard migration

*Jamie Davidson · `modeling` `administration` `workbook` `dashboard`*

One-click migration of Looker dashboard into Omni, including visualizations.

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

## User attributes in front-end fields

*Steven Talbot · `workbook` `modeling`*

User attributes that can be used in field definitions via Mustache syntax

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

## Gauge charts (custom vis)

*Colin Zima · `visualization`*

A new custom visualization gauge chart, for folks that miss the Salesforce dashboard experience.

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