ArborRose Coach

Sounds like Domo isn't supporting CAST / CONVERT in the dataset view. The dataset view isn't a true SQL view and Domo will still attempt to auto-infer data types. Can you force it by concatenating and empty string to it? CONCAT(column_name, '')

I think it's just a quirk that Domo needs to change/fix…design limitation. Try it as an icon and it should be visible. I believe it only does that on the navigation bar, not on pages. You can put buttons on the pages and they will stay visible. But on the nav bar, use an icon.

I believe Grant already answered this in a previous post. Check for upvotes on the idea exchange…if not found, post it. https://community-forums.domo.com/main/discussion/69383/controlling-page-level-access-in-app-studio

For percent of change in formula, you can create something like ( SUM(CASE WHEN YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) THEN Volume END) - SUM(CASE WHEN YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 13 MONTH)) AND MONTH(Date) =…

You can do date comparisons on a normal table chart….or a pivot chart but its not necessary. Look back at past forum questions and you see references with formulas such as CY, PY, P2Y (current year, previous year, previous 2 years). It works for comparing years, or months depending upon the formula. Example, if you want…

I believe this is what is seen Which is a hover over top of the title. Neither really make sense since its a title and you can plainly see it. Here's a snapshot just as the hover is coming up. I'm not sure when it happens. I've pulled up a dashboard with a card and it does this. I pulled up a dashboard with a blank brick…

You could use a beast mode to create a filter identifying rows where the order date is less than or equal to 30 days. Something like: CASE WHEN `Order Date` <= DATE_SUB(CURDATE(), INTERVAL 30 DAY) THEN 'Older than 30 Days' ELSE 'Last 30 Days' END

The React error #185 relates to "Maximum update depth exceeded". It means the component is updating itself over and over again in a loop. (React is an open-source JavaScript library developed for Facebook by Meta , and apparently used in Domo.) With Jason's comment that he too sees the behavior, I would assume there's a…

Sounds like a UI glitch. If you go to the card appearance when editing, and turn off "title", does it still appear? Only once or still twice? Do you have any hover text settings turned on? I can't find any documents commenting on this, I'd suggest you report it to Domo Support.

I agree with Grant. it's used for security to identify a specific user for permissions, as well as for audit tracking to identify which user accessed the dashboard.

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. https://domo-support.domo.com/s/article/000005171?language=en_US You could try some kind of work-around like a shared…

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…