GrantSmith Coach

If you won't always have a ? in the URL and want to get the end of it you can make the ? optional by adding ? after the group REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?)?.*$', '$1')

You can use REGEXP_REPLACE in a MagicETL formula tile: REGEXP_REPLACE(`url`, '^.*\/([^\/]+)(?=\?).*$', '$1')

Yes, you can still create users, they just won't get automatically created when the login through SSO the first time.

Under Admin > Authentication > SSO there's an advanced section where you can check "Only invited people can access Domo". This will prevent new users from being created and require you to manually add them to the instance.

You'll likely need to reach out to Domo support to see if they can turn off this menu option.

Current, no this isn't an option. I'd recommend adding this as an idea to the idea exchange.

Here's a REGEXP version: REGEXP_REPLACE(`field`, '^\d+-([^_]+).*$', '$1') But as @MarkSnodgrass mentioned if your format is consistent where values are after the first underscore with a following underscore then SPLIT_PART is an easier option. The REGEX version will handle cases where there's no following underscore

You won't be able to do an incremental total using the default tools. You can add an idea to the idea exchange to see if Domo can possible add this option in the future.

Currently this isn't an option but I'd recommend adding this to the ideas exchange for the PMs to look into potentially add.

You won't be able to use the file directly but you could set up a local SQL Server which reads that file and allows you to connect to it.

That shows you're saving the 'Demand Ad Index Final' beast mode. You need to open the other beast modes and save them to the dataset first.

Reach out to Domo Support. Domo's name is on the connector.

The issue is that your data is wide but the series will only work with your data in a more long format. If you pull in all of your columns it treats each of those columns as the value and not the hour series as you're wanting. You need to pivot your data such that you have Case Created Hour, Time Zone and Case Count in…

Are your 'PCT Marketing Demand Dollars' and 'PCT And Cost Dollars' saved to the dataset or are they only saved to the card? If so I'd recommend logging a ticket with Domo Support

You can utilize a Domo Brick and the Google JS APIs. There's an example of one in the App Store if you search for "Google Detailed Map Brick"

You need to remove your sort, as it's adding an extra dimension to your card. If you want to sort use your new beast mode date field.

Sorry, trying to write regexes on mobile is not a good idea :D REGEXP_REPLACE(`PRODUCT`, '^.*?([0-9]+[^ -]*\s?.*?)(?= - ).*$', '$1') Adding a ? after your \s will make the space optional so it then also works with your examples of Cocktail 16X14OZ - Packed or Cherry Tomato 12x1pt - Packed @ChrisGaffan Also I utilize a…

You'd use a formula tile to calculate a new field in Magic ETL. If your end delimiter is ' - ' then we can tweak it to be something like: REGEXP_REPLACE(`Production`, '^.*([0-9]+.*) - .*$', '$1') This simplified version looks for numbers followed by any number of characters until it finds a space-space delimiter. Will…

Because you're sorting on your event date it can't aggregate your mon_adjust calculated date. If you sort based on your mon_adjust column instead it may resolve your issue.

Will it always be one more more number followed by x and then one or more numbers followed by some extra characters or will that format possibly change? REGEXP_REPLACE(`Production`, '^.*([0-9]+x[0-9]+[^ ]*).*$', '$1') This regex follows that pattern where it's looking for one or more digits preceeding the x character and…

There isn't a specific dataset that would track this information. You'd have to get the card definition yourself to see if there is a field rename happening utilizing something like the java CLI with the backup-card command but that will only get your the JSON definition in a file and not as a dataset.

It's how the publication is interpreting your options. You could log a ticket with Domo Support to see if the development team can look into the issue or alternatively you could put your default option first in your list.

Your regex is is actually only checking if the first digit contains a number ^ - Start of string [0-9] - Any single digit between 0 and 9 You'll want to match the entire string: ^[0-9]+$ + - Match one or more of the prior expression (in this case digits between 0 and 9) $ - match the end of the string

I've had issues in the past with the PPT plugin not pulling smart text properly. I'd recommend logging a ticket with support to have the development team take a look at it for you.

You can use an Oracle Database Writeback connector to write data from Domo into a table in Oracle. https://domo-support.domo.com/s/article/360042932434?language=en_US

Workbench is used to ingest data into Domo. If you want to export data from Domo to Oracle I'd recommend looking into a writeback connector.

variables are unique per instance and not per dataset like beast modes are. You won’t be able to have one with the same name. You’d need to create a new one

dates and times are still represented as timestamps. If you really just want the text values you’ll need to convert it to a string but will lose the ability to do date operations

Do you have anything selected for your Region filter? If you don't then it uses the default text setting on your smart text which is blank by default. If you change it to All Regions it will then show that. As for the previous month it's not possible with that type of interaction however you may be able to select the…

I've utilized Python and the pydomo package to export data from Domo and then utilize the pandas package to export the different datasets to an excel file. It's a bit technical and involved but gave me the greatest flexibility.