# Latest **URL:** https://community.omni.co/latest.md?page=2 [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) **Page:** 3 --- ## [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… --- ## [Dynamically name files for deliveries](https://community.omni.co/t/dynamically-name-files-for-deliveries/423)
**Author:** [@cade](https://community.omni.co/u/cade)\ **Replies:** 0\ **Last updated:** [November 17, 2025, 9:36pm UTC](https://community.omni.co/t/dynamically-name-files-for-deliveries/423 "2025-11-17T21:36:25Z")
We now have the ability to dynamically name files that are being sent out for deliveries using mustache syntax. This will be super useful if you are looking to appended a timestamp/date onto a file name, timezone, entity… --- ## [\[LOD\] Comparing metrics to a custom time range](https://community.omni.co/t/lod-comparing-metrics-to-a-custom-time-range/422)
**Author:** [@adrienb](https://community.omni.co/u/adrienb)\ **Replies:** 0\ **Last updated:** [November 13, 2025, 12:57am UTC](https://community.omni.co/t/lod-comparing-metrics-to-a-custom-time-range/422 "2025-11-13T00:57:01Z")
This Level-of-Detail example walks through creating the following analysis, where a user-selected time period serves as the benchmark against which to compare a different time period. For example, in this screenshot we c… --- ## [References in the Content Validator - Quick Guide](https://community.omni.co/t/references-in-the-content-validator-quick-guide/421)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [November 11, 2025, 11:09pm UTC](https://community.omni.co/t/references-in-the-content-validator-quick-guide/421 "2025-11-11T23:09:09Z")
When searching with the content validator or replacing views, fields, and topics, it’s important to reference each object using the proper view names, fully-scoped fields, and topic identifiers. Note: Content Validator … --- ## [Why Two Users Might See Different Data in Omni Dashboards](https://community.omni.co/t/why-two-users-might-see-different-data-in-omni-dashboards/419)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [November 10, 2025, 11:46pm UTC](https://community.omni.co/t/why-two-users-might-see-different-data-in-omni-dashboards/419 "2025-11-10T23:46:32Z")
When two users view the same dashboard but see different results, there may be differences in filters, cache, access controls, or time zone configurations. This article walks through each factor to help you diagnose and … --- ## [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… --- ## [Drill down on heatmap](https://community.omni.co/t/drill-down-on-heatmap/414)
**Author:** [@cmck](https://community.omni.co/u/cmck)\ **Replies:** 8\ **Last updated:** [November 6, 2025, 5:03pm UTC](https://community.omni.co/t/drill-down-on-heatmap/414 "2025-11-06T17:03:39Z")
Is there a way to drill down to records that make up a heatmap? --- ## [Subtotals and XLOOKUP](https://community.omni.co/t/subtotals-and-xlookup/415)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [November 5, 2025, 9:35pm UTC](https://community.omni.co/t/subtotals-and-xlookup/415 "2025-11-05T21:35:19Z")
When you add subtotals to a query that uses XLOOKUP calcs, sometimes the subtotal may appear blank on the XLOOKUP field. To ensure the subtotal gets calculated correctly, you’ll need to ensure all keys are included i… --- ## [How to order chart legend based on pivoted field](https://community.omni.co/t/how-to-order-chart-legend-based-on-pivoted-field/413)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [November 4, 2025, 10:40pm UTC](https://community.omni.co/t/how-to-order-chart-legend-based-on-pivoted-field/413 "2025-11-04T22:40:45Z")
When building a chart that’s colored by a pivoted dimension, you may see the legend sort order not match the pivoted field sort order. To resolve this, you’ll want to fill in missing cells in grid to convert the null… --- ## [How to refer to the computed value of a filter in a markdown viz/note](https://community.omni.co/t/how-to-refer-to-the-computed-value-of-a-filter-in-a-markdown-viz-note/412)
**Author:** [@satya-marigold](https://community.omni.co/u/satya-marigold)\ **Replies:** 1\ **Last updated:** [November 4, 2025, 3:20pm UTC](https://community.omni.co/t/how-to-refer-to-the-computed-value-of-a-filter-in-a-markdown-viz-note/412 "2025-11-04T15:20:10Z")
So Connor has an example here (How do I reference a filter value? (Filters as parameters) - Modeling - Omni Community) where you can refer to the filter’s value. But for dates - if you use the filter as past 1 complete … --- ## [Dynamically Change Date Granularity Based on Filter Timeframe](https://community.omni.co/t/dynamically-change-date-granularity-based-on-filter-timeframe/367)
**Author:** [@adrienb](https://community.omni.co/u/adrienb)\ **Replies:** 1\ **Last updated:** [October 27, 2025, 4:48pm UTC](https://community.omni.co/t/dynamically-change-date-granularity-based-on-filter-timeframe/367 "2025-10-27T16:48:34Z")
When working with time series data, you may be commonly switching between hourly/daily/weekly or even other time granularities. Omni provides a built-in way to flip between these options using the Time Frame Switcher con… --- ## [Filtering "dependent" tile](https://community.omni.co/t/filtering-dependent-tile/411)
**Author:** [@Alec](https://community.omni.co/u/Alec)\ **Replies:** 2\ **Last updated:** [October 26, 2025, 4:35pm UTC](https://community.omni.co/t/filtering-dependent-tile/411 "2025-10-26T16:35:46Z")
I have a “main” tile and “dependent” tile. I would like when a point on the “main” diagram clicked the “dependent” tile to change accordingly. For instance, the “main” tile is a bar chart and has X-axis month. The “dep… --- ## [Calendar visualization](https://community.omni.co/t/calendar-visualization/410)
**Author:** [@ssmithereens](https://community.omni.co/u/ssmithereens)\ **Replies:** 0\ **Last updated:** [October 25, 2025, 5:12pm UTC](https://community.omni.co/t/calendar-visualization/410 "2025-10-25T17:12:44Z")
By using an Omni Sheet connected to live data, along with formulas for calendar rendering and conditional formatting, you can create a dynamic and visually engaging calendar view. --- ## [How to restore a view that is ignored in the shared model, from within a branch](https://community.omni.co/t/how-to-restore-a-view-that-is-ignored-in-the-shared-model-from-within-a-branch/408)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [October 22, 2025, 10:21pm UTC](https://community.omni.co/t/how-to-restore-a-view-that-is-ignored-in-the-shared-model-from-within-a-branch/408 "2025-10-22T22:21:20Z")
Here’s how to restore a view that is ignored in the shared model, from within a branch. What you’re seeing View files can be ignored which will remove them from the Combined model view and move them into Model mode (S… --- ## [\[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 … --- ## [Why does my workbook query look different on the dashboard?](https://community.omni.co/t/why-does-my-workbook-query-look-different-on-the-dashboard/406)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [October 22, 2025, 8:50pm UTC](https://community.omni.co/t/why-does-my-workbook-query-look-different-on-the-dashboard/406 "2025-10-22T20:50:34Z")
When a chart looks “right” in the workbook but “wrong” on the dashboard (or two dashboard charts disagree), the most common root cause is that the dashboard context (filters and controls) is changing the query. The fa… --- ## [Dynamic text color on conditional formatted table cells](https://community.omni.co/t/dynamic-text-color-on-conditional-formatted-table-cells/405)
**Author:** [@jrodr](https://community.omni.co/u/jrodr)\ **Replies:** 3\ **Last updated:** [October 22, 2025, 5:55pm UTC](https://community.omni.co/t/dynamic-text-color-on-conditional-formatted-table-cells/405 "2025-10-22T17:55:13Z")
It would be fantastic if the text color in a conditionally formatted cell swapped between white and black depending on the background color of the cell. Without this, many conditional formatting color presets are unusabl… --- ## [Bulk connection management at a user level](https://community.omni.co/t/bulk-connection-management-at-a-user-level/402)
**Author:** [@Kartik](https://community.omni.co/u/Kartik)\ **Replies:** 6\ **Last updated:** [October 22, 2025, 12:28am UTC](https://community.omni.co/t/bulk-connection-management-at-a-user-level/402 "2025-10-22T00:28:26Z")
Hey everyone, Can anyone please tell me if we have the ability to manipulate the user connection settings i.e. viewer, Restricted Querier, Querier etc from the API? I was seeing the api docs for “users” but there is not… --- ## [Building a clean pivot table by hiding repeated values](https://community.omni.co/t/building-a-clean-pivot-table-by-hiding-repeated-values/404)
**Author:** [@adrienb](https://community.omni.co/u/adrienb)\ **Replies:** 2\ **Last updated:** [October 21, 2025, 11:59pm UTC](https://community.omni.co/t/building-a-clean-pivot-table-by-hiding-repeated-values/404 "2025-10-21T23:59:13Z")
Sometimes table visualizations are more useful when dimensions are expanded by default, rather than grouped together, but repeated values can quickly fill up real estate. Here is how to make a clean table using excel cal… --- ## [What are the keyboard shortcuts in a workbook or a model?](https://community.omni.co/t/what-are-the-keyboard-shortcuts-in-a-workbook-or-a-model/78)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 1\ **Last updated:** [October 17, 2025, 8:16pm UTC](https://community.omni.co/t/what-are-the-keyboard-shortcuts-in-a-workbook-or-a-model/78 "2025-10-17T20:16:54Z")
Check out our Keyboard Shortcuts documentation! --- ## [Templated Filters in Dashboards: Not Able to Apply to only Single Tile](https://community.omni.co/t/templated-filters-in-dashboards-not-able-to-apply-to-only-single-tile/403)
**Author:** [@quangle12](https://community.omni.co/u/quangle12)\ **Replies:** 3\ **Last updated:** [October 15, 2025, 9:55pm UTC](https://community.omni.co/t/templated-filters-in-dashboards-not-able-to-apply-to-only-single-tile/403 "2025-10-15T21:55:34Z")
So I created a dashboard where I have a table that utilizes a templated date range filter to display different counts based on different days. The templated filter functions perfectly fine, but I only want that templated… --- ## [Custom no results messages and experiences in Markdown tiles](https://community.omni.co/t/custom-no-results-messages-and-experiences-in-markdown-tiles/284)
**Author:** [@sarah](https://community.omni.co/u/sarah)\ **Replies:** 2\ **Last updated:** [October 14, 2025, 5:20pm UTC](https://community.omni.co/t/custom-no-results-messages-and-experiences-in-markdown-tiles/284 "2025-10-14T17:20:56Z")
Sometimes when creating a custom markdown tile you need to consider what to display when there are no results returned from a query. Empty or blank visualizations can be a bit confusing to end-viewers. For example, here’… --- ## [Testing dbt changes in Omni before pushing to production (Omni's dynamic dbt environments)](https://community.omni.co/t/testing-dbt-changes-in-omni-before-pushing-to-production-omnis-dynamic-dbt-environments/401)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [October 7, 2025, 11:44pm UTC](https://community.omni.co/t/testing-dbt-changes-in-omni-before-pushing-to-production-omnis-dynamic-dbt-environments/401 "2025-10-07T23:44:29Z")
When you’re editing a dbt model, a seemingly minor change (like renaming a column or updating a WHERE clause) can quietly break dozens of downstream charts. Omni’s dynamic dbt environments give you a tight software devel… --- ## [Turning Omni saved query views into dbt models](https://community.omni.co/t/turning-omni-saved-query-views-into-dbt-models/400)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [October 7, 2025, 11:32pm UTC](https://community.omni.co/t/turning-omni-saved-query-views-into-dbt-models/400 "2025-10-07T23:32:57Z")
As teams explore in Omni, useful transformations will naturally emerge. Instead of leaving them as one-off queries, you can save the query as an Omni view — a lightweight, virtual transformation (like a CTE you can refer… --- ## [Sharing metadata between Omni and dbt (description, exposures, accepted\_values, and more)](https://community.omni.co/t/sharing-metadata-between-omni-and-dbt-description-exposures-accepted-values-and-more/399)
**Author:** [@conner](https://community.omni.co/u/conner)\ **Replies:** 0\ **Last updated:** [October 7, 2025, 11:28pm UTC](https://community.omni.co/t/sharing-metadata-between-omni-and-dbt-description-exposures-accepted-values-and-more/399 "2025-10-07T23:28:44Z")
If you’ve spent time building out metadata in your dbt environment, it can be brought into Omni automatically and be helpful for end users. For example, field and table descriptions will automatically show up in the UI a… --- ## [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… --- ## [Why are my schemas and/or tables not appearing in the model IDE?](https://community.omni.co/t/why-are-my-schemas-and-or-tables-not-appearing-in-the-model-ide/156)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 1\ **Last updated:** [September 30, 2025, 10:04pm UTC](https://community.omni.co/t/why-are-my-schemas-and-or-tables-not-appearing-in-the-model-ide/156 "2025-09-30T22:04:56Z")
Overview Are you working in your model IDE and notice there are entire schemas and/or tables missing from the list? It’s possible the OMNI\_USER created on your database doesn’t have the appropriate permissions to view or… --- ## [Optimizing Google Sheets Deliveries to avoid Rate Limiting](https://community.omni.co/t/optimizing-google-sheets-deliveries-to-avoid-rate-limiting/397)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [September 30, 2025, 4:31pm UTC](https://community.omni.co/t/optimizing-google-sheets-deliveries-to-avoid-rate-limiting/397 "2025-09-30T16:31:27Z")
For teams that are executing a high volume of google sheets deliveries with high frequency, you may be affected by rate limits imposed by Google Sheet’s API. If the frequency of deliveries starts to become shorter than t… --- ## [Using Okta Groups to assign user attributes in Omni](https://community.omni.co/t/using-okta-groups-to-assign-user-attributes-in-omni/396)
**Author:** [@Jiro](https://community.omni.co/u/Jiro)\ **Replies:** 0\ **Last updated:** [September 30, 2025, 3:41am UTC](https://community.omni.co/t/using-okta-groups-to-assign-user-attributes-in-omni/396 "2025-09-30T03:41:56Z")
This article assumes you have already followed our docs to successfully configure the Omni App in Okta, enabled SCIM to push groups and user attributes from Okta to Omni successfully, and have the appropriate attributes… --- ## [Error: "The API developer key is invalid" when connecting to google sheets](https://community.omni.co/t/error-the-api-developer-key-is-invalid-when-connecting-to-google-sheets/395)
**Author:** [@Jiro](https://community.omni.co/u/Jiro)\ **Replies:** 0\ **Last updated:** [September 29, 2025, 7:05pm UTC](https://community.omni.co/t/error-the-api-developer-key-is-invalid-when-connecting-to-google-sheets/395 "2025-09-29T19:05:20Z")
This very general error can appear for a number of reasons but the primary one is that the browser has interrupted the step where Omni is communicating with Google. We’ve seen browser plugins and certain chromium based … [Previous page](https://community.omni.co/latest.md?page=1) [Next page](https://community.omni.co/latest.md?page=3)