# Latest **URL:** https://community.omni.co/latest.md?page=7 [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) **Page:** 8 --- ## [If I save a query as a view, will the row limit of that query get applied to that view?](https://community.omni.co/t/if-i-save-a-query-as-a-view-will-the-row-limit-of-that-query-get-applied-to-that-view/91)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:06pm UTC](https://community.omni.co/t/if-i-save-a-query-as-a-view-will-the-row-limit-of-that-query-get-applied-to-that-view/91 "2024-06-03T19:06:07Z")
When you create a Query View, Omni will strip the row limit that you’ve defined in the UI. If you’d like to include that row limit, you can edit the definition in the YAML model directly by adding the parameter limit: \[r… --- ## [Can I drill into measures/aggregations to see the underlying data?](https://community.omni.co/t/can-i-drill-into-measures-aggregations-to-see-the-underlying-data/90)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 6:57pm UTC](https://community.omni.co/t/can-i-drill-into-measures-aggregations-to-see-the-underlying-data/90 "2024-06-03T18:57:23Z")
Yup! If you click on a measure in your data table or visualization, you’ll see the option to drill to see the underlying rows. By default, Omni will show some fields from the view that the measure is defined in, but you … --- ## [How do I get missing dates to show up in my results set?](https://community.omni.co/t/how-do-i-get-missing-dates-to-show-up-in-my-results-set/89)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 5:52pm UTC](https://community.omni.co/t/how-do-i-get-missing-dates-to-show-up-in-my-results-set/89 "2024-06-03T17:52:44Z")
If you’re missing data for some dates in a given period, but you still want to have a row for each of the dates in that period, you can use Omni’s “Fill in Missing Rows” feature to fill in those dates. Just right-click t… --- ## [Why don't I have the option to "fill in missing rows"?](https://community.omni.co/t/why-dont-i-have-the-option-to-fill-in-missing-rows/88)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 5:48pm UTC](https://community.omni.co/t/why-dont-i-have-the-option-to-fill-in-missing-rows/88 "2024-06-03T17:48:16Z")
In order to fill in missing rows on a dimension, Omni has to know the full set of values that the dimension can take. For now, this means the dimension must be either a: Group (using Omni’s Group functionality) … --- ## [How do I add a subtotal to the query?](https://community.omni.co/t/how-do-i-add-a-subtotal-to-the-query/87)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 0\ **Last updated:** [May 31, 2024, 10:42pm UTC](https://community.omni.co/t/how-do-i-add-a-subtotal-to-the-query/87 "2024-05-31T22:42:39Z")
Row totals and column totals are available by navigating to the field’s column header in the query, and clicking on the vertical three-dot menu icon that appears when you hover over the header or by right clicking then s… --- ## [Why is my numerical column only showing 0 or 1?](https://community.omni.co/t/why-is-my-numerical-column-only-showing-0-or-1/85)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 31, 2024, 7:04pm UTC](https://community.omni.co/t/why-is-my-numerical-column-only-showing-0-or-1/85 "2024-05-31T19:04:48Z")
This is a frequent problem with integer math (e.g. 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. For… --- ## [Why can't I add row/columns totals on my tables?](https://community.omni.co/t/why-cant-i-add-row-columns-totals-on-my-tables/84)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 31, 2024, 6:51pm UTC](https://community.omni.co/t/why-cant-i-add-row-columns-totals-on-my-tables/84 "2024-05-31T18:51:03Z")
Row/column totals only work on measures (aggregate fields). If you’d like to include a row/column total on a dimension, you can often swap your dimensions for an aggregate. For example, if you have a dimension for Sale … --- ## [What's the difference between dimension fill and value fill?](https://community.omni.co/t/whats-the-difference-between-dimension-fill-and-value-fill/83)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 31, 2024, 6:39pm UTC](https://community.omni.co/t/whats-the-difference-between-dimension-fill-and-value-fill/83 "2024-05-31T18:39:46Z")
Dimension fill and value fill are slightly different. Dimension fill will supply missing rows or columns for a dimension, such as a date series or an enumerated list like yes/no or entries in a case statement. It ensure… --- ## [Why don't my column / row totals match the values in the table?](https://community.omni.co/t/why-dont-my-column-row-totals-match-the-values-in-the-table/82)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [May 31, 2024, 12:27am UTC](https://community.omni.co/t/why-dont-my-column-row-totals-match-the-values-in-the-table/82 "2024-05-31T00:27:25Z")
In some cases, you may notice that your totals don’t match up with the values in the table. Take this example, counting the number of users who purchased items over a 6 week period: If you sum up the 6 rows, you’d ge… --- ## [How to troubleshoot \`TIMESTAMP\_TZ\` datetime confusion in Snowflake](https://community.omni.co/t/how-to-troubleshoot-timestamp-tz-datetime-confusion-in-snowflake/80)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 30, 2024, 7:59pm UTC](https://community.omni.co/t/how-to-troubleshoot-timestamp-tz-datetime-confusion-in-snowflake/80 "2024-05-30T19:59:33Z")
Snowflake has a data type called TIMESTAMP\_TZ, which stores timestamps in UTC alongside a timezone offset. When querying this datatype in Omni, this data type lead to confusion and seemingly inconsistent behavior when qu… --- ## [How do I include a comma in my filter value? (e.g. "San Francisco, CA")](https://community.omni.co/t/how-do-i-include-a-comma-in-my-filter-value-e-g-san-francisco-ca/79)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 30, 2024, 7:48pm UTC](https://community.omni.co/t/how-do-i-include-a-comma-in-my-filter-value-e-g-san-francisco-ca/79 "2024-05-30T19:48:03Z")
By default, Omni will delimit filter entries using commas — so typing San Francisco, CA will split into San Francisco and CA. To explicitly include a comma in a filter, you can “escape” the comma with a \\, e.g. you woul… --- ## [Why don't I see the aggregate option I want when creating a new aggregation field?](https://community.omni.co/t/why-dont-i-see-the-aggregate-option-i-want-when-creating-a-new-aggregation-field/77)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 0\ **Last updated:** [May 29, 2024, 11:43pm UTC](https://community.omni.co/t/why-dont-i-see-the-aggregate-option-i-want-when-creating-a-new-aggregation-field/77 "2024-05-29T23:43:36Z")
Sometimes we don’t aggregate a specific field when we generate the view. 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 or a date). Examp… --- ## [How do I reference a filter value? (Filters as parameters)](https://community.omni.co/t/how-do-i-reference-a-filter-value-filters-as-parameters/74)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 29, 2024, 7:17pm UTC](https://community.omni.co/t/how-do-i-reference-a-filter-value-filters-as-parameters/74 "2024-05-29T19:17:59Z")
Referencing a filter value in your query or dashboard can be a great way to improve interactivity within Omni. For example: Explicitly highlight filter values on a dashboard: Highlight how dashboard filters are intera… --- ## [How do I automatically construct a filter URL for passing through fields to a dashboard](https://community.omni.co/t/how-do-i-automatically-construct-a-filter-url-for-passing-through-fields-to-a-dashboard/71)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [May 21, 2024, 2:51pm UTC](https://community.omni.co/t/how-do-i-automatically-construct-a-filter-url-for-passing-through-fields-to-a-dashboard/71 "2024-05-21T14:51:30Z")
Omni’s filter URL structure is built off of JSON. Because of this, we can use a JSON structure to create the filter parameters in the URL, which are later encoded and passed through to link to a dashboard in Omni. Depen… --- ## [How do I add a count(\*) measure to a view?](https://community.omni.co/t/how-do-i-add-a-count-measure-to-a-view/65)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 15, 2024, 8:46pm UTC](https://community.omni.co/t/how-do-i-add-a-count-measure-to-a-view/65 "2024-05-15T20:46:54Z")
For every view in Omni, we automatically generate a COUNT(\*) measure for you. You’ll find this measure in your field picker, with the name \[View Name\] Count, e.g. Users Count. Since COUNT(\*) doesn’t depend on a parti… --- ## [How do I add a reference line to a chart?](https://community.omni.co/t/how-do-i-add-a-reference-line-to-a-chart/64)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 15, 2024, 8:32pm UTC](https://community.omni.co/t/how-do-i-add-a-reference-line-to-a-chart/64 "2024-05-15T20:32:34Z")
A reference line on a chart is often helpful to contextualize your data. There are two ways to do this in Omni: Native “reference line” option: Open the options for the axis you’d like to plot the reference line on, a… --- ## [Grouped Running Totals](https://community.omni.co/t/grouped-running-totals/63)
**Author:** [@colin](https://community.omni.co/u/colin)\ **Replies:** 0\ **Last updated:** [May 15, 2024, 5:22pm UTC](https://community.omni.co/t/grouped-running-totals/63 "2024-05-15T17:22:39Z")
Running totals are one of the most common reporting use cases, but can be tricky when exploring across multiple dimensions. This article presents a quick pattern for running totals inside sub-groups, with and without pi… --- ## [How do I limit access to columns based on user attributes? (Column-level Permissions)](https://community.omni.co/t/how-do-i-limit-access-to-columns-based-on-user-attributes-column-level-permissions/62)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 10, 2024, 11:35pm UTC](https://community.omni.co/t/how-do-i-limit-access-to-columns-based-on-user-attributes-column-level-permissions/62 "2024-05-10T23:35:56Z")
You may have some fields in a table that contain sensitive information, or you may want to limit them for another reason. In this article, I’ll: Explain how to use Omni to limit access to those fields, and Walk through… --- ## [How do I connect to BigQuery public datasets?](https://community.omni.co/t/how-do-i-connect-to-bigquery-public-datasets/59)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [May 10, 2024, 2:39pm UTC](https://community.omni.co/t/how-do-i-connect-to-bigquery-public-datasets/59 "2024-05-10T14:39:29Z")
The BigQuery public datasets provides a helpful repository of open access datasets to connect to if you don’t have your own data available to connect yet. In Omni we can create connections to and query these datasets if… --- ## [Why won't Omni embed in my local environment?](https://community.omni.co/t/why-wont-omni-embed-in-my-local-environment/58)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 9, 2024, 9:37pm UTC](https://community.omni.co/t/why-wont-omni-embed-in-my-local-environment/58 "2024-05-09T21:37:42Z")
You may have set a restriction on frame ancestors in your Admin panel that are blocking Omni embedded content from rendering locally. If you navigate to Admin \> Embed, you’ll see the Allowed Frame Ancestors section. If … --- ## [Why isn't my view showing up in "All views & fields"?](https://community.omni.co/t/why-isnt-my-view-showing-up-in-all-views-fields/56)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 9, 2024, 8:34pm UTC](https://community.omni.co/t/why-isnt-my-view-showing-up-in-all-views-fields/56 "2024-05-09T20:34:04Z")
How to access the view In “All views & fields”, you can filter for the schema of the view you’re not seeing by hitting the “Schema” button. You can also hit the Settings icon and click the toggle on the bottom to search… --- ## [I want to promote some workbook changes to the shared model. Why do I get the warning: "Incremental changes require a branch"?](https://community.omni.co/t/i-want-to-promote-some-workbook-changes-to-the-shared-model-why-do-i-get-the-warning-incremental-changes-require-a-branch/55)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 7, 2024, 8:09pm UTC](https://community.omni.co/t/i-want-to-promote-some-workbook-changes-to-the-shared-model-why-do-i-get-the-warning-incremental-changes-require-a-branch/55 "2024-05-07T20:09:46Z")
How to resolve the warning Check out our documentation to learn more about branch mode. Once you’ve entered a branch, you can freely promote incremental workbook changes, see how that impacts the shared model, and then … --- ## [Why doesn't my filter show all possible values as suggestions?](https://community.omni.co/t/why-doesnt-my-filter-show-all-possible-values-as-suggestions/54)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 6, 2024, 6:48pm UTC](https://community.omni.co/t/why-doesnt-my-filter-show-all-possible-values-as-suggestions/54 "2024-05-06T18:48:31Z")
Likely Causes If you’re not seeing some values pop up as suggestions on a filter, the two most likely causes are that the suggestions are being filtered due to faceted filtering, or that the value is new and your suggest… --- ## [How do I hide / show the legend on a chart?](https://community.omni.co/t/how-do-i-hide-show-the-legend-on-a-chart/53)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 6, 2024, 5:08pm UTC](https://community.omni.co/t/how-do-i-hide-show-the-legend-on-a-chart/53 "2024-05-06T17:08:24Z")
To hide / show the legend on a chart, open up the chart options, navigate to the Color options, and select Hide/Show in the Legend dropdown: --- ## [How can I unnest my JSON data?](https://community.omni.co/t/how-can-i-unnest-my-json-data/51)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [May 2, 2024, 11:25pm UTC](https://community.omni.co/t/how-can-i-unnest-my-json-data/51 "2024-05-02T23:25:54Z")
When you want to unnest JSON data in Omni, you can scroll to the far right of the cell you want to unnest and click the three dots. You’ll see an option there to “Create Fields From Json” Once you click that, you’ll … --- ## [How do I hide / un-hide a field in my table?](https://community.omni.co/t/how-do-i-hide-un-hide-a-field-in-my-table/50)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [May 1, 2024, 8:52pm UTC](https://community.omni.co/t/how-do-i-hide-un-hide-a-field-in-my-table/50 "2024-05-01T20:52:35Z")
You can hide or un-hide a field in the Table Vis options, by clicking the small dropdown arrow in the field list on the right. You can also hide the field by right clicking on it in the Table Chart view, but to un-hi… --- ## [How do I create a table with a list of dates?](https://community.omni.co/t/how-do-i-create-a-table-with-a-list-of-dates/49)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 30, 2024, 12:53am UTC](https://community.omni.co/t/how-do-i-create-a-table-with-a-list-of-dates/49 "2024-04-30T00:53:45Z")
It’s often helpful to have a comprehensive list of dates to support time-based reporting and analysis: date 2020-01-01 2020-01-02 2020-01-03 2020-01-04 2020-01-05 etc. A common example is analyzing … --- ## [How can I add a filter on just one column / measure? (filtered measure)](https://community.omni.co/t/how-can-i-add-a-filter-on-just-one-column-measure-filtered-measure/31)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [April 5, 2024, 10:05pm UTC](https://community.omni.co/t/how-can-i-add-a-filter-on-just-one-column-measure-filtered-measure/31 "2024-04-05T22:05:04Z")
To apply a filter to one but not all measures in a given query, you can use a filtered measure. There are two easy ways to create a filtered measure from the UI: Create a query with the measure you’d like to filter, … --- ## [How do I get my query to load faster?](https://community.omni.co/t/how-do-i-get-my-query-to-load-faster/47)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 23, 2024, 8:35pm UTC](https://community.omni.co/t/how-do-i-get-my-query-to-load-faster/47 "2024-04-23T20:35:07Z")
Omni is built with performance in mind at every step of the way, including our intelligent cache. At its core, though, Omni is writing SQL down to your database and returning the results. If you’re seeing slowness, the u… --- ## [How do I see the raw SQL that Omni is running in my database?](https://community.omni.co/t/how-do-i-see-the-raw-sql-that-omni-is-running-in-my-database/41)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 18, 2024, 9:27pm UTC](https://community.omni.co/t/how-do-i-see-the-raw-sql-that-omni-is-running-in-my-database/41 "2024-04-18T21:27:06Z")
At its core, Omni is writing SQL down to your database and returning the results. If you’re ever curious to see the SQL, want to reuse it in other ways, or run the SQL directly in your database to check results, you can … [Previous page](https://community.omni.co/latest.md?page=6) [Next page](https://community.omni.co/latest.md?page=8)