**Author:** [@russ](https://community.omni.co/u/russ)\
**Replies:** 0\
**Last updated:** [February 10, 2025, 1:33pm UTC](https://community.omni.co/t/link-to-sections-on-an-omni-dashboard/230 "2025-02-10T13:33:57Z")
You might have wondered if you can link to sections on an Omni dashboard, half way or 2/3s of the way down the page or anywhere within. Yes you can! This article will show how you can use markdown and text tiles, and a…
---
## [Leveraging Different database user roles for users within Omni](https://community.omni.co/t/leveraging-different-database-user-roles-for-users-within-omni/229)
**Author:** [@jack](https://community.omni.co/u/jack)\
**Replies:** 0\
**Last updated:** [February 8, 2025, 3:07am UTC](https://community.omni.co/t/leveraging-different-database-user-roles-for-users-within-omni/229 "2025-02-08T03:07:01Z")
Occasionally, administrators prefer to manage the access to underlying data within the database directly for groups of users. This is typically done by creating user roles, which then map to certain sets of users at the …
---
## [Building a dynamically updating sidebar for iframed dashboards](https://community.omni.co/t/building-a-dynamically-updating-sidebar-for-iframed-dashboards/227)
**Author:** [@jack](https://community.omni.co/u/jack)\
**Replies:** 0\
**Last updated:** [February 5, 2025, 9:25pm UTC](https://community.omni.co/t/building-a-dynamically-updating-sidebar-for-iframed-dashboards/227 "2025-02-05T21:25:40Z")
If you want to build a dynamic nav bar that updates to include new dashboards in a folder as they’re created for easy expansion of your embedded dashboards, this is the tutorial for you. We can achieve this with o…
---
## [Custom HTML Tables with Markdown Viz](https://community.omni.co/t/custom-html-tables-with-markdown-viz/226)
**Author:** [@russ](https://community.omni.co/u/russ)\
**Replies:** 0\
**Last updated:** [February 1, 2025, 10:03pm UTC](https://community.omni.co/t/custom-html-tables-with-markdown-viz/226 "2025-02-01T22:03:49Z")
Turn this: Into this: (with full customization) Step 1) Select the Markdown Viz Step 2) Apply custom HTML Table Code and customize \ h3 { margin-block-start: 0; } .comp-table { width: 100%; b…
---
## [Tricks for filtering dimensions that you're pivoting on](https://community.omni.co/t/tricks-for-filtering-dimensions-that-youre-pivoting-on/100)
**Author:** [@conor](https://community.omni.co/u/conor)\
**Replies:** 1\
**Last updated:** [February 1, 2025, 9:06pm UTC](https://community.omni.co/t/tricks-for-filtering-dimensions-that-youre-pivoting-on/100 "2025-02-01T21:06:07Z")
Here’s a neat workflow to get the limit your pivot to the top 20 values. In this example I’ll work with eCommerce product data and use Omni’s filter by query feature. First off, we’ll make a tab called Top 20 Products …
---
## [Linking to Omni from SAML Apps](https://community.omni.co/t/linking-to-omni-from-saml-apps/224)
**Author:** [@Jiro](https://community.omni.co/u/Jiro)\
**Replies:** 0\
**Last updated:** [January 31, 2025, 9:48pm UTC](https://community.omni.co/t/linking-to-omni-from-saml-apps/224 "2025-01-31T21:48:28Z")
It’s pretty common for companies using a SAML app like Okta to have users expect to access the company’s apps from the SAML app interface (as opposed to navigating to the app’s url directly), but at the time of this writ…
---
## [Please share the resource](https://community.omni.co/t/please-share-the-resource/214)
**Author:** [@shekhar](https://community.omni.co/u/shekhar)\
**Replies:** 3\
**Last updated:** [January 27, 2025, 9:06pm UTC](https://community.omni.co/t/please-share-the-resource/214 "2025-01-27T21:06:21Z")
I am new to omni , can you please share the resource so that I can learn faster
---
## [Filtered Measures with Dynamic Timeframe Swappers in the UI](https://community.omni.co/t/filtered-measures-with-dynamic-timeframe-swappers-in-the-ui/219)
**Author:** [@kylee](https://community.omni.co/u/kylee)\
**Replies:** 0\
**Last updated:** [January 24, 2025, 4:50am UTC](https://community.omni.co/t/filtered-measures-with-dynamic-timeframe-swappers-in-the-ui/219 "2025-01-24T04:50:34Z")
There are many use cases where you may want multiple measures included in a single query but with different date fields applied to them. For instance say we want to find the number of created opportunities and number of …
---
## [Sort Charts with an X axis by a Measure Value instead of Dimension](https://community.omni.co/t/sort-charts-with-an-x-axis-by-a-measure-value-instead-of-dimension/208)
**Author:** [@Jiro](https://community.omni.co/u/Jiro)\
**Replies:** 2\
**Last updated:** [January 7, 2025, 6:03am UTC](https://community.omni.co/t/sort-charts-with-an-x-axis-by-a-measure-value-instead-of-dimension/208 "2025-01-07T06:03:44Z")
Whenever you have a viz with an X axis, the sort of that axis will always be based on the x axis dimension regardless of how the results are ordered by a measure. However, in some cases you may want to sort the results b…
---
## [Tips for dynamic styling in markdown visualizations](https://community.omni.co/t/tips-for-dynamic-styling-in-markdown-visualizations/170)
**Author:** [@sarah](https://community.omni.co/u/sarah)\
**Replies:** 1\
**Last updated:** [January 2, 2025, 7:16pm UTC](https://community.omni.co/t/tips-for-dynamic-styling-in-markdown-visualizations/170 "2025-01-02T19:16:20Z")
Omni’s markdown visualizations are incredibly flexible and powerful. You can reference query data and valuesand insert them directly in your markdown code. And if you’re comfortable writing it, you can use HTML and CSS t…
---
## [Drilldown working in workbook but no results in dashboard](https://community.omni.co/t/drilldown-working-in-workbook-but-no-results-in-dashboard/206)
**Author:** [@Elliot](https://community.omni.co/u/Elliot)\
**Replies:** 1\
**Last updated:** [December 21, 2024, 8:09pm UTC](https://community.omni.co/t/drilldown-working-in-workbook-but-no-results-in-dashboard/206 "2024-12-21T20:09:43Z")
When I am in the workbook, my drilldown fields are all working correctly. I liked the process for modifying the available fields by editing it, too. But, when I go to my dashboard and attempt a drilldown, I am getting “…
---
## [Anyone got examples of pretty boards?](https://community.omni.co/t/anyone-got-examples-of-pretty-boards/205)
**Author:** [@Elliot](https://community.omni.co/u/Elliot)\
**Replies:** 0\
**Last updated:** [December 21, 2024, 6:14pm UTC](https://community.omni.co/t/anyone-got-examples-of-pretty-boards/205 "2024-12-21T18:14:32Z")
We’re in the process of developing several dashboards and would love to see examples of what others have been creating. Are there any particularly creative designs out there? Maybe dashboards that combine KPI tiles with…
---
## [Filtering on hidden XLOOKUP queries in a dashboard](https://community.omni.co/t/filtering-on-hidden-xlookup-queries-in-a-dashboard/203)
**Author:** [@James](https://community.omni.co/u/James)\
**Replies:** 0\
**Last updated:** [December 17, 2024, 12:25am UTC](https://community.omni.co/t/filtering-on-hidden-xlookup-queries-in-a-dashboard/203 "2024-12-17T00:25:46Z")
I want to share an example of a case where you may want to use an XLOOKUP and filter on a hidden query tile in a dashboard. This can be useful when you have build multiple queries in a workbook that rely on each other, b…
---
## [Rolling Fact Table With Dynamic Look-back Window](https://community.omni.co/t/rolling-fact-table-with-dynamic-look-back-window/201)
**Author:** [@colin](https://community.omni.co/u/colin)\
**Replies:** 0\
**Last updated:** [December 12, 2024, 5:21pm UTC](https://community.omni.co/t/rolling-fact-table-with-dynamic-look-back-window/201 "2024-12-12T17:21:38Z")
Here’s a quick pattern for building a dynamic fact table with some parameterization. The use case would be trying to understand spend over a 7, 14, 28 day look-back window, and potentially even cohort against those user…
---
## [Creating a tabbed experience in an embedded dashboard](https://community.omni.co/t/creating-a-tabbed-experience-in-an-embedded-dashboard/132)
**Author:** [@jack](https://community.omni.co/u/jack)\
**Replies:** 2\
**Last updated:** [December 11, 2024, 10:54pm UTC](https://community.omni.co/t/creating-a-tabbed-experience-in-an-embedded-dashboard/132 "2024-12-11T22:54:56Z")
While tabbed dashboards are on the way, there are currently a few creative solutions to provide users a tabbed experience or navigation across dashboards within the iframe. The two main mechanisms for this are linking a…
---
## [How to Create a Measure That is Blank for Certain Levels of Aggregation](https://community.omni.co/t/how-to-create-a-measure-that-is-blank-for-certain-levels-of-aggregation/194)
**Author:** [@conor](https://community.omni.co/u/conor)\
**Replies:** 0\
**Last updated:** [December 3, 2024, 10:59am UTC](https://community.omni.co/t/how-to-create-a-measure-that-is-blank-for-certain-levels-of-aggregation/194 "2024-12-03T10:59:08Z")
With great power comes great responsibility Creating dynamic dashboards that adapt to different needs can provide tremendous flexibility. By incorporating features like a timeframe selector, field control, or templated f…
---
## [How do I filter on a long list of emails or IDs](https://community.omni.co/t/how-do-i-filter-on-a-long-list-of-emails-or-ids/187)
**Author:** [@jack](https://community.omni.co/u/jack)\
**Replies:** 0\
**Last updated:** [November 12, 2024, 6:45pm UTC](https://community.omni.co/t/how-do-i-filter-on-a-long-list-of-emails-or-ids/187 "2024-11-12T18:45:20Z")
The three main options here will be to (1) define a field where it creates a true/false flag that filters on those 1200, (2) use the filter by query functionality or (3) to drop them into the SQL statement directly. For…
---
## [Set user permissions using the API](https://community.omni.co/t/set-user-permissions-using-the-api/186)
**Author:** [@Amihai](https://community.omni.co/u/Amihai)\
**Replies:** 3\
**Last updated:** [November 12, 2024, 3:47pm UTC](https://community.omni.co/t/set-user-permissions-using-the-api/186 "2024-11-12T15:47:29Z")
Hi, I’m wondering if it’s possible to manage user permissions through Omni’s API. Specifically, I’d like to know if I can: Set a new user as an Admin or assign different roles upon joining. Adjust permissions (e.g., re…
---
## [Looker Liquid style](https://community.omni.co/t/looker-liquid-style/164)
**Author:** [@Ben](https://community.omni.co/u/Ben)\
**Replies:** 2\
**Last updated:** [October 31, 2024, 11:59am UTC](https://community.omni.co/t/looker-liquid-style/164 "2024-10-31T11:59:30Z")
Hi How do I solve the problem in Omni that a measure is dependent on the dimensions selected? So as an example: The customer has selected the delivery month in his analysis. Then the correct math is: Value / number o…
---
## [How do I prevent my aggregations from counting duplicates when my query fans out?](https://community.omni.co/t/how-do-i-prevent-my-aggregations-from-counting-duplicates-when-my-query-fans-out/172)
**Author:** [@liam](https://community.omni.co/u/liam)\
**Replies:** 0\
**Last updated:** [October 24, 2024, 10:22am UTC](https://community.omni.co/t/how-do-i-prevent-my-aggregations-from-counting-duplicates-when-my-query-fans-out/172 "2024-10-24T10:22:09Z")
Firstly, let’s talk about why we need to consider fan-out. Let’s say we have the following table of orders If we want to get the sum of price on our orders, we simply do a sum of each of the values select SUM(price)…
---
## [How can I dynamically average over pivots](https://community.omni.co/t/how-can-i-dynamically-average-over-pivots/162)
**Author:** [@conor](https://community.omni.co/u/conor)\
**Replies:** 0\
**Last updated:** [October 10, 2024, 10:06am UTC](https://community.omni.co/t/how-can-i-dynamically-average-over-pivots/162 "2024-10-10T10:06:36Z")
Often you might want to pivot by a timeframe and get an average on the measure over the groupings within the timeframes. For example you might want to get the weekly active users for the last 4 weeks. Then average this v…
---
## [Can I point a single filter to different fields on a dashboard?](https://community.omni.co/t/can-i-point-a-single-filter-to-different-fields-on-a-dashboard/144)
**Author:** [@liam](https://community.omni.co/u/liam)\
**Replies:** 2\
**Last updated:** [October 3, 2024, 12:49pm UTC](https://community.omni.co/t/can-i-point-a-single-filter-to-different-fields-on-a-dashboard/144 "2024-10-03T12:49:14Z")
Let’s say I have multiple dates on my dashboard (eg. User Created At date and Order date). I don’t want to have to set up two date filters on my dashboard to point to the different date fields. I just want a single date …
---
## [Join tables in Omni Analytics](https://community.omni.co/t/join-tables-in-omni-analytics/159)
**Author:** [@Tomer\_vision.bi](https://community.omni.co/u/Tomer_vision.bi)\
**Replies:** 1\
**Last updated:** [October 1, 2024, 10:13am UTC](https://community.omni.co/t/join-tables-in-omni-analytics/159 "2024-10-01T10:13:31Z")
Hi Omnis, I tried to do join between two tables, the join needs 3 keys in order to be unique, but each time the option is only join by 1 key. How I can solve this issue?
---
## [Map Longtitude / Latitude](https://community.omni.co/t/map-longtitude-latitude/158)
**Author:** [@Tomer\_vision.bi](https://community.omni.co/u/Tomer_vision.bi)\
**Replies:** 2\
**Last updated:** [October 1, 2024, 6:37am UTC](https://community.omni.co/t/map-longtitude-latitude/158 "2024-10-01T06:37:26Z")
Hey, I have data which includes state/province ,country ,region etc. I’m trying to build my state - sales map but it asking me to put the Longitude / Latitude. I don’t have those columns in my row data. (I thought it…
---
## [Data Analyst @ Fora Travel](https://community.omni.co/t/data-analyst-fora-travel/110)
**Author:** [@dorian](https://community.omni.co/u/dorian)\
**Replies:** 1\
**Last updated:** [September 27, 2024, 9:12pm UTC](https://community.omni.co/t/data-analyst-fora-travel/110 "2024-09-27T21:12:03Z")
I’m hiring at Fora Travel for the first Data Analyst on our team. You’ll get to help shape our use of Omni and data more broadly across the org. This role is great for an early-career data person looking to have an impac…
---
## [How do I add a row with column totals to my query?](https://community.omni.co/t/how-do-i-add-a-row-with-column-totals-to-my-query/86)
**Author:** [@conner](https://community.omni.co/u/conner)\
**Replies:** 1\
**Last updated:** [September 23, 2024, 5:15pm UTC](https://community.omni.co/t/how-do-i-add-a-row-with-column-totals-to-my-query/86 "2024-09-23T17:15:20Z")
Row totals and column totals are available in the options menu in the Results tab (rather than the Chart tab). If your row/column totals don’t match the values you were expecting, check out this article to trouble…
---
## [Binning & Regrouping Aggregates / Creating a "histogram"](https://community.omni.co/t/binning-regrouping-aggregates-creating-a-histogram/152)
**Author:** [@conner](https://community.omni.co/u/conner)\
**Replies:** 0\
**Last updated:** [September 16, 2024, 7:42pm UTC](https://community.omni.co/t/binning-regrouping-aggregates-creating-a-histogram/152 "2024-09-16T19:42:56Z")
A common workflow is taking a table, aggregating it, and then analyzing patterns in the aggregation. For example: take an orders table, aggregate it to count of orders per user, and then understand % of users per count o…
---
## [Merging Queries](https://community.omni.co/t/merging-queries/151)
**Author:** [@conner](https://community.omni.co/u/conner)\
**Replies:** 0\
**Last updated:** [September 16, 2024, 7:20pm UTC](https://community.omni.co/t/merging-queries/151 "2024-09-16T19:20:40Z")
TL;DR: How to combine queries across tables on a foreign key Sometimes the join between two tables is easy, like joining orders to products on product\_id. But sometimes it’s more complex. For example, let’s say you wan…
---
## [How can I share logic across multiple models? (Hub and spoke)](https://community.omni.co/t/how-can-i-share-logic-across-multiple-models-hub-and-spoke/150)
**Author:** [@liam](https://community.omni.co/u/liam)\
**Replies:** 0\
**Last updated:** [September 13, 2024, 1:03pm UTC](https://community.omni.co/t/how-can-i-share-logic-across-multiple-models-hub-and-spoke/150 "2024-09-13T13:03:57Z")
UPDATE: We now support “extension models”. These are often a cleaner way to share logic across departments. Docs coming soon Omni allows you to create templated models, which can be shared across different models in you…
---
## [Interdependent Filters on a Dashboard](https://community.omni.co/t/interdependent-filters-on-a-dashboard/148)
**Author:** [@ashima\_zepto](https://community.omni.co/u/ashima_zepto)\
**Replies:** 3\
**Last updated:** [September 1, 2024, 10:32pm UTC](https://community.omni.co/t/interdependent-filters-on-a-dashboard/148 "2024-09-01T22:32:26Z")
Is there a way to make filters inter dependent? So if I choose a value in filter 1, the options in filter 2 should be updated accordingly and show values relevant only to filter 1
[Previous page](https://community.omni.co/latest.md?page=4)
[Next page](https://community.omni.co/latest.md?page=6)