# Latest **URL:** https://community.omni.co/latest.md?page=6 [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) **Page:** 7 --- ## [Creating a Month To Date filter](https://community.omni.co/t/creating-a-month-to-date-filter/145)
**Author:** [@liam](https://community.omni.co/u/liam)\ **Replies:** 0\ **Last updated:** [August 27, 2024, 1:26pm UTC](https://community.omni.co/t/creating-a-month-to-date-filter/145 "2024-08-27T13:26:46Z")
You’re using Period-Over-Period to compare this month to last month. However, today is only the 27th of August. So we’re comparing 27 days of August with the whole 31 days of July. Instead, we want to compare the 27 d… --- ## [How do I stop "Comparison Period" changes from breaking my KPI tile comparisons?](https://community.omni.co/t/how-do-i-stop-comparison-period-changes-from-breaking-my-kpi-tile-comparisons/143)
**Author:** [@liam](https://community.omni.co/u/liam)\ **Replies:** 0\ **Last updated:** [August 22, 2024, 1:37pm UTC](https://community.omni.co/t/how-do-i-stop-comparison-period-changes-from-breaking-my-kpi-tile-comparisons/143 "2024-08-22T13:37:56Z")
Out-of-the-box Period over Period and KPI tiles are very popular features in Omni. But sometimes they can break when used together. That’s because the KPI tile comparison is pointing to a particular column name (eg. Prev… --- ## [Joining to an aliased view](https://community.omni.co/t/joining-to-an-aliased-view/139)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [August 13, 2024, 8:31pm UTC](https://community.omni.co/t/joining-to-an-aliased-view/139 "2024-08-13T20:31:01Z")
Sometimes views need to be aliased or duplicated and can be automatically created using joins. In a previous article How to join the same table twice we used aliasing to join the same tables in different ways. In that ca… --- ## [Different types of Drill Downs in Omni](https://community.omni.co/t/different-types-of-drill-downs-in-omni/131)
**Author:** [@liam](https://community.omni.co/u/liam)\ **Replies:** 0\ **Last updated:** [July 30, 2024, 11:24am UTC](https://community.omni.co/t/different-types-of-drill-downs-in-omni/131 "2024-07-30T11:24:03Z")
“Drill downs” are a great way to dynamically interact with your data. What are the different types of drill downs you can set up? Row Level Drilling These are drill fields that you configure on measures. It allows you … --- ## [How do I customize drill fields?](https://community.omni.co/t/how-do-i-customize-drill-fields/75)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [May 29, 2024, 7:35pm UTC](https://community.omni.co/t/how-do-i-customize-drill-fields/75 "2024-05-29T19:35:20Z")
Drilling is a great way to invite users to dig deeper into the data. For example, if you have a measure Order Items Count with a value of 10, drilling lets you see more details on those 10 Order Items. By default, when … --- ## [Creating an override style filter](https://community.omni.co/t/creating-an-override-style-filter/137)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [August 9, 2024, 6:18pm UTC](https://community.omni.co/t/creating-an-override-style-filter/137 "2024-08-09T18:18:40Z")
Occasionally, you may want a query view to have a default filter set from the base table, and then be able to override that filter. We can use mustache templating within the definition of the query view to achieve this. … --- ## [How do I create a quick aggregation / measure ? (sum, count, average)](https://community.omni.co/t/how-do-i-create-a-quick-aggregation-measure-sum-count-average/76)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 0\ **Last updated:** [May 29, 2024, 10:20pm UTC](https://community.omni.co/t/how-do-i-create-a-quick-aggregation-measure-sum-count-average/76 "2024-05-29T22:20:55Z")
Option 1: Hover over the field in the workbook’s field picker and select the three-dot menu that appears and then select Aggregates in the menu. Or right-click on the field in the field picker to see the same menu. O… --- ## [How can I dynamically show YTD/QTD/MTD metrics in the KPI tiles on my dashboard?](https://community.omni.co/t/how-can-i-dynamically-show-ytd-qtd-mtd-metrics-in-the-kpi-tiles-on-my-dashboard/124)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [July 18, 2024, 6:08pm UTC](https://community.omni.co/t/how-can-i-dynamically-show-ytd-qtd-mtd-metrics-in-the-kpi-tiles-on-my-dashboard/124 "2024-07-18T18:08:29Z")
We can do this in Omni by leveraging the Parent Control functionality on the dashboard. Adding a time frame control To begin, we will create a control for our timeframe that we wish to swap between, such as a Created\_A… --- ## [What is "verified" content?](https://community.omni.co/t/what-is-verified-content/81)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 2\ **Last updated:** [July 31, 2024, 5:59pm UTC](https://community.omni.co/t/what-is-verified-content/81 "2024-07-31T17:59:44Z")
The “Verified” tag is a special dashboard label that can only be applied by administrators. It serves as a protected tag that can be used to flag important or actively maintained dashboards and workbooks. Using it is no… --- ## [Why is "display link as url" in the table acting like a relative link?](https://community.omni.co/t/why-is-display-link-as-url-in-the-table-acting-like-a-relative-link/128)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [July 25, 2024, 3:50pm UTC](https://community.omni.co/t/why-is-display-link-as-url-in-the-table-acting-like-a-relative-link/128 "2024-07-25T15:50:08Z")
Omni has a feature which allows URL text in data to be displayed as interactive URLs in tables. This can be enabled in the table options for the field: If you are attempting to use this feature and find that when cli… --- ## [How to filter a visualization to just the top N rows](https://community.omni.co/t/how-to-filter-a-visualization-to-just-the-top-n-rows/127)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [July 24, 2024, 8:35pm UTC](https://community.omni.co/t/how-to-filter-a-visualization-to-just-the-top-n-rows/127 "2024-07-24T20:35:27Z")
Currently the quickest way to do this in Omni is to have a two workbook tab structure that leverages XLookup. We can start with the initial tab of unfiltered data that we want to look at. Then, we can duplicate the tab a… --- ## [How do I annotate one point on a chart? Are there ways to make sparse labels?](https://community.omni.co/t/how-do-i-annotate-one-point-on-a-chart-are-there-ways-to-make-sparse-labels/126)
**Author:** [@colin](https://community.omni.co/u/colin)\ **Replies:** 0\ **Last updated:** [July 23, 2024, 2:50pm UTC](https://community.omni.co/t/how-do-i-annotate-one-point-on-a-chart-are-there-ways-to-make-sparse-labels/126 "2024-07-23T14:50:45Z")
Single Point Annotation Often folks want to add a label to a single point or annotate a handful of events in a graph. This article lays out how to do that with both numerics and strings. It’s very easy to add free text… --- ## [How do I sort / order by more than one field?](https://community.omni.co/t/how-do-i-sort-order-by-more-than-one-field/35)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 9, 2024, 5:45pm UTC](https://community.omni.co/t/how-do-i-sort-order-by-more-than-one-field/35 "2024-04-09T17:45:44Z")
To sort by two or more fields, simply hold shift + click the additional fields you want to sort by: --- ## [Why does my stacked bar chart have horizontal lines in it?](https://community.omni.co/t/why-does-my-stacked-bar-chart-have-horizontal-lines-in-it/122)
**Author:** [@liam](https://community.omni.co/u/liam)\ **Replies:** 0\ **Last updated:** [July 15, 2024, 11:42am UTC](https://community.omni.co/t/why-does-my-stacked-bar-chart-have-horizontal-lines-in-it/122 "2024-07-15T11:42:39Z")
If your bar chart has faint white lines running through it, like in the below screenshot, its because your Results table is at a more fine grain than your visualisation. These lines appear because Omni is technically… --- ## [How do I see Omni as another user? (Impersonation)](https://community.omni.co/t/how-do-i-see-omni-as-another-user-impersonation/119)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [July 3, 2024, 7:26pm UTC](https://community.omni.co/t/how-do-i-see-omni-as-another-user-impersonation/119 "2024-07-03T19:26:47Z")
If you’re an Organization Admin, you can use Omni’s “Impersonate User” feature to view Omni as one of your users. This can help with debugging content permissions, i.e. to understand why a user can’t see a certain dashbo… --- ## [How do I delete a model / database connection?](https://community.omni.co/t/how-do-i-delete-a-model-database-connection/118)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [July 3, 2024, 6:59pm UTC](https://community.omni.co/t/how-do-i-delete-a-model-database-connection/118 "2024-07-03T18:59:09Z")
If you’d like to delete one of your models / database connections, navigate to the model file and go to Model \> Move model to trash. --- ## [Data Analyst @ Ember.co - Up to £50k DOE (Remote, UK)](https://community.omni.co/t/data-analyst-ember-co-up-to-50k-doe-remote-uk/117)
**Author:** [@zzackerie](https://community.omni.co/u/zzackerie)\ **Replies:** 0\ **Last updated:** [June 26, 2024, 4:20pm UTC](https://community.omni.co/t/data-analyst-ember-co-up-to-50k-doe-remote-uk/117 "2024-06-26T16:20:38Z")
Hello there, I’m currently hiring a Data Analyst at ember.co - The all-in-one tax solution for businesses. Our tech stack is: Airbyte dbt BigQuery Omni For this role I’m looking for people with 1-2 years experience … --- ## [How to extend views with SQL blocks when using dynamic schemas](https://community.omni.co/t/how-to-extend-views-with-sql-blocks-when-using-dynamic-schemas/113)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [June 20, 2024, 9:55am UTC](https://community.omni.co/t/how-to-extend-views-with-sql-blocks-when-using-dynamic-schemas/113 "2024-06-20T09:55:44Z")
In my previous post called Working with dynamic schemas, we discussed how to create dynamic schemas in Omni to work with your database when you have a single-tenant database architecture. There might be some views in th… --- ## [Solutions Engineer, Pre-Sales at Omni](https://community.omni.co/t/solutions-engineer-pre-sales-at-omni/108)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [June 17, 2024, 8:57pm UTC](https://community.omni.co/t/solutions-engineer-pre-sales-at-omni/108 "2024-06-17T20:57:25Z")
About the Role As a Pre-Sales Solutions Engineer, you will become an expert in the Omni platform, empowering our customers to do more with their data throughout their lifecycle. You will work with companies across all di… --- ## [Product Expert at Omni](https://community.omni.co/t/product-expert-at-omni/107)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [June 17, 2024, 8:55pm UTC](https://community.omni.co/t/product-expert-at-omni/107 "2024-06-17T20:55:09Z")
Not to co-opt our own community jobs page, but Omni is hiring for data people too! About the Role We are looking for a Product Expert to provide exceptional technical support to our customers. As a Product Expert at Om… --- ## [Why am I getting the error: “WORKBOOK models with changes to topics are restricted”?](https://community.omni.co/t/why-am-i-getting-the-error-workbook-models-with-changes-to-topics-are-restricted/40)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 16, 2024, 9:36pm UTC](https://community.omni.co/t/why-am-i-getting-the-error-workbook-models-with-changes-to-topics-are-restricted/40 "2024-04-16T21:36:36Z")
If you’re seeing this error when viewing a chart on a dashboard, a few things are likely happening: You have Viewer permissions in Omni (permissions docs). The queries on that dashboard are not built off a “predefined … --- ## [Why am I getting the error: “Joins fan out the data without a primary key”?](https://community.omni.co/t/why-am-i-getting-the-error-joins-fan-out-the-data-without-a-primary-key/37)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [April 10, 2024, 11:51pm UTC](https://community.omni.co/t/why-am-i-getting-the-error-joins-fan-out-the-data-without-a-primary-key/37 "2024-04-10T23:51:15Z")
How to fix the error If you define your table’s primary key, that should resolve the error! A table’s primary key is a column that contains a unique identifier per row — usually, it’s an ID column. There are 2 ways to … --- ## [Why am I seeing the error "Can't Display Chart: queries without a topic specified are restricted"](https://community.omni.co/t/why-am-i-seeing-the-error-cant-display-chart-queries-without-a-topic-specified-are-restricted/105)
**Author:** [@anika](https://community.omni.co/u/anika)\ **Replies:** 0\ **Last updated:** [June 17, 2024, 8:13pm UTC](https://community.omni.co/t/why-am-i-seeing-the-error-cant-display-chart-queries-without-a-topic-specified-are-restricted/105 "2024-06-17T20:13:47Z")
For Non-Admins: If you are seeing this error, your user account likely has the Restricted Querier or Viewer role, which restrict access to pre-defined Topics in Omni, and the query in question was built outside of one of… --- ## [When I go to add a filter to a dashboard, why can't I see all of my fields?](https://community.omni.co/t/when-i-go-to-add-a-filter-to-a-dashboard-why-cant-i-see-all-of-my-fields/104)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [June 16, 2024, 9:16pm UTC](https://community.omni.co/t/when-i-go-to-add-a-filter-to-a-dashboard-why-cant-i-see-all-of-my-fields/104 "2024-06-16T21:16:13Z")
When you go to add a filter on a dashboard, you will initially be shown the set of tables and fields in your most commonly used topic. To see fields in other topics or all views and fields, click on the topic selector an… --- ## [What does the error "Failed to execute 'send' on 'XMLHttpRequest': Failed to load 'https://extensions.duckdb.org/v0.10.0/wasm\_eh/icu.duckdb\_extension.wasm'." mean?](https://community.omni.co/t/what-does-the-error-failed-to-execute-send-on-xmlhttprequest-failed-to-load-https-extensions-duckdb-org-v0-10-0-wasm-eh-icu-duckdb-extension-wasm-mean/101)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [June 11, 2024, 3:46am UTC](https://community.omni.co/t/what-does-the-error-failed-to-execute-send-on-xmlhttprequest-failed-to-load-https-extensions-duckdb-org-v0-10-0-wasm-eh-icu-duckdb-extension-wasm-mean/101 "2024-06-11T03:46:19Z")
This error means that DuckDB was unable to load in the browser. This commonly happens when something is blocking DuckDB from loading its extensions. It is recommended to check the network that you’re on to determine i… --- ## [Why isn't my dimension aggregating? Why isn't my number a sum/average/median/etc.?](https://community.omni.co/t/why-isnt-my-dimension-aggregating-why-isnt-my-number-a-sum-average-median-etc/96)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 11:21pm UTC](https://community.omni.co/t/why-isnt-my-dimension-aggregating-why-isnt-my-number-a-sum-average-median-etc/96 "2024-06-03T23:21:33Z")
Dimensions are attributes that describe a given row of data, and measures aggregate dimensions. In Omni’s field picker, dimensions are listed in black while measures are listed in green. If you’re selecting a field e… --- ## [How do I control caching policies?](https://community.omni.co/t/how-do-i-control-caching-policies/95)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 11:01pm UTC](https://community.omni.co/t/how-do-i-control-caching-policies/95 "2024-06-03T23:01:16Z")
Query results are cached for 6 hours by default, but this can be configured at the model and/or topic level using the cache parameters outlined here. --- ## [What is the square icon that's not a date/number/string/boolean in the field picker?](https://community.omni.co/t/what-is-the-square-icon-thats-not-a-date-number-string-boolean-in-the-field-picker/94)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 10:59pm UTC](https://community.omni.co/t/what-is-the-square-icon-thats-not-a-date-number-string-boolean-in-the-field-picker/94 "2024-06-03T22:59:07Z")
If you see the square icon next to a field in the field picker, it means that Omni doesn’t recognize the data type of that field. You’ll still be able to select that field and view it in the table, but to interact wi… --- ## [Is there a quick way to remove all the fields from the table?](https://community.omni.co/t/is-there-a-quick-way-to-remove-all-the-fields-from-the-table/93)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:16pm UTC](https://community.omni.co/t/is-there-a-quick-way-to-remove-all-the-fields-from-the-table/93 "2024-06-03T19:16:17Z")
Yup! Open the “Tab” menu from the header, and you’ll see options to clear query (both fields and filters), clear fields, and clear filters. Check out the keyboard shortcuts too for easier access :raised\_hands: --- ## [Can you query the data unsorted?](https://community.omni.co/t/can-you-query-the-data-unsorted/92)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:13pm UTC](https://community.omni.co/t/can-you-query-the-data-unsorted/92 "2024-06-03T19:13:43Z")
Yup! Simply right-click the field name in the column header and hit “No Sort”. Omni often sorts by default to help improve readability, but you can always un-sort your data. [Previous page](https://community.omni.co/latest.md?page=5) [Next page](https://community.omni.co/latest.md?page=7)