ArborRose Coach

Looks like your code is attempting to access an iframe from outside Domo's iframe. In other words, the source of the iframe is from a different domain than Domo. <iframe id="domoFrame" src="https://<domo-url>?autoresize=true" width="100%" height="100%" scrolling="no"></iframe> Can you do the sizing in the iframe statement…

The error you're encountering, NameError: name '_jupyterhub' is not defined, indicates that the _jupyterhub object, which is likely supposed to handle AI generation requests in Domo's Jupyter integration, is not being properly recognized in your Jupyter Notebook. _jupyterhub may not be correctly imported or initialized in…

Domo has maximum number of characters for text fields as 1024, but numerical fields also have limits. For number and fixed decimal, Domo stores numbers as 64-bit floating point values (ie. Double in most databases). This give high range values, but also precision limits. If your number is large, you may have an issue with…

Note: I think Shopify has rate limits of something like 2 requests/second.

I'm not sure what you are looking for @DMJerry. I thought the responses gave insight into solutions. Shopify has an API that can be called with Domo's API connectors, or through a custom connector. Create a Shopify Private App (or API credentials): Go to your Shopify admin. Navigate to Apps -> Develop apps. Create a new…

I was told by Domo staff a year ago that things like the title and metadata were not something we could alter or customize. Due to that fact, I do not use PDF in Domo. If there is a way, I'd like to hear it.

There are settings in Admin > Authentication related to SCIM (System for Cross-domain Identity Management). There are settings for Single Sign-On, OpenID Connect (SSO), SAML (SSO), etc. Try this AI suggestion: Here’s a step-by-step guide on how to enable and configure SCIM for automating user onboarding in Domo via Okta:…

I would have thought @ColemenWilson was on the right track. If changing the type didn't fix it, it might be causes by something in your transformations. Sometimes, applying transformations in Domo (like STR_TO_DATE() for date formatting) may unintentionally cause type casting issues in other columns. CAST(`Net Change USD`…

Make sure you have back ticks on your fields, and that your field names match the correct spelling.

SUM(CASE WHEN STATE = 'Ringing' AND TIME_TO_SEC(AGENT_STATE_TIME) <= 11 AND LEAD(STATE) OVER (PARTITION BY AGENT_NAME ORDER BY DATE, AGENT_NAME) = 'Not Ready' THEN 1 ELSE 0 END)

The error looks like it has trouble trying to connect DV 360 (Google Display & Video 360) to Domo related to a permission problem or missing configuration in your Google Cloud Console project. I'm not familiar with the DV360, but here's an AI solution. Maybe it will help. API Access and Enable Display & Video 360 API in…

https://community-forums.domo.com/main/discussion/comment/98306#Comment_98306 @khushboo_, you are the only person talking about App Studio in this discussion.

https://community-forums.domo.com/main/discussion/comment/98304#Comment_98304 The only thing I have seen is to set the whole table's borders. Unless I have missed some ability to control specific cell, column or row borders, this is woefully inadequate.

You need to be careful how you compare week from one year to week from another. Depending upon how the calendar falls, it's apples and oranges.

Tweaking that a bit… CASE WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday' ELSE `ConsolidationDay` END

Domo does support some basic HTML formatting in Beast Mode, such as <b> for bold text, and <font> tags for color. But, not all visualizations honor HTML formatting in column data. It sounds like you had success in summary but not in the column data itself. To create a string as bold and color, your formula would be…

I've never done this type of writeback connector, but I think you have to upload a public key to the SFTP server through the SFTP client. Look for a folder such as ".ssh/authorized_keys". You upload your public key file to that directory on the server, typically handled server side, not in Domo.

Sorry, part of that answer was redundant since I made two calculations with the same formula. <:*)

Assume my dataset is: A001 All Good A002 All Good A003 Our Leaders are approchable A004 All Good A005 We have good Cafeteria A006 All Good A007 I have a Good Work-Life Balance A008 I feel I am valued A009 I enjoy doing my Work A010 All Good A011 All Good A012 All Good A013 I enjoy doing my Work A014 I enjoy doing my Work…

A calculated field something like this? CASE WHEN `Date_StatusChange` < '2024-08-25' THEN 'Carry-In' ELSE CONCAT(YEAR(`Date_StatusChange`), '-', MONTH(`Date_StatusChange`), '-', DAY(`Date_StatusChange`)) END

Hard to say what's going on without seeing a data sample. It's normally due to the way the data is structured or the settings on the chart configuration. 1. Check your formulas. Make sure you are aggregating data based on the states. Since you calculate average days and median days, each beast mode should properly…

I don't have any experience myself connecting to BlueCherry ERP. But I would assume you could connect using any of the normal methods we connect with other systems such as via an API: Obtain API Documentation: Get the API documentation from BlueCherry ERP to understand the available endpoints, authentication methods, and…

Domo does not provide a standard SFTP server endpoint for file uploads directly. Instead, Domo typically integrates with data sources through connectors, APIs, and other methods rather than direct SFTP uploads. If you need to transfer data to Domo, you generally have these options: Domo Connectors: Use one of Domo's…

I agree with @nmizzell, if you can share with the groups. Sometimes that's not an option. Make sure the end users have been granted the correct permissions to the dashboard. Sometimes, dashboard permissions might not automatically extend to all the components within the dashboard. Card Permissions: Verify if there are…

Depending on your technical resources, you might be able to create a custom solution. For example, using Domo’s API to extract data from cards and then generate reports or files programmatically could be a workaround. This would involve some development work and could potentially be integrated into your embedded app. Domo…

Sorry, that's what I meant by "simplified". I didn't have the time to fully think through the whole solution.

Add a calculated field that determines whether a customer should be included based on their invoices. This field will check if any invoice for a customer falls within the selected aging range. Simplified…. Customer In Range: CASE WHEN `Aging Range` = '151-180' THEN 1 ELSE 0 END Aggregate the customer inclusions. To ensure…

Talking to SFTP sites is quite different than acting as an SFTP host. Domo isn't designed to replace an SFTP server itself. Domo excels at connecting to various data sources, including SFTP servers, to pull in and manage data. But it has no host area that I am aware of to act as a repository for files. If it did, the…

That works. Thank you @GrantSmith .

Okay…I get it. Something like this Domo blank brick….