ArborRose Coach

The REST API would be optimized for real-time, small queries. You request a dataset and SalesForce returns the results immediately. Probably has request limits and daily quotes. Use case would be for syncing a single object like pull all accounts or leads daily. For dashboards that don't require a bunch of historial data.…

My answer is still the same. You are trying to use a state map, but your logic happens at the county level. • Counties need to be flagged first (fail vs not fail). • Then you roll those up at the state to count failing counties. • Then you display that count on the state map. Step 1 : County level fail flag to get a…

If your objective is to show the % of budget, what about using your ratio of (Budget / YTD) * 100 as the gauge value and set the comparison value to 100? The arrow should still work and your main displayed number will be the ratio you want. I.e. "We're at 108% of Budget". Alternately, you could keep your YTD as the gauge…

I don't think your going to find a simple solution. I think you have to get creative vs using Domo's YOY. When I do year over year comparisons, I normally use formulas for creating dynamic values: CY, PY, and P2Y (Current Year, Previous Year, and Previous 2 Year). For P2Y Year to Date, I'll use something like this: sum(…

Look under vertical bar chart types.

Summary: Use single quotes (' ') for text values. Use backticks ( ) for field names. Examples: Comparing a field to a text value: CASE WHEN Status = 'Active' THEN 1 ELSE 0 END Using a field with spaces in its name: SUM(`Order Amount`) Mixing both together: CASE WHEN `Category` = 'Clothing' THEN `Sales` ELSE 0 END

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…