# \#modeling **URL:** https://community.omni.co/tag/modeling/21.md [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) --- ## [Show & Tell: a "Topic Reference" for embed users, generated straight from our model repo](https://community.omni.co/t/show-tell-a-topic-reference-for-embed-users-generated-straight-from-our-model-repo/475)
**Author:** [@ShivaPrasad](https://community.omni.co/u/ShivaPrasad)\ **Replies:** 1\ **Last updated:** [September 11, 2026, 3:11pm UTC](https://community.omni.co/t/show-tell-a-topic-reference-for-embed-users-generated-straight-from-our-model-repo/475 "2026-09-11T15:11:21Z")
We run Omni embedded inside our product (JustAsk, Simpro Group’s analytics layer). Our customers are embed users with the Restricted Querier role: they get dashboards, the workbook, the topic picker and Blobby chat, but … --- ## [Run Content Validator in CI](https://community.omni.co/t/run-content-validator-in-ci/437)
**Author:** [@ernesto](https://community.omni.co/u/ernesto)\ **Replies:** 1\ **Last updated:** [August 19, 2026, 10:02am UTC](https://community.omni.co/t/run-content-validator-in-ci/437 "2026-08-19T10:02:30Z")
Overview This guide shows how to run the Content Validator as part of CI in Github so pull requests receive a validation check and a comment with any issues. It makes use of a small python utility, Github actions and the… --- ## [Keep Omni AI Context Updated Programmatically with the CLI + Claude Code](https://community.omni.co/t/keep-omni-ai-context-updated-programmatically-with-the-cli-claude-code/470)
**Author:** [@Benedikt](https://community.omni.co/u/Benedikt)\ **Replies:** 0\ **Last updated:** [July 21, 2026, 10:39am UTC](https://community.omni.co/t/keep-omni-ai-context-updated-programmatically-with-the-cli-claude-code/470 "2026-07-21T10:39:46Z")
Every Omni model has an AI context problem eventually. Someone asks a normal question, the agent picks the wrong field, and you realize your context is stale — because it was written once, by hand, and nobody’s touched i… --- ## [Building a parameter-driven calculation in Omni via templated filters](https://community.omni.co/t/building-a-parameter-driven-calculation-in-omni-via-templated-filters/469)
**Author:** [@brianvu](https://community.omni.co/u/brianvu)\ **Replies:** 0\ **Last updated:** [July 21, 2026, 6:37am UTC](https://community.omni.co/t/building-a-parameter-driven-calculation-in-omni-via-templated-filters/469 "2026-07-21T06:37:39Z")
When I first started at Omni, one of my early support tickets was a customer creating a parameter that let them dynamically adjust a threshold, and a calculated field that recalculated based on whatever value was in that… --- ## [Input values within a pivot](https://community.omni.co/t/input-values-within-a-pivot/465)
**Author:** [@jo\_j](https://community.omni.co/u/jo_j)\ **Replies:** 4\ **Last updated:** [July 13, 2026, 11:01am UTC](https://community.omni.co/t/input-values-within-a-pivot/465 "2026-07-13T11:01:01Z")
I’m trying out the input columns and have a use case where I want to have the input column within a pivot. So for example I have month pivoted across the top and I have the dimension attributes on the left. Within each … --- ## [Querying Struct Types in Omni](https://community.omni.co/t/querying-struct-types-in-omni/462)
**Author:** [@Jaime](https://community.omni.co/u/Jaime)\ **Replies:** 0\ **Last updated:** [June 3, 2026, 9:15pm UTC](https://community.omni.co/t/querying-struct-types-in-omni/462 "2026-06-03T21:15:38Z")
This article will use a Databricks connection in Omni where you can query your struct types. Note that other data platforms like Google Cloud’s BigQuery also have structs and they will follow a similar syntax, like using… --- ## [Create a timezone picker for your end users](https://community.omni.co/t/create-a-timezone-picker-for-your-end-users/456)
**Author:** [@Jiro](https://community.omni.co/u/Jiro)\ **Replies:** 3\ **Last updated:** [May 4, 2026, 9:23pm UTC](https://community.omni.co/t/create-a-timezone-picker-for-your-end-users/456 "2026-05-04T21:23:45Z")
The Problem UPDATE - once enabled in the org Settings panel, you can show users a timezone override dropdown in dashboards (demo here – expected to be available week of May 4th) Some use cases require flexibile timezon… --- ## [Using Omni Local Model Editor to vibe-code AI Context](https://community.omni.co/t/using-omni-local-model-editor-to-vibe-code-ai-context/427)
**Author:** [@liam](https://community.omni.co/u/liam)\ **Replies:** 1\ **Last updated:** [March 19, 2026, 2:51pm UTC](https://community.omni.co/t/using-omni-local-model-editor-to-vibe-code-ai-context/427 "2026-03-19T14:51:19Z")
Using Cursor + Omni’s Local Model Editor to Auto-Generate AI Context I’ve been experimenting with Omni’s local model editor package, and I wanted to share a workflow that’s been working really well for me: using Cursor t… --- ## [How to Dynamically Group the Last N Days vs. the Rest of Your Data 📅](https://community.omni.co/t/how-to-dynamically-group-the-last-n-days-vs-the-rest-of-your-data/448)
**Author:** [@ryan](https://community.omni.co/u/ryan)\ **Replies:** 0\ **Last updated:** [February 19, 2026, 5:22pm UTC](https://community.omni.co/t/how-to-dynamically-group-the-last-n-days-vs-the-rest-of-your-data/448 "2026-02-19T17:22:01Z")
Ever wanted a quick, hands-off way to see how your metrics for the last 7 days stack up against everything else? Now you can build dynamic grouping directly into your data model! Here is a quick step-by-step guide on h… --- ## [Best practices for handling multiple foreign keys to a single User Master table (role-playing dimensions)](https://community.omni.co/t/best-practices-for-handling-multiple-foreign-keys-to-a-single-user-master-table-role-playing-dimensions/442)
**Author:** [@revati](https://community.omni.co/u/revati)\ **Replies:** 5\ **Last updated:** [February 10, 2026, 7:56pm UTC](https://community.omni.co/t/best-practices-for-handling-multiple-foreign-keys-to-a-single-user-master-table-role-playing-dimensions/442 "2026-02-10T19:56:56Z")
Hi everyone! We are looking for the most scalable way to model our User Master list in Omni. Currently, our schema has multiple tables that reference the User table via different foreign keys. For example: Tasks Tabl… --- ## [How to sort a custom markdown visualization dynamically in dashboard view](https://community.omni.co/t/how-to-sort-a-custom-markdown-visualization-dynamically-in-dashboard-view/435)
**Author:** [@nate](https://community.omni.co/u/nate)\ **Replies:** 1\ **Last updated:** [January 5, 2026, 11:34pm UTC](https://community.omni.co/t/how-to-sort-a-custom-markdown-visualization-dynamically-in-dashboard-view/435 "2026-01-05T23:34:25Z")
TL;DR If your custom visualization markdown tile needs dynamic sorting, move sort logic into an Omni query view. Create ranked columns for each sort option, expose them as dashboard controls, and sort the results set by … --- ## [Rank Pivots by a Measure (Top N)](https://community.omni.co/t/rank-pivots-by-a-measure-top-n/225)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 1\ **Last updated:** [December 18, 2025, 4:39pm UTC](https://community.omni.co/t/rank-pivots-by-a-measure-top-n/225 "2025-12-18T16:39:39Z")
NOTE: Omni has now released Top N functionality natively in the workbook. \* How do I get it? In the workbook’s field browser, right click on a field and select the Top N option. There are still some instances where the… --- ## [How to incrementally revert workbook model changes using branches](https://community.omni.co/t/how-to-incrementally-revert-workbook-model-changes-using-branches/425)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [November 20, 2025, 9:41pm UTC](https://community.omni.co/t/how-to-incrementally-revert-workbook-model-changes-using-branches/425 "2025-11-20T21:41:17Z")
This guide will show you how to leverage branches to incrementally revert changes. Let’s start with a workbook that has some workbook model changes. In this workbook I have some custom aggregates and a duplicate field D… --- ## [AI Context Template/Examples](https://community.omni.co/t/ai-context-template-examples/420)
**Author:** [@AdrianaVela](https://community.omni.co/u/AdrianaVela)\ **Replies:** 9\ **Last updated:** [November 18, 2025, 3:12pm UTC](https://community.omni.co/t/ai-context-template-examples/420 "2025-11-18T15:12:26Z")
Hello, I have been working with some clients on how to optimize and tune the model when we are talking about using ai\_context at the model, topic, or view level. One of the most frequently asked questions are what type o… --- ## [References in the Model - Quick Guide](https://community.omni.co/t/references-in-the-model-quick-guide/418)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [November 10, 2025, 10:52pm UTC](https://community.omni.co/t/references-in-the-model-quick-guide/418 "2025-11-10T22:52:42Z")
Omni’s modeling syntax provides flexible and powerful ways to reference fields, views, and filters in your data models. This guide outlines best practices for using field references and Mustache templating to make your m… --- ## [\[LOD\] Comparative sales analysis](https://community.omni.co/t/lod-comparative-sales-analysis/407)
**Author:** [@adrienb](https://community.omni.co/u/adrienb)\ **Replies:** 0\ **Last updated:** [October 22, 2025, 9:57pm UTC](https://community.omni.co/t/lod-comparative-sales-analysis/407 "2025-10-22T21:57:49Z")
A comparative sales analysis provides a quick visual way to benchmark or compare metrics across key business dimensions. We would like an output like this, where the Comparison Category serves as the basis against which … --- ## [Where'd My Money Go? (How to properly convert from money type to decimal in Postgre)](https://community.omni.co/t/whered-my-money-go-how-to-properly-convert-from-money-type-to-decimal-in-postgre/398)
**Author:** [@samp](https://community.omni.co/u/samp)\ **Replies:** 0\ **Last updated:** [October 2, 2025, 8:46pm UTC](https://community.omni.co/t/whered-my-money-go-how-to-properly-convert-from-money-type-to-decimal-in-postgre/398 "2025-10-02T20:46:58Z")
Hi all! I recently learned that when you are working off of a PostgreSQL database and convert a MONEY type to DECIMAL, it defaults to DECIMAL(10, 0). That means 10 total digits and 0 digits after the decimal. This resul… --- ## [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… --- ## [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… --- ## [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… --- ## [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… --- ## [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… --- ## [Dashboard Tabs Preserving Filter Selection](https://community.omni.co/t/dashboard-tabs-preserving-filter-selection/221)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 0\ **Last updated:** [January 28, 2025, 4:59pm UTC](https://community.omni.co/t/dashboard-tabs-preserving-filter-selection/221 "2025-01-28T16:59:09Z")
If you’re migrating to Omni from a product that has tabbed dashboards, you may have wished you could make a filter selection on one tab and apply those same filters across other tabs. You can! Using our markdown visualiz… --- ## [Edit multiple lines in the IDE at once](https://community.omni.co/t/edit-multiple-lines-in-the-ide-at-once/322)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [May 7, 2025, 9:46am UTC](https://community.omni.co/t/edit-multiple-lines-in-the-ide-at-once/322 "2025-05-07T09:46:53Z")
Using Multi-line Editing in Your IDE Need to make identical changes across multiple lines? Save time by editing several lines simultaneously: Hold cmd (command) on Mac or ctrl on Windows/Linux Click each location where… --- ## [Comparing metrics over arbitrary periods](https://community.omni.co/t/comparing-metrics-over-arbitrary-periods/280)
**Author:** [@kylee](https://community.omni.co/u/kylee)\ **Replies:** 0\ **Last updated:** [March 22, 2025, 1:49am UTC](https://community.omni.co/t/comparing-metrics-over-arbitrary-periods/280 "2025-03-22T01:49:05Z")
Omni’s native Period-over-Period comparison is a powerful way to analyze trends between related time frames, such as comparing performance across weeks, months, or years. But what if you need to compare two periods that … --- ## [Set parameters for multiple calculations](https://community.omni.co/t/set-parameters-for-multiple-calculations/295)
**Author:** [@marcus\_montenegro](https://community.omni.co/u/marcus_montenegro)\ **Replies:** 1\ **Last updated:** [April 4, 2025, 7:17pm UTC](https://community.omni.co/t/set-parameters-for-multiple-calculations/295 "2025-04-04T19:17:44Z")
Hey everyone! Is there a way that I can set parameters, like environment variables, that I can call across multiple calculations? For example, set a variable named “X” and use it to divide new columns A, B, and C by th… --- ## [Standardizing US State Name Data to State Code](https://community.omni.co/t/standardizing-us-state-name-data-to-state-code/288)
**Author:** [@Becca\_Omni](https://community.omni.co/u/Becca_Omni)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 12:41pm UTC](https://community.omni.co/t/standardizing-us-state-name-data-to-state-code/288 "2025-03-28T12:41:15Z")
When working with data such as Salesforce data where data validation for US state input fields doesn’t always exist, you may need to ensure the data you’re presenting all rolls up correctly without seeing CA and Californ… --- ## [Issue with Top 10 Filter Removal in Query after joining](https://community.omni.co/t/issue-with-top-10-filter-removal-in-query-after-joining/282)
**Author:** [@Amihai](https://community.omni.co/u/Amihai)\ **Replies:** 1\ **Last updated:** [March 24, 2025, 8:06am UTC](https://community.omni.co/t/issue-with-top-10-filter-removal-in-query-after-joining/282 "2025-03-24T08:06:58Z")
I created my top 10 list using aggregation, saved it as a view, and joined it with my main topic. However, the top 10 filter was removed from my query, resulting in the full list. How can I fix this? [Next page](https://community.omni.co/tag/modeling/21.md?match_all_tags=true&page=1&tags%5B%5D=modeling)