# Latest **URL:** https://community.omni.co/latest.md?page=4 [Latest](https://community.omni.co/latest.md) · [Categories](https://community.omni.co/categories.md) · [Tags](https://community.omni.co/tags.md) **Page:** 5 --- ## [Working with dynamic schemas](https://community.omni.co/t/working-with-dynamic-schemas/99)
**Author:** [@conor](https://community.omni.co/u/conor)\ **Replies:** 0\ **Last updated:** [June 7, 2024, 8:09am UTC](https://community.omni.co/t/working-with-dynamic-schemas/99 "2024-06-07T08:09:09Z")
Dynamic schemas Dynamic schemas are a useful concept to implement when your data is partitioned into separate, but identical schemas. In industry, this is referred to as a single tenant database architecture. Suppose we… --- ## [Fun Company Progress Chart (with Zooming / Panning)](https://community.omni.co/t/fun-company-progress-chart-with-zooming-panning/321)
**Author:** [@colin](https://community.omni.co/u/colin)\ **Replies:** 1\ **Last updated:** [May 14, 2025, 2:46pm UTC](https://community.omni.co/t/fun-company-progress-chart-with-zooming-panning/321 "2025-05-14T14:46:51Z")
To celebrate our growth, we built a little visualization highlighting all of the Omnis alongside our customer growth (demo here) Here’s a code example for folks that want to build something similar. We used a csv upl… --- ## [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… --- ## [How to debug #ERROR in table calculations](https://community.omni.co/t/how-to-debug-error-in-table-calculations/320)
**Author:** [@James](https://community.omni.co/u/James)\ **Replies:** 0\ **Last updated:** [May 2, 2025, 3:59pm UTC](https://community.omni.co/t/how-to-debug-error-in-table-calculations/320 "2025-05-02T15:59:11Z")
Omni supports 1:1 excel syntax in writing table calculations. \[1\] There may be cases where some formulas displays an error due to syntax or other limitations on query structure. Generally more info regarding that calcul… --- ## [Threshold reporting in Omni](https://community.omni.co/t/threshold-reporting-in-omni/218)
**Author:** [@kylee](https://community.omni.co/u/kylee)\ **Replies:** 1\ **Last updated:** [April 29, 2025, 12:37am UTC](https://community.omni.co/t/threshold-reporting-in-omni/218 "2025-04-29T00:37:25Z")
Threshold alerting allows data teams and executives to monitor key metrics and act proactively when thresholds are crossed. In this example we will be setting up an alert for when the number of users at our platform goe… --- ## [Why can't I add data labels on a 100% stacked chart?](https://community.omni.co/t/why-cant-i-add-data-labels-on-a-100-stacked-chart/315)
**Author:** [@Em\_206](https://community.omni.co/u/Em_206)\ **Replies:** 1\ **Last updated:** [April 24, 2025, 3:32pm UTC](https://community.omni.co/t/why-cant-i-add-data-labels-on-a-100-stacked-chart/315 "2025-04-24T15:32:27Z")
I’ve created a chart and do not have the option to add data labels if I visualize the data in 100% stacked bars. Why? Thanks! --- ## [Cloud function to google slides](https://community.omni.co/t/cloud-function-to-google-slides/309)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [April 19, 2025, 4:01pm UTC](https://community.omni.co/t/cloud-function-to-google-slides/309 "2025-04-19T16:01:37Z")
Here’s a similar write-up for our Google Slides image update function, based on the similar framework provided by Russ for writing to Google Sheets without Zapier: Cloud Function to Update Google Slides Images Do you ne… --- ## [How to Add Images & Logos to a Dashboard!](https://community.omni.co/t/how-to-add-images-logos-to-a-dashboard/307)
**Author:** [@adrienb](https://community.omni.co/u/adrienb)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 4:51pm UTC](https://community.omni.co/t/how-to-add-images-logos-to-a-dashboard/307 "2025-04-17T16:51:38Z")
Have you ever felt like the one thing missing to really bring a dashboard together is an image or company logo? Well wonder no more, here are three ways to do just that in Omni! Method 1 - Simple Static Image This metho… --- ## [How can I share Omni content e.g. a single dashboard with outside contractors, partners, or employees?](https://community.omni.co/t/how-can-i-share-omni-content-e-g-a-single-dashboard-with-outside-contractors-partners-or-employees/153)
**Author:** [@jack](https://community.omni.co/u/jack)\ **Replies:** 0\ **Last updated:** [September 18, 2024, 1:08pm UTC](https://community.omni.co/t/how-can-i-share-omni-content-e-g-a-single-dashboard-with-outside-contractors-partners-or-employees/153 "2024-09-18T13:08:15Z")
If you are looking to provide access to Omni content to external users, most likely you will want to take advantage of embedded functionality. However in some cases, you may wish to provide very limited access directly … --- ## [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… --- ## [Cloud function to google sheets](https://community.omni.co/t/cloud-function-to-google-sheets/294)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 0\ **Last updated:** [April 2, 2025, 2:43am UTC](https://community.omni.co/t/cloud-function-to-google-sheets/294 "2025-04-02T02:43:52Z")
Do you need Omni data in Google Sheets? If you have GCP and the ability to create a cloud function, this article is for you. We’ll be extending the pattern to AWS and Azure soon. Connor wrote an excellent article on ho… --- ## [Filters for Formula Columns](https://community.omni.co/t/filters-for-formula-columns/290)
**Author:** [@fern](https://community.omni.co/u/fern)\ **Replies:** 1\ **Last updated:** [March 31, 2025, 5:00pm UTC](https://community.omni.co/t/filters-for-formula-columns/290 "2025-03-31T17:00:12Z")
I have a simple table where: Column A represents the date companies were added. Column B shows the number of companies added that date. Column C calculates the 7-day moving average using a formula. Is there a way t… --- ## [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? --- ## [Tabbed Analytics feature](https://community.omni.co/t/tabbed-analytics-feature/279)
**Author:** [@marcus\_montenegro](https://community.omni.co/u/marcus_montenegro)\ **Replies:** 4\ **Last updated:** [March 21, 2025, 1:10pm UTC](https://community.omni.co/t/tabbed-analytics-feature/279 "2025-03-21T13:10:46Z")
Hello everyone! I watched a recent video regarding a new Analytics option, between Develop and Settings, that allows us to build tabbed dashboards natively, right? I do not see it yet. Will that still be released? 20… --- ## [How to Dynamically reference Pivot Index / index Value](https://community.omni.co/t/how-to-dynamically-reference-pivot-index-index-value/272)
**Author:** [@SN1011](https://community.omni.co/u/SN1011)\ **Replies:** 1\ **Last updated:** [March 20, 2025, 9:56pm UTC](https://community.omni.co/t/how-to-dynamically-reference-pivot-index-index-value/272 "2025-03-20T21:56:41Z")
I am using “=IF(PIVOTOFFSET(D1, 0, -1) \< 0, PIVOTINDEX(), NULL)” this formula to reference the corresponding pivot index value , but everytime index 1 is getting referenced. Is there anyway we can directly reference pi… --- ## [Easily create dashboard themes with AI](https://community.omni.co/t/easily-create-dashboard-themes-with-ai/278)
**Author:** [@peter](https://community.omni.co/u/peter)\ **Replies:** 0\ **Last updated:** [March 20, 2025, 9:28pm UTC](https://community.omni.co/t/easily-create-dashboard-themes-with-ai/278 "2025-03-20T21:28:02Z")
In Omni you can customize the look and feel of your dashboards by creating custom themes. Our documentation here covers the basics of theming and the CSS elements you can update to create your own stylings of your dashbo… --- ## [Automating Complex Assignments in Omni with CSV Uploads and Saved Query Views: A Step-by-Step Guide](https://community.omni.co/t/automating-complex-assignments-in-omni-with-csv-uploads-and-saved-query-views-a-step-by-step-guide/267)
**Author:** [@jade](https://community.omni.co/u/jade)\ **Replies:** 0\ **Last updated:** [March 14, 2025, 5:01pm UTC](https://community.omni.co/t/automating-complex-assignments-in-omni-with-csv-uploads-and-saved-query-views-a-step-by-step-guide/267 "2025-03-14T17:01:09Z")
In this tutorial, we’ll explore how to leverage input tables to combine a results set and a lookup table with complex criteria, all within Omni. Specifically, we’ll demonstrate how to dynamically assign campaign managers… --- ## [Issue Connecting MySql to Omni](https://community.omni.co/t/issue-connecting-mysql-to-omni/266)
**Author:** [@sam\_p](https://community.omni.co/u/sam_p)\ **Replies:** 3\ **Last updated:** [March 14, 2025, 4:54am UTC](https://community.omni.co/t/issue-connecting-mysql-to-omni/266 "2025-03-14T04:54:39Z")
I’ve been trying to connect OMNI to MySQL but I think the documentation is for MySQL prior to 9.0 because the internet is saying you cannot GRANT permissions in the newest version of MySQL. Has anyone else had the same i… --- ## [XmR Charts in Omni](https://community.omni.co/t/xmr-charts-in-omni/258)
**Author:** [@sarah](https://community.omni.co/u/sarah)\ **Replies:** 0\ **Last updated:** [March 11, 2025, 6:44pm UTC](https://community.omni.co/t/xmr-charts-in-omni/258 "2025-03-11T18:44:17Z")
We’ve had a few folks interested in using XmR charts in Omni, and while we don’t have an XmR-specific chart type, we can use calculations to recreate them in a fairly straightforward way with our line charts. I recently … --- ## [Easy Embed URL Testing](https://community.omni.co/t/easy-embed-url-testing/255)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 0\ **Last updated:** [March 4, 2025, 12:21am UTC](https://community.omni.co/t/easy-embed-url-testing/255 "2025-03-04T00:21:43Z")
When testing Embedded analytics with Omni, the URL builder is an amazing tool. But it doesn’t support all of the extended attributes you may want to pass to produce a test url. This is an easy API recipe using our Pytho… --- ## [Bulk User and User Attribute management](https://community.omni.co/t/bulk-user-and-user-attribute-management/253)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 0\ **Last updated:** [March 3, 2025, 11:49pm UTC](https://community.omni.co/t/bulk-user-and-user-attribute-management/253 "2025-03-03T23:49:45Z")
The best approach to managing users and their attributes 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 n… --- ## [Calendar Tables (date spine)](https://community.omni.co/t/calendar-tables-date-spine/252)
**Author:** [@russ](https://community.omni.co/u/russ)\ **Replies:** 0\ **Last updated:** [March 3, 2025, 4:53am UTC](https://community.omni.co/t/calendar-tables-date-spine/252 "2025-03-03T04:53:39Z")
You might have heard of a “calendar table” or “date spine”. It’s a technique that starts with a contiguous time series and can be useful in a few scenarios: Unifying multiple timestamps on the same common x-axis Sparse… --- ## [Update your slides with new images](https://community.omni.co/t/update-your-slides-with-new-images/239)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 0\ **Last updated:** [February 14, 2025, 7:40pm UTC](https://community.omni.co/t/update-your-slides-with-new-images/239 "2025-02-14T19:40:35Z")
Are you using Omni dashboards or tiles in a Google slide deck and find that updating every single image in your slides takes forever? Check out this Zapier workflow template to update your slides programmatically from a … --- ## [Multiplying or Dividing Dimensions and Measures in the Data Model Using \`in\_query\`](https://community.omni.co/t/multiplying-or-dividing-dimensions-and-measures-in-the-data-model-using-in-query/207)
**Author:** [@colin](https://community.omni.co/u/colin)\ **Replies:** 0\ **Last updated:** [January 2, 2025, 11:33pm UTC](https://community.omni.co/t/multiplying-or-dividing-dimensions-and-measures-in-the-data-model-using-in-query/207 "2025-01-02T23:33:47Z")
In most SQL dialects, one can only do math between dimensions (things in the group by) and measures (aggregates, not in the group by) when said dimensions are in the query. Omni restricts these query-structure contingen… --- ## [Can you provide some example dashboard themes?](https://community.omni.co/t/can-you-provide-some-example-dashboard-themes/180)
**Author:** [@sarah](https://community.omni.co/u/sarah)\ **Replies:** 5\ **Last updated:** [February 13, 2025, 10:07pm UTC](https://community.omni.co/t/can-you-provide-some-example-dashboard-themes/180 "2025-02-13T22:07:35Z")
Recently Omni demoed some fun seasonal themes to show off the additional dashboard theming capabilities. I thought it’d be fun to share additional variations to demonstrate how the exact same content can get a totally di… --- ## [Use Vega Editor to Make a Boxplot](https://community.omni.co/t/use-vega-editor-to-make-a-boxplot/233)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 0\ **Last updated:** [February 11, 2025, 9:26pm UTC](https://community.omni.co/t/use-vega-editor-to-make-a-boxplot/233 "2025-02-11T21:26:05Z")
Need to edit the min-max of your boxplot? Or make other code customizations that aren’t available in the default boxplot visualization? You can use this vega-lite starting point of a boxplot to use within Omni’s vega ed… --- ## [Point an existing model to a new service account project or new schemas with the same structure](https://community.omni.co/t/point-an-existing-model-to-a-new-service-account-project-or-new-schemas-with-the-same-structure/231)
**Author:** [@aklance](https://community.omni.co/u/aklance)\ **Replies:** 0\ **Last updated:** [February 10, 2025, 5:06pm UTC](https://community.omni.co/t/point-an-existing-model-to-a-new-service-account-project-or-new-schemas-with-the-same-structure/231 "2025-02-10T17:06:19Z")
Do you need to replace an entire catalog (project) or schema reference and essentially have the same tables now in a new service account or project? This article will help guide you through the process. Please read thro… [Previous page](https://community.omni.co/latest.md?page=3) [Next page](https://community.omni.co/latest.md?page=5)