Skip to main content

Frequently Asked Questions

A compiled list of one-off questions with links to notes in the docs or quick answers

How do I count / sum / average?

Omni uses a lot of right click actions, try right clicking on the field you want to aggregate and we should have some quick calculations.

I still don't see aggregates?

Sometimes we aren't smart enough to aggregate a specific field. This is often because we don't recognize the type (for example, we think it's a string or some unknown type rather than a number). Often you can cast the field or tune the model to open up the expected calculations. Ping us if you need help working through it.

How do I add to dashboard / clear query / close the field picker / some other action?

Try the menu at the top of the page (file, view, etc). We're working on putting every action exactly where it should be, but when you can't find it on page try the header.

Is there a way to add a row with totals to the query?

Coming soon to general availability. Right now this is a feature flag we can help turn on, just ping your Slack channel.

Is there a way to add a subtotals to the result set?

Needs a bit of formatting polish, but we also have a backend for sub-totaling. Reach out if it's important and we can talk about it.

Why isn't my dimension aggregating? Why isn't my number a sum?

Each transaction or record usually has a numeric value associated with it (say the cost of a given purchase). If you select this dimension, Omni will simply return a list of all the different transaction values, which is not usually what you want. To total purchases, for example, simply right click or click the arrow and select sum. This will transform the dimension into a metric that you can then aggregate across other dimensions (say purchases by state).

How do I control caching policies?

Right now there are no controls. Queries are cached in two ways - result set caches hold exact query results and can be shared between users with shared permissions to the underlying data. Query results are cached for 60 minutes (this will become configurable later).

Omni also caches result sets in the browser for individual user re-query. This means if you pull down results by day and then regroup by week, Omni can use the daily result set to calculate the count or sum by week. This cache is volume based and will hold the last 30 query results from a session. There is also no configuration for the browser cache, but will be soon.

What is the square icon that is not a date or number or string or boolean in the field picker? How do I set a field type in Omni?

That means we do not recognize the data type. You may need to transform the field via CAST (ie model) to do more productive things with the field in Omni (ie stringify a blob).

Is there a quick way to remove all fields from the table?

Yep, check the 'Tab' menu for 'Clear Query', you can also remove just the fields or just the filters, and see the keyboard shortcuts.

Can you sort by one column, then another column?

Yes, simply hold shift after your first column sort. The right click menu also offers options to remove an additional sort.

Can you query the data unsorted?

Yes, simply right-click on the column header and remove sort; you can also remove sort in the SQL query itself. Omni will often sort queries by default.

What is the row limit?

UI queries have a row limit of 10,000. SQL queries have a limit of 50,000 (and can be used the relax the 10,000 limit in the UI).

Do views I save use the row limit?

By default, UI queries saved as view will strip the row limit. The row limit can be re-included by manipulating the YAML model directly.

Can I drill into measures to see the specific items in a count?

Yep, right click on the given measure in your data table, and you'll be offered drill down to the rows. We'll build out more configuration for the specific columns on drill in the future at both the model and content.

How do I get missing dates to some up in my results set (some dates are not in the data set)?

This is an unfortunate property of SQL, but Omni offers an option to add in missing rows. Simply right click on the column or pivot and select 'fill in missing rows'.

Fill in missing rows is not showing up, what did I do wrong?

Omni can only fill missing rows in a data set where we know the list of rows to fill. This means, for now, the dimension must be an enumerated list (case statement, boolean, or known list like day of week name) or a bounded date. To make sure filling appears on dates, make sure there is a filter that sets a start and end date for the query, which will set the range Omni fills over (ie [2023] will fill for all days in 2023, before and after today).

All my results are showing up with 0 or 1, what is happening?

This is a frequent problem with integer math - dividing two whole numbers. We're looking to add helpers for these in the model, but this can also be avoided by multiplying by 1.0 to cast the result to a decimal.