ArborRose Coach

I don't use Snowflake. So I can't test that. But in every dataset I tried, I get a the data handling options @ColemenWilson shows. And the icon he shows looks like your redacted dataset type.

Could you share a link to the video you watched? That might help clarify the context. The tabs you see can vary depending on the dataset's origin. For example, was the dataset created through a connector (like Google Sheets), or is it the output of another dataflow? This can affect whether the Data Handling section appears…

I concur with @ColemenWilson. The smart text is part of the visual layer in Domo, which doesn't export. Only the table data exports. The obvious work-around would be to include a calculated field in your dataset and include it in the card's data table. DATE_FORMAT(CURRENT_DATE(), '%Y-%m-%d')

There are several ways you can add buttons. You said - to a card, rather than a dashboard. You can put a button on an app and set the card in the app. But not on the card directly - except for putting a link or something in the card such as a link in a table. I don't think I've seen a way to put a link in smart text like…

The obvious way is to use AI. Review some of the recent forum AI Academy recording for examples. You could try something like stripping punctuation, [clean notes]: LOWER(REGEXP_REPLACE(`notes`, '[^a-zA-Z0-9 ]', '')) and then use a beast mode to scan for keywords CASE WHEN `clean_notes` LIKE '%widget pro%' THEN 'Widget Pro'…

This page link is all I can find. https://www.domo.com/blog/product-innovations-announced-at-the-connections-tour

@AndreaHenderson Thank you!

@brycec At the time, I wasn't paying close attention to when. But yes, the group by tile. I don't think the formula tile has given me any problems. I mocked-up the screenshot because my flow deals with patient fields. But even very simple formulas cause the error. I've started getting so used to it that I'm ignoring the…

I don't typically work with FIXED, so we're traveling outside my knowledge zone. It might help to post it as a new question with anonymized sample data in csv. I think what you want is something like a fixed revenue across year and month like this Fixed Revenue by Year-Month: FIXED (BY `Year`, `Month`) SUM( CASE WHEN…

The only thing I see any issue with is forcing the number under the name while they are both next to the image. Otherwise, it should be doable. If you can't get it working in an html card, do it as a brick. A brick is just html with css and javascript. Use the html example I gave you and put it into a brick. Then replace…

It's probably treating NULL and '' (empty string) differently. Even if you use NULLIF(id, '') , the value might get a leading separator. Thus flagged_ids still triggers the separator with a valid ID. ['', 'BE0000344532'] becomes ", BE0000344532" You could try skipping the nulls with a filter instead of relying on…

I've seen that when text fields look like numbers. Try something like this CASE WHEN LEFT(`Number`, 1) = '''' THEN SUBSTRING(`Number`, 2) ELSE `Number` END Just in case the following is useful to you. I just did a formula yesterday to deal with phone numbers like that. I strip the parenthesis, dash, plus sign, and the 1…

I'd be having some un-friendly conversations with the vendor about consistency. You might be able to do some kind of staging dataset. Something you can push data to and then process with a Magic ETL or SQL to join new data with previous data on specific fields. And apply logic to identify changes, etc. I handle SFTP using…

If the cards on your dashboard use the same data source, then your card filters should affect other cards if interaction is enabled. Unfortunately, filters you apply inside a card don’t carry over to the rest of the dashboard. If you want filters to stay consistent across the whole page, it’s best to use filter controls at…

You could try using a formula tile with a formula like CASE WHEN LEFT(`phone`, 1) = '\'' THEN SUBSTRING(`phone`, 2) ELSE `phone` END Checks to see if first character is a single quote and removes it using substring.

One way would be to use an html table. with a formula like CASE WHEN `MTD` < (`MTD Budget` * 0.10) THEN CONCAT('<span style="color:red;">', `MTD`, '</span>') ELSE CONCAT('<span style="color:green;">', `MTD`, '</span>') END

You can find special characters by pulling up character map. Select the character then copy and paste. Or lookup "unicode" to pull up other lists or instructions for typing special characters.

The fixed function in Beast Mode lets you compute a value across a fixed level of aggregation, ignoring filters on specific rows. Using a beast mode to represent Total Revenue (fixed) FIXED (SUM(CASE WHEN `Type` = 'Revenue' THEN `Amount` ELSE 0 END)) and use that in another formula for % Share CASE WHEN `Type` = 'Cost'…

An hour bucket is a way of grouping timestamps by the hour they fall into. So for example: Date_Entered_UTC Hour Bucket 2025-05-20 08:23:17 2025-05-20 08:00:00 2025-05-20 08:55:42 2025-05-20 08:00:00 2025-05-20 07:05:10 2025-05-20 07:00:00 It's saying "group everything that occurred between 8:00 and 8:59:59 under the…

Yeah, it sounds like a UI glitch. Perhaps you can try… Clear your browser cache, or try a different browser Check filters aka view all reports Try cloning a dashboard and setting up a new schedule from scratch. It successful, it may be report level or permissions issue. Check if Domo Governance to validate ownership,…

If we create an html page example we can test out html code <!DOCTYPE html> <html> <head> <style> body { font-family: Arial; background-color: white; } .header { font-size: 18pt; color: #CEA667; font-weight: bold; margin-bottom: 20px; } .rep { display: flex; align-items: center; margin: 10px 0; font-size: 12pt; } .rank {…

I think because of the nesting, you will need to look at a Magic ETL. Group by Metric1, Group by Metric2, Group by Metric3. Then use Rank and Window to find MAX(SUM(Metric1)) for each partition. And another Group By to sum the max values. SQL performance in Domo is horrendous. I am definitely not pointing you to that.

I think John is looking for actual musicians. People who are interested in playing in the band. Such as a drummer, keyboards, etc. I'll be looking forward to that online concert.

Create a beast mode formula (calculated field) using something like Hour Bucket as DATE_FORMAT(`Date_Entered_UTC`, '%Y-%m-%d %H:00:00') Then you want to create a card with a table that aggregates using COUNT. Drop Hour Bucket on the card and then TicketNbr on the card and set it to COUNT. COUNT(`TicketNbr`) This will count…

According to a January 2025 release, it's not a bug. Domo updated this setting to reduce the number of queries sent to external data warehouses, thereby helping to manage costs and improve performance. https://domo-support.domo.com/minasan/s/article/000005812?language=en_US#removal_auto_preview

I don't think it's related to SSO. So you went to Admin > Authentication > Access Tokens, created a token and used it in the statement as an 'x-domo-developer-token' and its now working?

Believer - Imagine Dragons. Lol…or did you mean what instrument? Ha ha ha.

Domo has different types of tokens and they are easy to confuse. Make sure you are using the correct type of token. It looks like you are trying to use a client secret directly in the header. You use a client ID and secret to generate a token from Domo's token endpoint and then use the token. # Define Domo API credentials…

I don't think you can apply a color rule to the default totals provided by the chart. Domo's color rules do not distinguish between details and totals. They color based on a condition or value. I think you have to create your own totals using beast mode, if you want to color them.

For mine, I had to host the image on my own server or use a trick to host it locally on Domo. There's a past thread here in the forum that shows that trick. Then use html as a DIV in the data that points to the image. Here's the beast mode formula: CONCAT('<div style="text-align:center;border:0px…