# Latest **URL:** https://community.omni.co/latest.md?page=3 [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) **Page:** 4 --- ## [How order\_by\_field parameter works?](https://community.omni.co/t/how-order-by-field-parameter-works/394)
**Author:** [@AdrianaVela](https://community.omni.co/u/AdrianaVela)\ **Replies:** 4\ **Last updated:** [September 26, 2025, 4:05pm UTC](https://community.omni.co/t/how-order-by-field-parameter-works/394 "2025-09-26T16:05:57Z")
Hello, Im using order\_by\_field parameter with colours parameter in a dimension. This dimension has age groups values (string) and I want to order by 18 - 25, 26 - 30, 31 -35… So I have created a new dimension using a cas… --- ## [Configuring model level localization](https://community.omni.co/t/configuring-model-level-localization/345)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 2\ **Last updated:** [September 17, 2025, 7:36pm UTC](https://community.omni.co/t/configuring-model-level-localization/345 "2025-09-17T19:36:19Z")
Model Level Localization There are many components to localization in Omni, but a core component is localizing the field labels, descriptions, and other parameters that exist in your database to be more UI friendly for t… --- ## [Generating dbt exposures using OMNI APIs](https://community.omni.co/t/generating-dbt-exposures-using-omni-apis/392)
**Author:** [@samp](https://community.omni.co/u/samp)\ **Replies:** 1\ **Last updated:** [September 17, 2025, 2:17am UTC](https://community.omni.co/t/generating-dbt-exposures-using-omni-apis/392 "2025-09-17T02:17:51Z")
Here’s a how-to from the Zello team, hope it helps! We built a pipeline in Pipedream that consumes Omni’s APIs and automatically outputs dbt exposures for dashboards. Step 1. Dashboards and Queries Call /api/v1/docum… --- ## [Extended views for joining the same table with different logic](https://community.omni.co/t/extended-views-for-joining-the-same-table-with-different-logic/319)
**Author:** [@kylee](https://community.omni.co/u/kylee)\ **Replies:** 1\ **Last updated:** [September 10, 2025, 10:28pm UTC](https://community.omni.co/t/extended-views-for-joining-the-same-table-with-different-logic/319 "2025-09-10T22:28:53Z")
When building data models in Omni, there are times when you’ll want to join the same view more than once – like joining the users table twice, once as sellers and once as buyers. This is covered in a previous article, wh… --- ## [\[LOD\] How many profitable days did we have each month?](https://community.omni.co/t/lod-how-many-profitable-days-did-we-have-each-month/390)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [September 8, 2025, 11:11pm UTC](https://community.omni.co/t/lod-how-many-profitable-days-did-we-have-each-month/390 "2025-09-08T23:11:47Z")
Business performance analysis typically focuses heavily on sales metrics. This analysis typically examines performance across different periods, geographies, segmentations, and compares leaders and laggards in those cate… --- ## [\[LOD\] Do longer tenured customers make a larger contribution to sales](https://community.omni.co/t/lod-do-longer-tenured-customers-make-a-larger-contribution-to-sales/389)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [September 8, 2025, 9:27am UTC](https://community.omni.co/t/lod-do-longer-tenured-customers-make-a-larger-contribution-to-sales/389 "2025-09-08T09:27:14Z")
Business Question For cohort analysis, people often ask about their business is “do longer tenured customers make a larger contribution to sales?” We can group each user by their first order year and breakdown sales eac… --- ## [How do I download a Topic's related data?](https://community.omni.co/t/how-do-i-download-a-topics-related-data/388)
**Author:** [@litox](https://community.omni.co/u/litox)\ **Replies:** 3\ **Last updated:** [September 3, 2025, 7:08pm UTC](https://community.omni.co/t/how-do-i-download-a-topics-related-data/388 "2025-09-03T19:08:27Z")
Hello community :waving\_hand: I have a client who puts a lot of effort into getting clean tables with useful logic into Omni. For an integration with an external tool, I’d like to be able to programmatically ingest/ret… --- ## [Using Level of Detail functions for Cohorting Analysis](https://community.omni.co/t/using-level-of-detail-functions-for-cohorting-analysis/368)
**Author:** [@kylee](https://community.omni.co/u/kylee)\ **Replies:** 2\ **Last updated:** [September 2, 2025, 11:36pm UTC](https://community.omni.co/t/using-level-of-detail-functions-for-cohorting-analysis/368 "2025-09-02T23:36:56Z")
Cohorting Analysis is a common analytical pattern we see our customers using at Omni. In our documentation page, we have an example of this pattern in practice. In this example, we create a cohort analysis based at cohor… --- ## [How to Create a Dynamic Reference Line](https://community.omni.co/t/how-to-create-a-dynamic-reference-line/385)
**Author:** [@samp](https://community.omni.co/u/samp)\ **Replies:** 0\ **Last updated:** [August 13, 2025, 7:06pm UTC](https://community.omni.co/t/how-to-create-a-dynamic-reference-line/385 "2025-08-13T19:06:46Z")
Overview Omni doesn’t currently offer a built-in “dynamic reference line” feature, but you can achieve the same effect with a simple workaround. This approach lets you set a margin target and switch between different tar… --- ## [Rank sub category using Calcs to get things like Top 10 subcategories](https://community.omni.co/t/rank-sub-category-using-calcs-to-get-things-like-top-10-subcategories/316)
**Author:** [@Jiro](https://community.omni.co/u/Jiro)\ **Replies:** 0\ **Last updated:** [April 28, 2025, 7:32pm UTC](https://community.omni.co/t/rank-sub-category-using-calcs-to-get-things-like-top-10-subcategories/316 "2025-04-28T19:32:21Z")
This pattern is designed to give you a quick ranking so you can isolate the top X of a subcategory in your workbook but also shows how you can promote this logic to be reusable and more scalable in the model layer. Setu… --- ## [How to work on dbt models in Omni that aren't yet written into production](https://community.omni.co/t/how-to-work-on-dbt-models-in-omni-that-arent-yet-written-into-production/380)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [August 11, 2025, 8:22pm UTC](https://community.omni.co/t/how-to-work-on-dbt-models-in-omni-that-arent-yet-written-into-production/380 "2025-08-11T20:22:47Z")
Create a new dbt model and work on it in an Omni branch Firstly, the model must be built within your development environment. Run the dbt build command, using your development environment Secondly, the code for the db… --- ## [Translating Complex Looker Joins with COALESCE to Omni](https://community.omni.co/t/translating-complex-looker-joins-with-coalesce-to-omni/372)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [July 31, 2025, 11:26am UTC](https://community.omni.co/t/translating-complex-looker-joins-with-coalesce-to-omni/372 "2025-07-31T11:26:24Z")
Translating Complex Looker Joins with COALESCE to Omni When migrating from Looker to Omni, one of the more challenging scenarios involves translating complex join patterns that use COALESCE in the join conditions. This a… --- ## [I have tables in my DWH that have different levels of aggregation. How can I use Aggregate Awareness to query dynamically?](https://community.omni.co/t/i-have-tables-in-my-dwh-that-have-different-levels-of-aggregation-how-can-i-use-aggregate-awareness-to-query-dynamically/123)
**Author:** [@liam](https://community.omni.co/u/liam)\ **Replies:** 0\ **Last updated:** [July 15, 2024, 1:41pm UTC](https://community.omni.co/t/i-have-tables-in-my-dwh-that-have-different-levels-of-aggregation-how-can-i-use-aggregate-awareness-to-query-dynamically/123 "2024-07-15T13:41:59Z")
Let’s say you have a large table of orders for your ecommerce store. Sometimes you need to access the granular level of detail of these orders, eg. to see details about orders that are currently out for Delivery Other … --- ## [Two Visualization Builds in 10 minutes: Repeating square fill charts - 2 Ways!](https://community.omni.co/t/two-visualization-builds-in-10-minutes-repeating-square-fill-charts-2-ways/370)
**Author:** [@Becca\_Omni](https://community.omni.co/u/Becca_Omni)\ **Replies:** 0\ **Last updated:** [July 28, 2025, 7:39pm UTC](https://community.omni.co/t/two-visualization-builds-in-10-minutes-repeating-square-fill-charts-2-ways/370 "2025-07-28T19:39:36Z")
Omni has some great markdown examples in our docs and customers are often excited to see all the power and flexibility possible! I had a customer recently want to re-create the Repeating square fill charts example, but g… --- ## [Querying a results set ("Save as query view")](https://community.omni.co/t/querying-a-results-set-save-as-query-view/359)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [July 14, 2025, 10:50pm UTC](https://community.omni.co/t/querying-a-results-set-save-as-query-view/359 "2025-07-14T22:50:40Z")
Ever wanted to “query a query”? In other words, take some results and use that as the basis for another query? Omni’s “Save as query view” feature is built for exactly that :smiley: Once you save your results as a query… --- ## [🚀 Quick way to learn Omni embedding? Deploy this demo in 5 minutes](https://community.omni.co/t/quick-way-to-learn-omni-embedding-deploy-this-demo-in-5-minutes/365)
**Author:** [@Jamiefry](https://community.omni.co/u/Jamiefry)\ **Replies:** 0\ **Last updated:** [July 17, 2025, 7:47pm UTC](https://community.omni.co/t/quick-way-to-learn-omni-embedding-deploy-this-demo-in-5-minutes/365 "2025-07-17T19:47:26Z")
A complete TypeScript demo app that shows exactly how Omni’s embedding SDK works in practice - because hands-on learning beats reading docs every time. Why use it :white\_check\_mark: Demos different SDK endpoints (dash… --- ## [How do I make a dashboard query dynamic?](https://community.omni.co/t/how-do-i-make-a-dashboard-query-dynamic/361)
**Author:** [@dom](https://community.omni.co/u/dom)\ **Replies:** 2\ **Last updated:** [July 16, 2025, 9:43pm UTC](https://community.omni.co/t/how-do-i-make-a-dashboard-query-dynamic/361 "2025-07-16T21:43:29Z")
Hi team, I can see from your docs how to reference filter values in Markdown sections of dashboards: However I want to make the queries themselves dynamic, i.e. be able to reference them in SQL. How can I do that? --- ## [Visualization Build in Minutes: Scatter Plot with Color Quadrants](https://community.omni.co/t/visualization-build-in-minutes-scatter-plot-with-color-quadrants/362)
**Author:** [@Becca\_Omni](https://community.omni.co/u/Becca_Omni)\ **Replies:** 0\ **Last updated:** [July 15, 2025, 9:28pm UTC](https://community.omni.co/t/visualization-build-in-minutes-scatter-plot-with-color-quadrants/362 "2025-07-15T21:28:54Z")
If you’re wanting to easily show where data is existing within colorful, equal quadrants that are spaced based on the underlying data - below is a straightforward way to build this out of the box with Omni’s powerful vis… --- ## [Visualization Build in Minutes: Show Different Color for Data Points Over a Specific Threshold](https://community.omni.co/t/visualization-build-in-minutes-show-different-color-for-data-points-over-a-specific-threshold/358)
**Author:** [@Becca\_Omni](https://community.omni.co/u/Becca_Omni)\ **Replies:** 0\ **Last updated:** [July 14, 2025, 8:19pm UTC](https://community.omni.co/t/visualization-build-in-minutes-show-different-color-for-data-points-over-a-specific-threshold/358 "2025-07-14T20:19:00Z")
If you’re wanting to make data standout with differing colors when it is over a certain threshold to alert your dashboard viewers to certain important pieces of information, you can easily do this with the visualization … --- ## [Improving AI Answer Quality: A Practical Guide](https://community.omni.co/t/improving-ai-answer-quality-a-practical-guide/356)
**Author:** [@arielle](https://community.omni.co/u/arielle)\ **Replies:** 0\ **Last updated:** [July 10, 2025, 5:24pm UTC](https://community.omni.co/t/improving-ai-answer-quality-a-practical-guide/356 "2025-07-10T17:24:58Z")
Improving AI Answer Quality: A Practical Guide Making your datasets AI-ready doesn’t need to be complicated. In fact, most of the steps are things you’re probably already doing to make data understandable to humans - now… --- ## [Build a Custom NBA Stats Dashboard in Omni in 20 minutes!](https://community.omni.co/t/build-a-custom-nba-stats-dashboard-in-omni-in-20-minutes/354)
**Author:** [@Becca\_Omni](https://community.omni.co/u/Becca_Omni)\ **Replies:** 0\ **Last updated:** [July 9, 2025, 11:41pm UTC](https://community.omni.co/t/build-a-custom-nba-stats-dashboard-in-omni-in-20-minutes/354 "2025-07-09T23:41:20Z")
We often get questions from our customers to see step-by-step building using the built-in visualization power of Omni, especially when customers see the awesome demo dashboards that the Sales Engineering team has built. … --- ## [Daily Retention Metrics for Cohort Analysis](https://community.omni.co/t/daily-retention-metrics-for-cohort-analysis/352)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [July 7, 2025, 9:41pm UTC](https://community.omni.co/t/daily-retention-metrics-for-cohort-analysis/352 "2025-07-07T21:41:01Z")
Overview Daily retention metrics are crucial for understanding user engagement and product stickiness. These are often used in Saas products, gaming and eLearning. This guide demonstrates how to build a comprehensive ret… --- ## [Bulk group management](https://community.omni.co/t/bulk-group-management/305)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 3\ **Last updated:** [July 3, 2025, 8:17am UTC](https://community.omni.co/t/bulk-group-management/305 "2025-07-03T08:17:18Z")
The best approach to managing users and their groups is to derive them from an SSO system, and Omni supports many systems through its SAML and SCIM such as Okta, Active Directory and more. But sometimes you have a need … --- ## [Do I need to manually configure embed users in Omni?](https://community.omni.co/t/do-i-need-to-manually-configure-embed-users-in-omni/348)
**Author:** [@adrienb](https://community.omni.co/u/adrienb)\ **Replies:** 0\ **Last updated:** [June 25, 2025, 8:53pm UTC](https://community.omni.co/t/do-i-need-to-manually-configure-embed-users-in-omni/348 "2025-06-25T20:53:22Z")
Thankfully you don’t, since doing so would become unmanageable at scale! In short, new users are created when someone logs in for the first time. Specifically, it depends on the embedding type: In the standard SSO embe… --- ## [Embedding Custom Fields (EAV / Key-value / json custom fields per customer)](https://community.omni.co/t/embedding-custom-fields-eav-key-value-json-custom-fields-per-customer/339)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 0\ **Last updated:** [June 18, 2025, 1:58am UTC](https://community.omni.co/t/embedding-custom-fields-eav-key-value-json-custom-fields-per-customer/339 "2025-06-18T01:58:39Z")
I’m very happy to show how Omni is able to easily handle one of the most challenging scenarios in analytics: embedding custom fields. In this guide we’ll cover the problem statement, a brief overview of the conceptual so… --- ## [Why do my timestamps show as dates I download and open in excel or sheets?](https://community.omni.co/t/why-do-my-timestamps-show-as-dates-i-download-and-open-in-excel-or-sheets/346)
**Author:** [@Jiro](https://community.omni.co/u/Jiro)\ **Replies:** 0\ **Last updated:** [June 19, 2025, 5:44pm UTC](https://community.omni.co/t/why-do-my-timestamps-show-as-dates-i-download-and-open-in-excel-or-sheets/346 "2025-06-19T17:44:39Z")
Tools like sheets and excel will infer datatypes and in some cases apply formatting automatically. You can see that the actual timestamp value is there, it’s just being truncated and formatted as standard date by def… --- ## [🚀 Open Sourced: Bulk User & Group Management CLI for Omni.co (Beta)](https://community.omni.co/t/open-sourced-bulk-user-group-management-cli-for-omni-co-beta/342)
**Author:** [@Jamiefry](https://community.omni.co/u/Jamiefry)\ **Replies:** 0\ **Last updated:** [June 18, 2025, 9:39am UTC](https://community.omni.co/t/open-sourced-bulk-user-group-management-cli-for-omni-co-beta/342 "2025-06-18T09:39:15Z")
I’ve just open sourced omni-user-manager, a Python CLI package that provides easy-to-use wrappers around the Omni.co APIs for user and group management. Key features: Comprehensive sync operations - The sync command o… --- ## [Invalidate Omni's cache with dbt or SQL](https://community.omni.co/t/invalidate-omnis-cache-with-dbt-or-sql/337)
**Author:** [@cmerrick](https://community.omni.co/u/cmerrick)\ **Replies:** 0\ **Last updated:** [June 6, 2025, 4:56pm UTC](https://community.omni.co/t/invalidate-omnis-cache-with-dbt-or-sql/337 "2025-06-06T16:56:52Z")
We’re going to create a UDF in Snowflake that you can call from dbt or anywhere else. \ means you’ll need to replace that with the relevant value for your environment before running the SQL. Caution: Omni API … --- ## [Issue there is not such direct join](https://community.omni.co/t/issue-there-is-not-such-direct-join/332)
**Author:** [@AdrianaVela](https://community.omni.co/u/AdrianaVela)\ **Replies:** 2\ **Last updated:** [June 5, 2025, 7:41am UTC](https://community.omni.co/t/issue-there-is-not-such-direct-join/332 "2025-06-05T07:41:03Z")
Hi, does anybody know what is this error about? I got this after I did the join between the tables and added to the topic. Any help? --- ## [Working with Stored Procedures](https://community.omni.co/t/working-with-stored-procedures/329)
**Author:** [@adrienb](https://community.omni.co/u/adrienb)\ **Replies:** 0\ **Last updated:** [May 16, 2025, 8:52pm UTC](https://community.omni.co/t/working-with-stored-procedures/329 "2025-05-16T20:52:21Z")
Stored procedures are a common way to make SQL logic reusable at the database level by predefining a set of instructions. They may provide performance, security, and traceability benefits as well as enabling code consoli… [Previous page](https://community.omni.co/latest.md?page=2) [Next page](https://community.omni.co/latest.md?page=4)