ArborRose Coach

@Manasi_Panov - *** Awesome! ***

Using the examples I show, I manually count: January 1, 2023 → June 1, 2023 Includes both start and end date Result: 152 days July 1, 2023 → August 1, 2023 Includes both start and end Result: 32 days January 1, 2024 → February 15, 2024 2024 is a leap year Result: 46 days For a total of 230 days. To solve this I created a…

Depending upon your criteria, it may not be as simple as aggregating by group. Consider sample data like this: Member_ID Start_Date End_Date 101 2023-01-01 2023-03-31 101 2023-03-15 2023-06-01 101 2023-07-01 2023-08-01 Some memberships may not overlap. And in other scenarios, you can't group and count each membership and…

@ColemenWilson - is your screenshot showing a Snowflake dataset? Based on the icon, it looks the same as the question. Which would mean, it is not Snowflake..but something else.

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?