ArborRose Coach

It looks like you are using single quotes. When talking about a field we use back ticks in Domo. It's the odd quote mark in the upper left of your keyboard (normally). When you use single quotes, you are indicating a text string. Change those in your formulas and see if that fixes your ETL issues.

Google AI says its related to Domo - Business In A Box. And apparently that's a feature that may require your CSM to enable or disable. Look under Admin > Features. See if you see something there that relates and can be turned off.

How about this? There's probably an easier way but I think this gets you a solution. Create an ETL and aggregate all the revenue and expenses by account type. Then aggregate a separate path for revenue and expenses as totals so you can subtract. Then append that as a new row but label it as if it's Account Type.

Oh wait…you want another row. Where Net Income is a row under the others? I would do that with an ETL and appending it to the bottom.

Oh…looking at the screenshot, it looks like it's missing space at ELSE 0.

It may be that I don't full understand what you need. My raw data sample to simulate your data: Period Account Type FinData 2024-01 Revenue 520000.0 2024-01 Expense_Cost of Goods Sold 145600.0 2024-01 Expense_Payroll 85000.0 2024-01 Expense_Other 40000.0 2024-02 Revenue 535000.0 2024-02 Expense_Cost of Goods Sold 149800.0…

Sounds like the AI needs some attention. I'd be a little more worried if it starts asking what you're wearing.

I don’t see anything in your steps that would make a link clickable. Which is obviously the question…how do we? Let’s take a quick step back and review how links work in HTML. A basic anchor tag looks like this: <a href="https://community-forums.domo.com/">Visit Domo Community Forums</a> HTML is a markup language that uses…

Sure, there are several options. Net Income would be the Revenue - {All Expenses}. If you want Net Income to always appear along side other account types, I'd go with a Magic ETL (dataflow). Otherwise if you only need it calculated on a chart table, try it with beast mode. Possibly something like: SUM(CASE WHEN `Account…

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.