ArborRose Coach

It appears that the Domo behavior may have changed. I recommend asking Domo directly if there was a change. The documentation page says it will create a new dataset. It appears to be the intended behavior. You could try some kind of work-around like a shared data flow, API solution using the dataset id, etc.

Example of a screencapture brick - HTML <div id="brickContent"> <h2>Sales by Region</h2> <table> <tr><th>Region</th><th>Sales</th></tr> <tr><td>North</td><td>$120,000</td></tr> <tr><td>South</td><td>$98,000</td></tr> <tr><td>East</td><td>$143,000</td></tr> <tr><td>West</td><td>$110,000</td></tr> </table> </div> <button…

Similar questions like yours have been asked previously in the forum. The base problem appears to be capturing the state of filters. We can manually export via the UI, but there's no export to pdf action available. And Domo does not expose the API endpoint as far as I know. A possibility may exist if you try to create a…

"that massive CASE statement should probably really be a join to a lookup table. " I hope to you see at Domo Connections - Dallas. In my situation, I use a CASE statement to standardize insurance company names. Since users can enter these names in thousands of different ways, my CASE logic reclassifies them. With just a…

These are the only documentation links I can find. Feature Purpose & Behavior Data Freshness Checks whether underlying data in the warehouse has changed—triggers reload, alerts, or on-demand refresh. Data Caching (TTL) Temporarily stores previous query results to avoid unnecessary compute; automatically expires after time…

My guess is that you have only defined or used Employee ID and Location when defining people. In my Domo instance, I have other properties assigned to people such as title, department, etc. Those other properties are showing for me where they do not show for you. Dynamic group - Membership is determined by attributes in…

Try this CASE WHEN `Voucher Create Date` IS NOT NULL THEN DATE_SUB(DATE_ADD(DATE(`Voucher Create Date`), INTERVAL 2 DAY), INTERVAL 1 SECOND) END

The error appears to be in your CASE statement. This works…. DATE_SUB( DATE_ADD(Voucher Create Date, INTERVAL 2 DAY), INTERVAL 1 SECOND )

I believe what @pauljames is saying is that in beast mode each row only evaluates to one value. You can't return "Facebook" and "All" for the same row. Using the formula provided, if the user selects nothing, that effectively means "All".

Based on previous Community Forum posts, I would suggest a few possibilities: 1. Uninstalled the PowerPoint Add-in, then reinstall it to make sure you have the latest version and a clean setup. 2. Check the status in PowerPoint. Close and reopen PowerPoint. Then go to the options for add-ins and make sure the Domo add-in…

I'm not sure I'm following this correctly - your goal is to display a single number (county count) in that state that failed based on 50% failure rate? Sounds like you are dealing with a mismatch between the geography levels. County map expects county-level values. And the state map expects state-level values. So, I would…

Reference: https://community-forums.domo.com/main/discussion/68632/how-to-sync-up-appdb-and-underlying-datastore/p1 Do you have syncEnabled set to true in the manifest?

Domo does not support SSH keys generated via ssh-keygen, which can cause compatibility issues when using private key authentication. If you’ve generated the key in a format that Domo doesn’t accept, it may result in connectivity or listing failures. Identify which connector you are using. If you're currently using a…

There are many ways. Can you show us an anonymized csv of your data (fake)? I assume you mean that you want all the coloring and formatting replicated. If that's the case, I'd do it with a Domo Brick. Which is like creating an html page using Javascript, css, and html. Another way might be to use html table cards. Or use…

Oh, that's tragic. They must have removed that ability for security reasons. Ie, so we can't do what you are trying to do. That said, I’m sure I shouldn’t be giving suggestions on how to “trick” the system… but Talk Like a Pirate Day is coming up soon, so let’s be demandin’ more from this vessel. A pirate scally-wag like…

Domo assumes the default state is “show everything until filtered,” because the philosophy is dashboards should always display some data for readability. So you want is to flip that default, i.e. “show nothing until a slicer is picked”, which Domo doesn’t currently allow for the reasons your rep gave (design principle:…

According to Domo’s support documentation: You must have administrative access to the Windows operating system to install Workbench—and also to run it. Workarounds for running non-admin users post-install In earlier versions, you could install with an admin account, but then run Workbench as a non-admin user. (reference:…

There are a few limitations to running html inside of Domo. But I've found there's almost always a way to work around the differences. I'll try a mock-up when I have some extra time.

I don't believe you can download to a file with Workbench. If it can, it's not an option on my instance. Workbench pulls the data to a dataset. You could use a script or Python code to download the dataset to a local file on a shared drive. I've tried this in Jupyter Workspaces in Domo and it seems to limit me to…

I don't think you implemented it the way I intended. I should have added - Then, on the table card itself, add this field as a filter and set it to only include 1. You could do something like the following, but you will probably get a bunch of blank lines where they are null. Thus, I still believe my first suggestion is…

To flag invoices that contain a string in the item number CASE WHEN `Item Number` LIKE '%X%' THEN 1 ELSE 0 END Use that with logic for filtering 2 years.

Try using display: inline-block. You also shouldn't need that <p> CONCAT( '<div style="display:inline-block; vertical-align:top; text-align:left;">', '<div style="color: blue; font-weight: bold">NEXT APPOINTMENT: </div>', '<div style="color: black">', (CASE WHEN `Next Appointment Date` IS NULL THEN '<div style="color: red;…

You could put something in beast mode to filter the view. On the table card, add a filter like this and set it to 1. The card will only show rows if the campaign has an applied filter. Otherwise, it will be blank. CASE WHEN LENGTH(`Campaign Name`) > 0 THEN 1 ELSE 0 END

Sorry but it's a bad security practice for us to open unknown Word, and Excel files. Hopefully this may help a bit. References: https://community.ibi.com/forums/topic/11837-hello-i-am-building-a-report-that-uses-row-totals-to-calcul In the example given in the referenced link, the [on table recompute] ensures the [rate] is…

At the time, I was having a brain lapse trying to append a Jupyter dataset. There's a write command (domo.write_dataframe) but not an append command (unless I use the Domo API). But I can append if I retrieve the previous data into an existing data frame, combine it with a data frame and write the whole thing back as a…

You could build an app using JavaScript and the Domo SDK to read page or card filters with the filtersChanged event. Format the filters as SQL or JSON. Then call Snowflake. You can find code examples of filtersChanged on the web and in Domo Community Forum posts. Another way may be to use a workflow to take the inputs and…

The security resides with the workspace administrator. Google workspace blocks apps that attempt to access sensitive account data if they haven't been approved or trusted via the admin console. It's to ensure only vetted apps have access to sensitive data. Your admin needs to perform some steps to trust Domo as an OAuth…

Domo is treating it as a measure instead of a dimension because it is stored as a float. That's why your quick filter is showing standard deviation (measure aggregation). Use Magic ETL to add a step to convert your Order ID from a float to a string or text. Something like CONCAT(ROUND(OrderID, 0), '') If you need to keep…

Unfortunately, embedded Domo cards can be tricky when you want to copy just part of a long text block. If the card type doesn’t allow text selection, you might trying changing to an HTML Table card, which lets people copy only the parts they need. If clicking the card keeps opening a drill-down instead of letting you…

Oh oh oh…Mr. Kotter! I’m liking this idea for a Domo Community Forum “AI Challenge.” Let’s task the community with designing a smart and practical AI solution for problem-solving. Specifically, can you create an AI tool that detects anomalies in column headers and automatically resets them to the correct standard headers?