ArborRose Coach

Yes, it sounds like another aggregation issue. If you did someting like Actual - Budget, it can calculate because its mixing aggregate fields within a non-aggregate expression. As opposed to SUM(Actual) - SUM(Budget), in the same aggregation used i the pivot. If both are already aggregates then {backtick}Actual{backtick} -…

When you pivot in Domo, the pivot expects the incoming dataset to already be defined with the fields you want to pivot on. If you include extra fields, the pivot will collapse those rows and cause things to dissapear. The "Group By" forces the dataset to the right fields before you pivot. You are aggregating (SUM, COUNT,…

Yes, it’s possible to combine multiple datasets into a single one. There may be more efficient or elegant approaches than the one I use (and I’m always open to learning from others), but my approach relies on Python and the Domo API. I’m happy to walk you through it if you haven’t worked with Python in Domo before. {Edit:…

As @ellibot stated, you don't need a date column to rank. You just need a column to order by. RANK() OVER (ORDER BY Value 1 DESC) If you want something like top five: CASE WHEN RANK() OVER (ORDER BY `Value 1` DESC) <= 5 THEN 'Top 5' ELSE 'Other' END In an ETL use a Rank & Window tile, partition by your group (such as…

I think you need to define only the grain you want after the pivot. If you want Dept + Month > Actual vs Budget to get Variance then you group by only dept and month. Everything else would be removed or aggregated before the pivot. You may need to group by before the pivot. All the fields except your Actual/Budget.…

Your users’ concerns about Domo being “too complicated” aren’t really a platform issue—it’s a consumption issue. It comes down to how people receive and interact with data. When you’re working with large datasets and shared aggregations, spreadsheets just aren’t the right long-term tool, even if they feel familiar. Domo’s…

I have a continual problem with Domo Workbench de-authorizing. Over the course of this full year it's happened to me more than once per month. So, I'm not pleased with Workbench. @GrantSmith - Have you used Workbench Enterprise yourself?

Domo Private Embed requires the viewer to authenticate into your Domo instance. Through the single SSO provider configured for your Domo tenant Through a native Domo username/password account There is no separate authentication flow for Private Embed, and Domo does not support multiple SSO providers per tenant. Because of…

Sounds like maybe something is corrupt. Have you tried removing and recreating the tabs or the layout? There may be something wrong (corrupt) in the code interpretation of the tabs when they were created such as duplicating pages that already have tabs, renaming or moving, undo/redo kinds of things.

401 is an authentication error. Which I interpret as - the workflow is executing, but when it tries to call the web crawler, the external service is rejecting the request because it’s not properly authenticated. Domo is not authorizing it.

@GrantStowell - I believe this post is in the wrong area. It's a feature request. Can you move it to the proper area such as product ideas.

Review this past post about workflow attachments - https://community-forums.domo.com/main/discussion/69562/adding-attachment-to-workflow-form-and-sending-the-email Also, I recommend you watch the Community forum work sessions. There were several workflow examples that showed how to send emails. Look for the sessions called…

I don't think you can read URL params from inside a brick in a public Domo app. In a public embed there's a secure iframe. Your app sit inside that iframe and I don't think the iframe can carry the parameters. There are options / workarounds though. Such as hosting your own "proxy" page, etc.

My general opinion - go with what you are comfortable with unless those credits stack up. Each person will have their own comfort zone - I like using Python.

You can also do upserts. I sometimes read the existing dataset into Python, modify the rows desired, then replace the entire dataset.

Domo’s DataSet API supports only two update methods: Replace (overwrite the entire dataset) and Append (add new rows). It does not support row‑level updates or deletes. However, you can still achieve update behavior using a common workaround. Your approach is right: Append your updated rows to a staging dataset via the…

If you are trying to run large-scale crawlers, you may hit rate limits or violate terms of server. You also need to make sure you have authentication and headers. You may need to consider using an API integration or code engine. Also make sure the role assigned has proper grants/permissions. As @erikjamesmason asked - can…

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.