ArborRose Coach

>>AnswerTitle<s</s><Footer

English Translation: Currently, multiple dashboards are being created across various departments in our company, and I am in the position of a Domo administrator. We have received requests from users asking for a feature that would allow multiple cards to be moved in bulk even from accounts other than the administrator…

Since the error only appears when the call is made from the DOMO app, it suggests something about that request (headers, format, or how it’s sent) is triggering the CORS error rather than the API blocking all browser requests.

—duplicate post removed—

I don't think it's a Domo restriction. It might be a CORS policy changes on the API side. That type of error occurs when an API does not want to receive browser requests. Such as those with authorization headers. You could try connecting to the API via Python or Postman to see if you get similar results. If Postman works,…

Okay great. Using this Python code in Domo's Jupyter Workspaces: import requests DOMO_INSTANCE = "your_instance" # example: company DOMO_TOKEN = "YOUR_DEVELOPER_TOKEN" url = f"https://{DOMO_INSTANCE}.domo.com/api/ai/v1/settings/services/sql/models" headers = { "X-DOMO-Developer-Token": DOMO_TOKEN } response =…

You are far beyond anything I can help with. I don't know if the model parameters are listed anywhere. But it seems to follow this pattern: domo.domo_ai.<model-name>:<provider> And so does your suggested list. Would it help if I lie and say, "Yeah sure, that's it."?

Ah. Okay. In your original screenshot you have model selected as static value. That would be: model = domo.dom_ai If you want a different model, I would uncheck that to set a non-static so the workflow can change it. model = domo.gpt4o

Something others likely don't know about me? - I often write upside-down and backwards.

When you go to the Admin screen from the top bar, you may need to scroll down to see the AI Service Layer section. Assuming you have proper permissions. There you will see various settings for AI systems, models, and providers.

The admin screen, More > Admin > Content >, has sections for cards, dashboards, etc. You could go there to cards and see who a card is shared with and remove access. Or simply remove access from the dataset, which should deny access to any cards using the dataset. Its easiest to create groups. Add people to a group and…

Your option 1 seems to describe: Dataset A → Group By Month Dataset B → Group By Month Dataset C (already monthly) Join A + B + C Which is what I would normally try. So the real question seems to be: How can I compare these datasets without a recurring ETL job? Could you do this with Dataset Views instead — aggregating A…

You might try to pre-aggregate or see if you can reduce the level of detail used in the denominator. Instead of day, try month for example.

It seems to be pushing your data to datetime rather than just date. You could try to force just a date with DATE() or DATE_FORMAT(Date, '%Y-%m-%d') maybe?

The filters are going to affect both numerator and denominator. Your denominator will need to ignore filters. You can do most of that with FIXED. But you may not get every scenario. SUM(`Sales`) / SUM(SUM(`Sales`)) FIXED (BY `Date`,`Retail_Category`) You said ALL SALES should only depend on: Date Range Retail Category If…

What chart type are you using?

I don't think you can remove the card link using that action from the Workflow. Instead of sending a card report to people, you could send an email with a CSV attachment generated inside the workflow. The attachment would be a snapshot in time and won't change later. No Domo branding or link back to Domo.

One of us! One of us! One of us!

Congratulations @JasonAltenburg. Ten years, holy cow! I'm such as newbie. I'm sure we all look forward to meeting @tjoyarz at Domopalooza. I wish him the best of luck in rounding up that 40% of us into some corner for greetings and a group photo.

If you're using a map type that is based on provinces, then you’ll need to assign ECOM to a valid province value — otherwise you’ll have to switch to a different map type. In the example I shared, the formula substitutes Yukon because it behaves just like a regular province in the map. It’s also a good choice since it has…

You could just pick an open province and create a beast mode to label that with your ECOM value. The others would plot where they belong CASE WHEN `Province Code` = 'ECOM' THEN 'YT' ELSE `Province Code` END Another way to do it - instead of provide code for the map, use latitude and longitude and include ECOM. Store_ID…

I'm having trouble understanding the question(s) asked. The YouTube documentation shows that the supported way to embed a video in a webpage/app using an iframe uses the URL format as https://www.youtube.com/embed/VIDEO_ID https://developers.google.com/youtube/player_parameters Some standard URLS, won't render in iframes…

Yes, your statement looks correct. "Controls cannot be removed from the card unless the variable logic is first removed from the Y-axis, series or sorting configuration.” Removing the variable from the card solves the visibility issue but also removes the dynamic behavior you wish to keep. If the goal is to keep the…

You should be able to do it with a Magic ETL. Use a Group By to get one row per month. Create a sequential month index using a Rank and Window tile. Partition if needed, ordering by Month ascending. As a row number, call it something like month_rank. Add another branch duplicating it as month_rank_2. Use a join tile and…

I concur with Grant. The token generated from settings > admin > access tokens is not the correct token type for the API. The datasets API needs an OAuth token generated via a client id and client secret key. Look under admin > authentication > API clients.

My understanding is that in MySQL dataflows, the Explain SQL is only available in some SQL types (like Redshift). As for performance issues….it's always useful to filter the data up front to put less stress on the SQL engine. But some things like joining on CAST values are a performance killers. ON CAST(c.id AS SIGNED) =…

If someone unsubscribes from a Domo email campaign using the unsubscribe link, how can they subscribe again and start receiving campaign emails? I don't use the campaigns app, but I can see the documentation page. You should be able to manually remove them from the unsubscribed list and then re-add them. But that doesn't…

If your client is external, a scalable approach is to use Domo Everywhere with row‑level security. Create a single dashboard, apply RLS so each client only sees their own data, and then embed it in your portal using SSO embedding. This would give you data isolation and avoid managing external Domo accounts.

I can think of a couple possible things that might cause an issue. Use named fields. Do not use an asterisk in a SELECT statement. Try UNION ALL rather than just UNION. Union removes duplicate rows, while UNION ALL includes all rows. Make sure your fields are consistent with aliases and types. Try your view out with just a…

It looks like you have at least one combination of AccountNum + Account + NewMonth + FY with multiple underlying records. Because Beast Mode is evaluated before aggregation, the pivot is encountering multiple results for the same cell. Try pre-aggregating the data in Magic ETL by grouping on AccountNum, Account, NewMonth,…