ArborRose Coach

I don't think so. Beast mode can handle calculated fields but can't create a new total on a pivot table. They operate on row level, not summary. You can do the formula you show, but it won't add a separate total row in the pivot. Using Magic ETL you should be able to group by account, sum the MTD per account across regions…

Yes, I had that same problem and never got it to work properly. https://community-forums.domo.com/main/discussion/69027/workflow-help-identifying-a-form-submitter-and-sending-an-e-mail

Looks like your are aggregating inside the row logic. Domo re-evaluates the case when it calculates the Grand Total instead of summing the row results. I'd try creating two beast modes CASE WHEN `Revised Estimate (fixed by Estimate)` = 0 AND `Cost to Date (fixed by GL)` <> 0 THEN `Cost to Date (fixed by GL)` WHEN `Cost to…

I wish I had all the answers but I don't know the answer to your original question. Many things that could affect the issue. Also I don't do a lot of PDP. Possibly the user is a member of a group that has broader access. Possibly the conditions of your policy aren't filtering, ie the condition isn't truly restricting the…

PDP policies work the same in apps as they do in cards. See previous post: https://community-forums.domo.com/main/discussion/67220/how-do-i-change-pdp-policies-in-an-app-like-i-can-on-a-dashboard

See this previous post: https://community-forums.domo.com/main/discussion/67182/filter-persistence-between-pages-within-app-studio Per Domo knowledge article, you can create a filter view and set it as default for every app viewer. https://domo-support.domo.com/s/article/000005295

As far as I know, Domo does not support exploding the output - where each selection in your multi-select becomes its own row automatically. I believe there have been requests asking for this feature (turning multi-select selections into separate rows.…

As I mentioned, you could try to build out something that calls the Domo API. Maybe someone has code out there. In a brick or procode, I'd try something like: <button id="exportBtn">Download Dataset to Excel</button> With some kind of JavaScript or other code that looks something like this: import * as XLSX from "xlsx";…

Not really. Not in the way you are looking for. Domo’s native export options (Excel, CSV, PDF) are limited. You cannot control formatting, add dynamic headers/dates, or create multi-section, report-style layouts purely through Domo dashboards. Exported Excel files will be basic tables without merged cells, advanced…

Beast mode associates with the data used on the card, not the card or the page it rests on. It does not have access to the metadata about the page. And a card could be placed on more than one page. I have cards in Overview that are also on different dashboards. You might find workflow could help you. They give you more…

Congratulations on your certification! Safe space? The best? I am a potato. I put on a helmet and a seatbelt before entering the forum.

To duplicate that example, make sure you set your dataset0 to the sample products dataset. The code is referencing this as ${datasets[0]}.

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.