Data_Devon Contributor

Domo uses the MySQL dialect. Here's a few references: https://domo-support.domo.com/s/article/4405337525783?language=en_US

If you are on Windows OS, then: Windows Key + Period will open an emoji keyboard and then you can enter it inline as text. 👇 🔻 👆

Hello [Domo username]! I would play [your favorite instrument here], usually in the style of [your favorite artist here].

@ArborRose Thanks for the thoughts, but it appears my suspicions are correct and there is no easy/default functionality. Help me understand how the MagicETL calculation would work, and how it would accomplish my goal?

In that case, you'll need to use SmartText to reference the filter that you want to display, which might just be a simple Date type column. You can reference the Filter via the SmartText: I am not sure if this will quite get you where you need though so might need to call in the goats.

It's as simple as three columns - a "From", and "To" and an amount, like so:

Yes, it's possible, and quite fun! The hardest part I found is making sure each dollar has a source and destination. It sounds easy in theory, but can get muddled in practice. Each line needs a "From" and a "To", as well as the Value. This format then powers the Sankey visual. You can learn more at this KB article: Let us…

Hi JoeS, welcome to Domo! SmartText will be your best friend here. You can reference the dates that are filtered to then display in SmartText as a title for the Card. Depending on how your data is set up, you might need to do a BeastMode that will be referenced in the SmartText - but I can't make that conclusion without…

Wow!! Great work @brycec 🐐🐐🐐🐐🐐???????

Welp - I just had to remove some datasets and add them back. Not sure what happened exactly but glad that stripping down the inputs helped. 3

Still recovering from the effects of FOMO after missing Domopalooza… Next year!!

A gentleman and a scholar!! 🙇 I knew there'd be something simple. Thank you!

Hi PJG, Do you need the series data included? Does "Build" need to include 'Enhancements' and 'Projects'? Does "Run" need to include 'Support', 'Business Partnering', and 'Internal IT Time'? If not, then you can just use a Data Label Text of Percent of total like so:

Make sure you format the original calculation column as a percentage: click the column that has your intended calculation click format click display as Percentage All of those values resolve to a number less than 1. The table will default to show 0, unless you tell it to treat it as a percentage

Make sure you wrap it in backticks : ` aprobado ` / ` ingreso_mesa `

Hi @Juan_Coronel_221b. Welcome to the Domo Community. You'll love it here. You don't want to aggregate each column that goes into your beastmode when you are looking at line-by-line, as in your screenshot. Remove the SUM() that precedes each column, and that will give your 0 column values. Like so: aprobado / ingreso_mesa

Hi @Liliana_Al_Zakout! Welcome to the community. I trust you'll find tremendous value in the collective brilliance of this group. Here's how you can replicate that in Beastmodes: SUM(CASE WHEN Year = '2025' THEN Tons ELSE 0 END) / SUM(CASE WHEN Year = '2024' THEN Tons ELSE 0 END)) - 1

Thanks @DavidChurchman - I think I'll be able to combine your solution with DashboardDude's and get to exactly where I need to go. Thankful as always to have access to this community!

@DashboardDude - good stuff. That's what I was leaning towards through my continued research. Thanks Chef 🧑‍🍳

@DavidChurchman - Thanks for the thorough response. I'm afraid to share my data - you'll see what a mess it is. I've attached a sample. You'll see the following: Total - The total for the given procedure, by the given producer, on the given day, in the given location Month - calculated from the Date column Year -…

@brycec This has been resurrected and your help is needed again…. What's the purpose of the "yes" or "no" in the beastmode that references the Variable? I don't understand that section of the SQL snippet

Looks like it might be a network security issue? @ArborRose

@ArborRose - I was able to interact with the map and zoom in and out. The data/donuts would update in real time - I.e. I'd "drill in" to smaller sizes and the donuts would split up. So it seems as though everything is working except the canvas on which the data is being printed on. Inspecting the console - what should I…

Nothing. Still getting a blank canvas with the donuts overlaid.

@MarkSnodgrass your video was super helpful. Thanks to your help, I've got a follow up question :) The next question is: What distance would capture 90% of our clients? At X distance, Y% of our clients are accounted for? This is unrelated to the original question but wanted to open back up for any insight.

Nothing. Still getting a blank canvas with the donuts overlaid.

Thank you both! Mark - I love the video. That was super helpful to see you walk through it. I think the Distance() formula will be my best bet and can get me close. Thank you!

Her spirit lives forever

yes please! Send a code template!

BryceC - a free Answer for your stat line. Well done 😎😎😎