ArborRose Coach

See this previous thread: https://community-forums.domo.com/main/discussion/comment/58093#Comment_58093

disregarded. 🤣

It's possible you hit a blind spot. The scheduling engine may accept and store the report but the UI might not be able to render it due to pagination or filtering issues. Submit a help ticket. You may be able to audit via admin tools. Check the scheduled reports section under Admin > Content > Scheduled Reports. It might…

Sounds like the pivot is complicating the process. Since every new brand means you have to edit the pivot values. What about a truly flat table? Instead of pivoting the brands to columns, use an html table and slicers. Retailer Brand Sales Attribute Target Nike 120000 Sportswear Walmart Dove 80000 Personal Care Costco…

I haven't reviewed the episode to follow along, but I see your approval form shows attachment : file. Is there an option to change attachment to image? If not, can it be used as a URL (UploadedImageURL) that hosts the image?

This is terrific Mark. In healthcare, we deal with standardizing things like medical codes, billing categories, and insurance company names. We see hundreds of ways people type out company names like Blue Cross and Blue Shield (e.g. BCBS, BC BS Medical, BCBS Dental). So I am interested in how others approach…

Person 1: What’s blue and goes ding-a-ling? Person 2: I don’t know. Person 1: A blue ding-a-ling! Person 1: What’s red and goes ding-a-ling? Person 2: A red ding-a-ling? Person 1: Nope… they only come in blue. In other words, I don't have a better answer then the one gave. Except with this happy face 😁. Maybe something…

I agree with @MarkSnodgrass. Some possible workarounds - Domo mobile app - apparently the mobile app does cache some recently viewed dashboards and cards. Use DomoStats - DataSets - includes metadata such as last updated timestamp for each dataset. DataFlows includes last run and status for ETL processes to give you…

I believe a repository is essentially a deployment package that tells which content to move between environments. If a single repository is shared for multiple dashboards, the entire repository is the deployable thing. Any time you add or remove, you'd have to reselect all the contents. If multiple dashboards depend on the…

Be careful about posting too much information to us. You should redact some of those values. I think the error is clear (at the bottom) - your account does not have the proper access to the workspace requested.

In Code Engine and Workflows, the account input type would be statically bound to the compiled execution. So the credentials would be to one account. I don't think you can dynamically switch at runtime. This isn’t a bug; it’s a security boundary in the Code Engine runtime. If there's a way, I'd love to see it.

Based on your comments, I would expect to leverage the Domo API. But I wouldn't expect the Python tile to handle anything like that. In Domo Magic ETL, the Python scripting tile must declare a static output schema. Domo enforces that so downstream tiles and datasets know the column structure ahead of time. Even if your…

It could be that the link briefly shows unfiltered data before applying filters, which would indicate a timing or permissions issue where Domo is fetching data before fully enforcing the permissions/filters for that user. If a user generating the link has broader dataset permission than other people, the initial data fetch…

Sorry, I included two 100's in there. Unencoded this would be CONCAT( '<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters=[', '{"column":"Col1","dataType":"string","operand":"IN","values":["', `Col1`, '"]},', '{"column":"Col2","dataType":"string","operand":"IN","values":["', `Col2`, '"]},',…

I answered this is a different window. I believe this is a duplicate of the same question. Here's an example answering how to pass the variables with the UserID as a value of 100. CONCAT('<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters='…

Somehow an issue on the forum lost the answer I posted. Re-summarizing in simple form. If you clear your browser cache and close all browser windows (so it closes any connected session), it will probably come back to you with fixed width or full screen as an option. Closing the browser will clear any open model dialog…

There's some trouble with duplications in the question posting. Re-answering this question. CONCAT('<a href="https://{yourinstance}.domo.com/page/0000000000?pfilters=' ,'%5B%7B%22column%22%3A%22group%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22',`group`,'%22%5D%7D%2C'…

The preview only samples data. Such as the first thousand rows. The full ETL may hit limits or collisions the preview does not catch. New rows of data might contain a field that was previously clean and now has NULL or unexpected values. Check critical fields like dates, Ids, and numbers. Check case sensitivity (where…

A "Not Runnable" error in Magic ETL usually indicates that the ETL cannot execute due to issues with its structure, dependencies, or configuration. Here are common causes: Disconnected or Missing Inputs If a dataset used as input for the ETL is deleted, renamed, or inaccessible, the ETL cannot run. Invalid or Broken…

Sounds like a good plan. Here's a thought - what about something like Domo Workspaces (Python) reading from your server to create a dataset? Assuming Exchange / Outlook…. MSAL Token (MS Authentication Library) from msal import ConfidentialClientApplication # Azure App credentials CLIENT_ID = "YOUR_CLIENT_ID" TENANT_ID =…

There is a post in ideas, requesting this. https://community-forums.domo.com/main/discussion/63994/dataset-via-email-connector-enhancement-include-sender-as-system-level-column You could possibly try setting up a proxy email box. Instead of sending the file directly to Domo's email address, set up a dedicated internal…

Congratulations @Data_Devon!

https://developers.google.com/youtube/v3/determine_quota_cost I've never pulled from YouTube, but here's my guess. On the page link, it mentioned a default of 10,000 units per day. And the reports endpoint costing 10 units per call. And one unit request for things like videos, playlists, etc. It seems to suggest that to…

Based on review of multiple support sites, the following apparently are NetSuite supported. Function NetSuite Support Notes _1 ----------- ------------------ ------- ADD_MONTHS(date, integer) Yes Returns the date plus the specified number of months. LAST_DAY(date) Yes Returns the date of the last day of the month for the…

Try WHERE TH.TRANDATE >= TO_DATE('2024-01-01', 'YYYY-MM-DD') I don't think Netsuite knows the SQL version YEAR().

It sounds like the reason Domo can’t authenticate your Trade Desk account is due to the multi-factor authentication (MFA) you mention, which prevents standard username/password logins for API connections. The workaround is to use API credentials instead. Can Trade Desk provide a Client ID and Secret specifically for API…

This sounds like a feature request rather than a question. Is the following (below) a correct summation? If so, maybe a forum admin could move it to Feature Request: Improve Filtering and Visibility in Execution List Summary Currently, the Execution List in Domo does not allow filtering or searching by recipient (e.g.,…

Domo ETLs executions are trigger based, not condition. It won't trigger on a condition specifically. You would have to simulate a dataset change or something to get the flow to run. Such as having an ETL filter rows where INVOICE LIKE '%,%'. If not rows match the dataset won't change. If rows do match, the flow would…

Create a table card. Drag your category colum to the rows. Drag the category column again to the values and set aggregation to count. Category Count Text1 2 Text2 3 Text # 3 1

Besides the question Colemen asked, I'd also ask about that inner join you show on the first row. You are selecting columns previously and then inner joining. If the column you want is not in the selected columns of the other side, how would the inner join find it on both sides?