Best Of

Re: Extract multiple sets of numbers from a single string

If they're always in the same position with the same ' - ' separator you can use SPLIT_PART

SPLIT_PART(`string`, ' - ', 7)
SPLIT_PART(`string`, ' - ', 8)

GrantSmith

2

Re: Running Into Error with BeastMode and Table

I don't know why it isn't aggregating in the table view, but I do know that putting the logic in Magic ETL would solve the issue.

ColemenWilson

1

Re: Good Names for Domo Super User Group??

Some of my favorites from Gemini:

Vance's Vanguard
Thompson's Titans
The Visionaries
The Data Diopters
The Insight Iris
The Retinal Rockstars
The Cornea Commanders
The Focus Force
The Data Sight Squad
The Pixel Pupils
The Analytic Acuity
The Clear View Crew
Vance's Visionary Diopters

As someone who inherited a Domo environment from a predecessor, just make sure you include a clear description on the group and documentation. Fun names are fun, but don't let them get in the way of good process and understandability for those that weren't there when it was named.

brycec

2

Re: Is there a list of API or endpoints to use in code engine?

Have you checked out the developer documentation?

DOMO Developer | APIs

They have recently started documenting their "Product APIs", which are extensive.

brycec

1

Re: How to import date/time values in workbench exactly as 8/26/2024 9:00:49 AM, without any transform?

In your schema you can define it as a STRING instead of a DATETIME so it'll import the characters exactly as defined.

GrantSmith

2

Re: Duplicate column feature name change in Magic ETL

Any update on this item?

DataNupe

1

Re: "Send Now" Dashboard Feature - please add Card Descriptions

As an addition, descriptions also don't show up on PDF/PPT exports, so that's also not an option. Descriptions should 100% be included in every output and it's maddening that they're not.

DavidChurchman

3

Re: Do I have the right code in my Python Script?

If you want to just include rows where that column equals, it would be easier to just use a filter tile and do the filter there. Just drag in the filter tile and connect it to the select columns 2 tile and add formula rule and use the following formula EFFDT = 'A'