ArborRose Coach

Congratulations @ellibot

You don’t need a separate repository for each dashboard, but using one repository for many dashboards can make promotions harder. Since everything is grouped together, Domo requires you to reselect all dashboards each time you promote anything new. If you want to avoid that extra work, it’s easier to give each dashboard…

Try this: SUM(CASE WHEN column_a = 'value_1' THEN 1 ELSE 0 END) or just COUNT(CASE WHEN column_a = 'value_1' THEN 1 END)

This may be something that they need to enable via the Governance Toolkit for your instance.

I agree with @trafalger. I think you may have a rights issues. You may have browse permission but not full SELECT privileges on those tables. Snowflake would have explicit grants on each database and table and Domo's connector would enforce when querying. Try running Show Grants on Table <schema>.<table> in Snowflake.…

Domo doesn't really have an image hosting solution as far as I know. Its designed more for structured data (tables, metrics, meta) and not binary or blobs. I would look at external systems for hosting the images (AWS S3, Azure, Google) and store the images in organized buckets. Such as /products. Generate signed URLS and…

I don't think Domo exposes any endpoints for "user viewed Card X on Page Y". But you could try to approximate it by using a timestamp based join. Activity log records things like card viewed, card loaded, page viewed. A single card can be on multiple pages so if you join on card id alone you would get inflated results.…

I can see a lot of eyes on this post but nobody seems to be responding. I didn't even know about Workbench Enterprise until seeing this. I have quite a few things I pull in via Domo Workbench and I'm happy to give it a try. Did you have concerns or reasons not to use it?

No, I don't think a publicly embedded app can trigger a workflow from a brick. When a brick runs inside a public embed, it would execute as anonymous…unauthenticated. And thus you wouldn't get acess for actions like updates and workflow triggers. That's the 404 Forbidden access error. When you run the brick inside Domo, it…

I haven't worked with this before but I believe you can do things like you need using the Governance Toolkit > PDP Automation. Where you configure something like: user_email | attribute_name | attribute_value -------------------|----------------|------------------ user1@company .com | DMA | FL user2@company .com | DMA |…

I don't think you can remove the Zoom In/Out buttons. That's a default behavior by Domo. You could try to resize or reposition the chart elements to avoid the overlap. Or possibly link to a dedicated page where card #2 is displayed without the zoom. Sounds like a good feature to request in the Ideas Exchange…disable the…

Terrific!

Yes, that's correct. There is not a selection for individual. But you can create a group with just your account.

On the page you referenced, there's an AI assistant to answer your question. Here is Marie's answer: To enable the new UI, your Domo admin should go to the Admin settings, look for the UI or Experience section, and check for options to enable the new interface for the whole instance or specific groups. If you don‘t see…

You cannot call public.domo.com/api/ using: OAuth Session tokens Your normal Domo developer client ID/secret Those endpoints only accept an Embed Token, because public.domo.com/api/ is the domain used for privately embedded content. I think youo need to generate a token using your embed secret then include it in the…

Nicely done @ellibot. 👏

Do you use Python? EMBED_URL = "https://your-embedded-domo-url" def check_domo_embed(): with sync_playwright() as p: browser = p.chromium.launch(headless=True) context = browser.new_context() errors = [] # Capture failed network requests def on_response(response): if response.status != 200: errors.append(f"{response.url}…

Raw Data Example - multiple rows per month and a few dimensions (columns). Month Region Store Salesperson Revenue Jan West Store A Sam 1,000 Jan West Store A Kim 1,200 Jan West Store B Pat 900 Feb West Store A Sam 1,400 Feb West Store A Kim 1,000 Feb West Store B Pat 1,100 Aggregation Example: Monthly Revenue by Store…

When you use GROUP BY, every field you include causes the data to break into smaller chunks. Group by Year → you get one row per year Add Month → now you get one row per year and month So the more fields you add, the more the data splits. Because of that, a SUM or AVG at the monthly level is not the same as a SUM or AVG at…

Are you in a Group By tile or a formula tile? That looks like a formula tile.

Sorry, that last statement didn't make much sense. For date range, you would use something like start date or completed date, and set a date range based on one or both fields.

I don't know Wrike, but there are reference pages out there to review: https://help.wrike.com/hc/en-us/articles/210323245-Subitems-in-Wrike lol…I couldn't get that to paste properly so I stuck it in a code block. It looks like the connector requires you to select a report type like Tasks, Comments, etc. And you configure…

You have a formula for MTD % of Sales, be sure you have the proper scope. Your field is account, not class. SUM(`MTD`) / SUM(CASE WHEN `Account` = 'Sales' THEN `MTD` ELSE 0 END) FIXED () Create a Pie Chart Using Beast Mode Instead of using MTD as the slice value, use your Beast Mode: Chart Type: Pie or Donut Slice Name:…

Domo handles RANK() after aggregation. This can cause issues with things like pivot tables. Create a table that shows: Top N (e.g., Top 10) customer clusters by current year sales Others (everything outside Top N) Grand Total Start with your dataset with customer_cluster, calendar year, sum net sales. Then use a Group By…

As @ColemenWilson mentions, it appears fixed. I do not get the error.

Not really….except that you might have a NULL or zero denominator. What I do is stick a DEBUG output tile into the flow. After your GroupBy tile, branch off to the side an output tile and give it a name like DEBUG1. Run the process and check the data in the DEBUG1 output dataset. Review your values for Total Expenses and…

We can't see the end of the formula. SUM(CASE WHEN condition THEN value ELSE value END) So it would be SUM(CASE WHEN `Account` IN ('EE Salaries and Benefits', 'OD Salaries and Benefits', 'Supplies') THEN `Amount` ELSE 0 END) Without the THEN value in there, there is nothing for the SUM() to act on. Edit…and whatever that…

Aggregations (Group By) are essential. You are grouping "like" things to sum them up, count them, average, etc. Consider a sample: Salesperson Region Amount Alice East 100 Bob West 200 Alice East 150 Bob West 300 Now you want to know how much each salesperson sold in total. Aggregation means doing math across rows — like…

SUM() is an aggregation function and the Magic ETL formula tiles don't have the ability to compute it across rows unless they are grouped. Group your data Use a Group By tile to aggregate: Net Revenue → SUM(Value) where Account is in Gross Revenue, Other RevenueTotal Expenses → SUM(Value) where Account is in your expense…

Here are the Domo Support Reference : https://domo-support.domo.com/s/article/360042934574?language=en_US …and one of the Community Forum Posts for references: https://community-forums.domo.com/main/discussion/57717/documentation-on-activity-log-event-action-definitions VIEWED Definition: A user opened or clicked into a…