Data_Devon Contributor

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

Assuming you are looking for all possible chart types, I love referencing @DashboardDude 's recipe book: It helps me see and interact with all the possible chart types. I also really like this chart from MajorDomo training. It's presented as a flow chart so you can help narrow down what you are after:

Your best bet will be a transformation in Magic ETL or through a Beastmode, but it depends on your end goal. If using this while building a card in Analyzer, you can use Beastmode and this code to achieve it: DATE_FORMAT(BIRTH_DATE,'%m/%d/%Y') If you can access Magic ETL, then you'll just use that same formula above within…

When users attempt to access their App, they get this error I suspect its something to do with the Form that is in the App since they can access the app but the Form (which is the only thing in the App) doesn't appear. I have a ticket out to Domo Support, too.

Any updates? I'm experiencing the same issue.

Hello caiorogano! Why would the sales remain constant even if products are removed? Also - what is your relationship between the datasets assuming that Salesperson is your Join Key? Is there one row per Salesperson, and values/area of operation/products are pivoted out to new rows? I want to make sure I understand before I…