Data_Devon Contributor

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

To anyone else that has this issue: I had the Google Sheet "saved" as an XLSX file, and this must've been causing the connectivity/compatibility issue. I saved it as a Google Sheet, and then it was able to connect successfully. No ClientToe needed 🚫😤

Domo support is asking for a "ClientToe" (??) - see below. Seems like a lot of steps for a simple problem but it's beyond my understanding so I don't know. I appreciate the screenshot of the connector you are using. However, we kindly request you to create a new connector from scratch. If you still encounter the same…

@DashboardDude 🐐🐐🐐🐐🐐

Yes, confirmed. I am on the Google Sheet, listed as an Editor

I'm sure his ETLs are HUGE

You are on the right track. This should do the trick: I'd recommend removing the hardcoded Year reference so that this can be used eternally ☀️ CASE WHEN `Submission Time` < DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) THEN 'FLAG' ELSE 'NONE' END Did that do the trick?

Even if that seems too manual to you, it's still an improvement over current state. There isn't an indicator or identifier of the month being closed. We are just dependent on another team saying "we are done!" at which point we can trust the data and publish it.

@ColemenWilson - I should've been more clear. I am currently the sole "producer"/developer in Domo, and the hope of this group is to help others gain confidence in Domo to assist in production, problem solving, and development. The purpose of this group, then, is to formalize a select few people that have demonstrated…

I tried making the form that was accessible from within the app - but that's what led to the "Error Loading Form" issue! I did just get confirmation from Domo support though that there was a bug in the Form so it is perhaps resolved.

Thank you @MarkSnodgrass for the input :) When you say "make that form in Domo", I assume you mean that I can deploy it from within a normal Dashboard interface?

Anyone? Please 🥹

Shoot - sorry that wasn't the case. Commenting again for reach and visibility. Standing by for the GOATs 🐐🐐🐐

Hello b_rad, In your random date validation, it looks like you typed in the dates. I'm assuming that in the working formula, you will have to reference the column that contains the dates you are trying to find the difference between. For example: DATEDIFF(month,`Start_Date`,`End_Date`) If the error you are getting is about…