DavidChurchman Coach

I can't recreate this. Changing the custom colors in App Studio does change the colors in a line chart. It looks to me like you have "Gradient" colors turned on for the card, so I would double check that, because any color settings manually entered in the card will overwrite any styles applied by the color palette in App…

Pivot cards don't play well with HTML formatting, but they can accept unicode or emojis, which can serve as indicators that you can manipulate in a case statement. For example, I made this pivot card: Using this case statement: case when Category = 1 and sum(Orders)/sum(sum(Orders) fixed(by week No.)) <0.05 then…

Colemen's answer will give an empty string instead of a NULL. If you want a NULL, then you could flip your CASE statement. Everything that is not "not 1" will be NULL: CASE WHEN Sort: Month Number != 1 THEN ( (SUM(All Cases) - LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number)) / LAG(SUM(All Cases), 1) OVER (ORDER…

Hey, we all need a juice-box and a nap sometimes

When you said "some event to occur" in the OP, I didn't know that's what you wanted. If you've shared that summary number to the dataset, for any cards that draw from the same dataset, you could use card-level filters that require that field to be above 10, and then you can specify a "No data" message.

I would look at your History to see if it's truly running when it says its running. Also, double check your Versions. What was the difference between the last version and this one? Do you have anything unconnected in the ETL, maybe hiding in some corner?

Maybe I'm mis-reading the question, but it sounds like you would just need an alert. If you want to know when a summary number falls below a threshold, you can set up an alert on that card specifying that threshold:

I would agree this would be better to with Magic ETL, and give you more options for bringing in additional "other loan" columns. That said, here's a possible BeastMode approach that addresses this specific scenario: RESULT: CONCAT NUMBER: case when Loan Number < Other Loan Numberthen concat(Loan Number,'-', Other Loan…

If I understand correctly, you want a count of Account IDs by close date, but if an account ID appears for more than one close date, you only want them counted for a single close date. If that's correct, I would split this into two parts, first figure out which repetition of the Account ID you want to include, and then…

The settings in dataflows allow you to run the dataflow when certain datasets are updated. But 'materially changes' means to me that you have some criteria for how the data needs to change in order to run the dataflow. For something like that, you could use the "workflow" feature to set up some custom rules about what…

You need to aggregate Quantity in your Progress v2 Beastmode. Try: 'QUARTER(date) like 1 then (1250- (sum(quantity)))

Does it work if you take out the "ELSE" clause? Right now, it points InvoiceNo no matter what (when it contains 'A', else when it does not contain 'A').

Do you have the same role with the same permissions? The permissions for apps are split in two places, under DomoApps and "Cards and Pages", so it's possible your admin missed the second part when assigning permissions to the role missing access to App Studio (speaking as an admin who did exactly that).

This isn't particularly scalable, but you could create duplicate variables and use "or" conditions in your case statement. On the dashboard, you could create a control for each copy of the variable. If you want them to be able to select 5 different deferral codes, create 5 copies of the variable. Example case statement:…

Since the formulas are SQL based, they aren't all documented specifically for Domo, or if they are, I haven't seen it, lol. I'll usually Google the name of the formula and Domo, for example: DATE_FORMAT Domo, and if there is something in the knowledge base, that will turn it up. Here's an article on DATE_FORMAT When that…

So it sounds like your data is currently like this: ID | Month | Sales | LBs | Cases A | Jan | $5 | 2 | 7 To be able to do what you're describing, I think you'd have to unpivot (use the dynamic unpivot in MagicETL) so the structure is even longer. Like this: ID | Metric | Month | Value A | Sales | Jan | $5 A | LBs | Jan |…

I would have a table of profit share per customer like Customer | Share Customer A | 50% Customer B | 100% Then I'd join that table to full profit data, so I have a 'Share' value for every row. A BeastMode could then calculate the "Profit after sharing". You can create filters on your dashboard using any column in your…

Are there any other sorts? Do you have anything in your date options in the top right?

Have you saved the card and viewed it on the page? I can't see any HTML styling in the analyzer, but I can when the card is displayed. I was able to get your beast mode to format a summary number:

So right now you have 4 groups in your series, let's say they're called: Line A Bar A Bar B Bar C Could create a single BeastMode that appends something like "projected" to the end of each of those. CASE WHEN LAST_DAY(date) >= LAST_DAY(CURRENT_DATE()) THEN CONCAT(seriesname, " projected") else seriesname END That should…

A BeastMode can "validate" but still be invalid for some reason the "validator" can't catch. That tends to be the reason I get that error.

Will we be able to embed an app studio app using Domo Everywhere the way we can share dashboards, or do apps only exist within Domo?

This isn't quite what you're asking for, but from a BeastMode, I think I'd do a date diff with the maximum completed date for a store and today's date. Then you could create viz for stores with the longest amount of time since their last audit, and filter for stores that have not had audit in at least __ days. To do what…

I reached out to Domo support on this over a year ago, and they said that card descriptions were not supported in pdf/ppt exports. I submitted this product idea, if you want to up-vote it and/or comment on it.

I follow. Currently, your columns are something like: Order Number Schedule Date 1 Completed Date 1 Status 1 Schedule Date 2 Completed Date 2 Status 2 …. Schedule Date 10 Completed Date 10 Status 10 You want to unpivot so your columns are: Order Number Stage Number Schedule Date Completed Date Status If un-pivot is giving…

Yes, I would create a column with this case statement in a formula tile: CASE WHEN `Product`='c' then `Column with values you want to add` else 0 END Then do a group-by tile that sums that column by ID. Looking at @ArborRose's solution, it looks like you could do it all within the group-by tile using a partition formula…

Yes, you could use a Group-by tile, select ID as your group. If your data is structured like this, where ID 1 is all 1s for the Marker column, then you could use "Average" as your aggregating function. On the other hand, the way I'd approach this is I would create the marker column with a simple CASE WHEN Product = 'c'…

It's definitely an issue that gets a question in the community forum every couple weeks. +1 for this request for sure. Here's the first couple I found with a search:

Yes, if you have 0 available days in the denominator, you will get NA values for that, which is why it would not show that category on the graph. You're adding percents by category, so even if your overall utilization rate was 86%, if your utilization of green was 97% and your utilization of orange was 93%, then the…

I'm noticing your formula should be !='' or >=1 to get the non-empty results. It's also possible in addition to an empty string, you could have a string comprised of white spaces, which would have a length greater than 0 and not be equal to '' '' vs. ' ' To account for that, I think wrapping your code in TRIM() should…