Data_Devon Contributor

@Kyrsten - Thank you! I don't know how the colors got added… It seems like it was just a default coloring that Domo applied automatically. I thought perhaps it was the "Entry" or "Exit" indicator in the Chart Properties, but that's something else entirely. None of the other Chart Properties have it as an option either, so…

Oh boy. I've been struggling with this too for a while. There's a few really good write ups to get you started, so I won't claim to know the answer but rather point to those who do: https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest Your thought process…

He must be much nicer than his profile picture would suggest! /s

@ColemenWilson is 🐐🐐🐐 so either of these solutions should work for you John_LARM

In my experience, the CASE WHEN statement has been the single most useful argument I've used for BeastModes. To solve your question, I'd do something like this: COUNT(CASE WHEN `Widgets` = 'Purple' THEN 1 ELSE 0) — the CASE WHEN argument looks at your `Widgets` column and returns a 1 if it's purple. You then count all…

Amazing!! That's exactly what I'm doing and exactly the problem I ran into. Thank you @DavidChurchman and @GrantSmith for getting me where I needed to go. I appreciate this community a ton!

I like that @DavidChurchman - and that's closer to what I'm currently doing. I'm forcing a wide dataset by BeastMode-ing the "Last Year" records into their own columns. The only difference is that I also BeastMode the current year into wide format, thus rendering dates useless. I think you provided the best solution…

Awesome, thank you @GrantSmith . I think we are getting close. The flexibility of using the dynamic "CURDATE()" instead of hardcoding a date value is awesome. In order to use the native "Choose Date" & "Graph By" filter that is native to each dashboard, I need to include the Date as the X Axis: I think we're getting…

Thank you @GrantSmith ! I may have misunderstood your write up, but all the solutions you shared are for when you have one value but multiple periods assigned to the value. I have the opposite problem - 1 date with multiple values assigned (budget and actual) Did I misunderstand your write up?

Option 4 will be the only solution here, since filter cards work on the dataset that they are powered off of. Since the "Custom" dataset and the "Daily" dataset are different, then the two cards (the table card and the filter card) won't interact as expected. As such, the root issue in your challenge is creating a join…

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 -…