ArborRose Coach

Sure. You can do almost anything with a brick. Let's start with a basic brick to display a sample data file Here are the code parts: HTML: <main> <div id="result"></div> </main> JavaScript: var domo = window.domo; var datasets = window.datasets; // get the data domo.get(`data/v1/${datasets[0]}`).then(function(result){ var…

I don't see that behavior when I create a calendar selector. Throwing a sample dataset onto a calendar filter card, I see the following (below), which does not have lighter numbers for the current month. The best I could do was give you a reference to Domo's documentation. Does your instance have some kind of theme or…

Domo’s App theme can override certain card colors, including heatmaps in table cards. This happens because App themes attempt to enforce consistent branding, which includes a color palette. I don't think you can opt out except to use a brick or conditional formatting.

When you view a dataset, the id is shown in the URL. The wording dynamic sounds like you want to retrieve the id programmatically. Can you give a use case example for what you are trying to accomplish?

I would recommend you setup a workflow. Using AI you can probably come up with something more useful than alerts. If you haven't seen them, there are Domo recordings of recent community events where workflows are demonstrated with AI.

Here's the support page referring to colors on the calendar date selector: https://domo-support.domo.com/s/article/360044358473?language=en_US

You should be able to use a condition such as If % Planned < 70 OR % Planned > 95 And add the resource manager as a subscriber. If you need a guaranteed weekly digest (not just triggered when someone slips out of range), set up a weekly scheduled report of the same card.

Careful though—if you run it three times in a row while holding down Shift, you might accidentally summon a demon.

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.