ArborRose Coach

You state that you removed "some" null dates. Preview may work because it is not hitting the full dataset that hits the issue. Such as data consistency, nulls, or formatting. It's just working with a subset. Make sure your data column is properly formatted as a date (not string) and contains NO nulls when passed to the AI…

One of my favorite quotes was highlighted by X-Files' Lord Manhammer. When coworkers need help but don't want to admit they need help. Say it! https://www.youtube.com/watch?v=NOb7JXV1T1Q

It looks like it has something to do with the way it was stored and ported over. Can you delete and recreate the aiMetadata variable in the new instance to see if it will have the child properties for dataDictionary, etc as in the first instance?

@JasonAltenburg - Getting AI to do something specific in graphics can be very frustrating. Getting nunchuku chains joined or even getting a sword handle to align with the scabbord can be frustrating. To fix these issues, I draw over the top or remove elements and replace them with my own drawn graphics. Since I do a lot of…

🤚 That popup always appears. Always. Is this is new change that will make it ignore? Because I can't get it to go away. I don't understand why we should need to see it at all….even once.

I develop back-end secured applications using Visual Studio, hosted on HTTPS-secured websites with authenticated logins. I then integrate the resulting data into Domo like any other data source. I avoid public embedding of forms and recommend using Private Embed or SSO Embed via Domo Everywhere to control access. I also…

Another try with aggregation (oops). % change: (SUM(`Actuals`) - SUM(`Budget`)) / SUM(`Budget`) % change value: CASE WHEN MAX(`Level 1 Description`) = 'INCOME TOTAL' AND SUM(`Actuals`) < SUM(`Budget`) THEN CONCAT('<span style="color:red;">', ROUND((SUM(`Actuals`) - SUM(`Budget`)) / SUM(`Budget`) * 100, 2), '%</span>') WHEN…

How about creating separate color logic in a column with the logic based on the % change using HTML color formatting? Sample data: Level 1 Description,Actuals,Budget INCOME TOTAL,90000,100000 INCOME TOTAL,110000,100000 Expenses,45000,50000 Expenses,52000,50000 COGS,30000,35000 COGS,37000,35000 INCOME TOTAL,100000,100000…

I prefer using Domo Workbench. Find it under Admin > More > Tool Downloads.

Sorry…I'm in on a conference call…lol CASE WHEN `NextCycleCount` >= CURRENT_DATE() AND `NextCycleCount` <= DATE_ADD(CURRENT_DATE(), INTERVAL 30 DAY) THEN 'Show' ELSE 'Hide' END ItemID,ItemName,NextCycleCount 1001,Widget A,2025-07-10 1002,Widget B,2025-07-15 1003,Widget C,2025-08-01 1004,Widget D,2025-07-08 1005,Widget…

CASE WHEN `Next Cycle Count` BETWEEN CURRENT_DATE() AND DATE_ADD(CURRENT_DATE(), INTERVAL 30 DAY) THEN 'Upcoming in Next 30 Days' ELSE 'Outside 30 Days' END This would give you a field you can use to list or filter. CASE WHEN `Next Cycle Count` BETWEEN CURRENT_DATE() AND DATE_ADD(CURRENT_DATE(), INTERVAL 30 DAY) THEN 1…

Review a post from last week: https://community-forums.domo.com/main/discussion/69820/showing-top-n-and-others-in-table-chart#latest

@BlakeP_0 - CASE WHEN 'Save As' AND 'juice-box' AND 'nap' THEN 1 ELSE 0 END

@calvert_schaefer - I see what you are saying. There is no option for keeping the leading zeros when you use that connector. I think you need to submit to Domo Support. Is there a reason for using that connector rather than just upload a spreadsheet under the data center?

I’d like to see webinars that explore working with data collections as opposed to standard datasets. For example, writing to a data collection using Python in the ProCode editor and then interacting with that collection in a workflow. It would also be great to dive deeper into how manifests play a role in that process.…

Let's see if we can get conversation going and get you working. Domo workflows may be representing the duration in ISO 8601 format. Such as P3D (3 days), PT2H (2 hours. If that's the case, you could try calculating daysUntilEnd as the number of days between current datetime and product end date. If the number is 5, convert…

Sample data: Product,Sales Product A,1200 Product B,950 Product C,870 Product D,1500 Product E,400 Product F,200 Product G,1750 Product H,300 Product I,100 Product J,600 ETL: Group By: Rank: Gives: Then create beast mode as Product Group: CASE WHEN `Top N` <= 5 THEN `Product` ELSE 'Others' END

Create an ETL and use the Rank and Window tile to rank products by sales. Or beast mode with something like RANK() OVER (ORDER BY SUM(`Sales`) DESC) Once you have a ran defined you can create a beast mode CASE WHEN {rank} < = 5 THEN `Product` ELSE 'Others' END

@ColemenWilson I'm not smart enough for that fancy math. I have to use fingers and toes.

Using what I showed. If the week ends on Sunday, the formulas change to DATE_ADD(`StartDate`, CASE WHEN WEEKDAY(`StartDate`) = 1 THEN 0 ELSE 8 - WEEKDAY(`StartDate`) END) DATE_ADD(`ActualEndDate`, CASE WHEN WEEKDAY(`ActualEndDate`) = 1 THEN 0 ELSE 8 - WEEKDAY(`ActualEndDate`) END) I don't have raw detail records to match…

Why can't you do it on a card? CompanyName,PositionDateCreated,DateFilled,StartDate,EstimatedEndDate,ActualEndDate,LastDateWorked Company A,2014-02-25,2014-02-25,2014-03-07,2024-01-01,,2025-05-14 Company B,2014-05-21,2014-05-21,2014-05-19,2025-07-27,,2025-06-15 Company…

domo.onDataUpdate() triggers after the dataset updates. It's not intended to prevent the refresh. So you can react to data changes, but not intercept them. You may be able to do a work-around by writing to a temporary staging dataset. Then schedule an ETL to move the data.

Interesting….yes, it appears that Domo should make some additions to the support page. I would assume the queries have a single dataset limitation. Domo dataflows use MySQL syntax, so try that rather than MS SQL syntax. Use backtick as common practice for calling out datasets or fields. I recall that working for me. I've…

Congratulations @MarkSnodgrass! 🐐 I actually don't know how to type a goat, I had to steal one of @Data_Devon 's. ;)

@JasonAltenburg - even if @art_in_sky does not want to see the code, I do. It looks like a great example of using forms and workflows. Do you have a online demo of this? Oh btw, sorry to hear about your illness with the ooz. Best wishes on a swift recovery.

Did the other one have a placeholder in the manifest? Something like: "schema": { "type": "object", "properties": {} }

I've never connected the JSON connectors with a token, so this is a guess. But you may need to enter it as a header parameter. And it might be simpler to use the standard no code JSON connector.

The brick probably doesn't use the schema. When converted to an App, without a schema defined, it doesn't know the structure to save the changes. So it wants you declare the schema for the collection. There should be a manifest.json file you can add the schema property to. Something like: { "collections": { "myCollection":…

It sounds like you want to calculate on-time deliver percent on sales orders (document /order number), not lines. Your beast mode tags each line as on-time, late, or whatever - rather than each order. You probably may need something with a FIXED() CASE WHEN MAX(CASE WHEN `SO OTD Tag` = 'Late' THEN 1 ELSE 0 END) OVER…