ArborRose Coach

Comments

  • 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…
    in sales leaderboard - showing profile picture on the chart Comment by ArborRose May 23
  • 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…
    in Exclude null values from Group Concat in Magic ETL Comment by ArborRose May 22
  • 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…
    in Uploading to External Connector Comment by ArborRose May 22
  • 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…
    in EXCEL SFTP Connector Keep All Columns (Append) Comment by ArborRose May 21
  • 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…
    in App Configuration - Filter Options Comment by ArborRose May 21
  • 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.
    in Uploading to External Connector Comment by ArborRose May 21
  • 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
    in Color rule a column based of another column? Color rule for text? Comment by ArborRose May 20
  • 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.
    in Is there a best practice for a visual indication that a card has a drill down configured? Comment by ArborRose May 20
  • 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'…
    in FIXED Function with filter on card Comment by ArborRose May 20
  • 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…
    in beast mode for total active tickets per hour Comment by ArborRose May 20
  • 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,…
    in Admin > Reports is Empty?? Comment by ArborRose May 19
  • 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 {…
    in sales leaderboard - showing profile picture on the chart Comment by ArborRose May 19
  • 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.
    in How can i achieve the below grouped calculation in a beast mode? Comment by ArborRose May 16
  • 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.
    in If we made a band called "AI Agents", what would you play? Comment by ArborRose May 16
  • 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…
    in beast mode for total active tickets per hour Comment by ArborRose May 16
  • 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
    in Is there a way to set Auto preview on for all Cloud Amplifier datasets? Comment by ArborRose May 16
  • 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?
    in API PUT Error: Full authentication is required to access this resource Comment by ArborRose May 16
  • Believer - Imagine Dragons. Lol…or did you mean what instrument? Ha ha ha.
    in If we made a band called "AI Agents", what would you play? Comment by ArborRose May 16
  • 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…
    in API PUT Error: Full authentication is required to access this resource Comment by ArborRose May 16
  • 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.
    in Color rules in Pivot table for "Total" and "Subtotal" value Comment by ArborRose May 16
  • 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…
    in sales leaderboard - showing profile picture on the chart Comment by ArborRose May 16
  • I don't think you can rename datasets in Domo Everywhere publishing. And I'm not familiar with any way to hide them. A good workaround might be to use a Magic ETL or data flow in the subscriber to create a renamed version of the dataset. You could apply PDP and keep a clean, user-friendly name without affecting your…
    in Change dataset name/description when publishing Comment by ArborRose May 15
  • If your execution log is no longer updating, there are a couple of possible reasons: 1. Log Retention or Display Limits Domo doesn't appear to have officially published a specific size or time-based limit on Watchdog execution logs, but people have commented that: Logs may stop displaying updates after a certain volume of…
    in Dataset Watchdog Logs Comment by ArborRose May 15
  • Tokens are domain specific. If your domain changed, you need to make sure you regenerate access and embed tokens for the new domain. And allowed domains are set. You say you created a new client and allowed domains are still set. Are you referring to the embed and settings for Domo Everywhere?
    in Embedded app - private using API Comment by ArborRose May 14
  • Those are a bunch of questions that should probably go to the AI Academy presenters or post in a specific thread. I'll say this - my mother said, "you can do anything". Mom wouldn't lie. There's always a way or a work-around. Forms can be done in workflow, pro-code, etc. And they can all interact. I came back from…
    in Seeking advice on my chart of MCQ responses Comment by ArborRose May 14
  • Private embed codes should be user-specific for authenticated embedding. When you use private embed, the code can be generated for specific users or sessions. So they may be different. If you use Domo Everywhere it should generate a single embed code that is universal. If you don't need the embed to be private, switch to…
    in Are Embed Codes Not Universal? Comment by ArborRose May 14
  • Boolean sum depends upon whether you mean Boolean Summation as a logical "or". Using a formula like the following would give you the logic that if any one of the values is true the result is true. MAX(CASE WHEN `boolean_number` THEN 1 ELSE 0 END) Domo is not going to be able to do the summation on a string value. Try…
    in Sum True Comment by ArborRose May 14
  • I'm not sure Send Email can send an attachment that isn't hosted or via a URL. There may be limitations on sending binary or other form attachments using a workflow.
    in Adding Attachment to Workflow form and sending the email. Comment by ArborRose May 14
  • Interesting - a chart of survey responses that appear to be asking about AI. Um….how about using AI? If you haven't been viewing the sessions…on the black ribbon bar just below the main menu up top of this browser page, under the heading Community Forums, there is a link to past "event recordings". The Community Forum has…
    in Seeking advice on my chart of MCQ responses Comment by ArborRose May 13
  • Can't you just do the following? SUM(`your_boolean_column`)
    in Sum True Comment by ArborRose May 13
Avatar