Comments
-
Have you attempted updating the dataset previously and it failed? It may be stuck in an updating state. You may need to reach out to Domo support to have them fix it in the backend
-
COSLESCE is a function that can work in a beast mode but may not be listed in the function list using your original beast mode it’s look something like this COALESCE((CASE When 'testing'= '1' then 'Climate Controlled' When 'testing'= '2' then 'Refrigirated Wine Locker' When 'testing'= '3' then 'Drive Up' END), 'IS NULL')…
-
you can used a FIXED function to calculate percent of total. You can read about them here They give a good example you can follow
-
create a beast mode to do a case statement to return a value if it’s not null and then add that as a filter to your card COALESCE(your beast mode to select the column value, 'IS NULL') then just filter where the beast mode doesn’t return IS NULL
-
Month or Quarter over last year's quarter would be something like: WHEN `Period Over Period` = 'Quarter over Quarter LY' THEN (CASE WHEN QUARTER(Date) = QUARTER(CURDATE()) AND YEAR(Date) = YEAR(CURDATE())-1 THEN Amount END) Repeat the same for MONTH WHEN `Period Over Period` = 'Month over Month LY' THEN (CASE WHEN…
-
You can use this updated regex: REGEXP_REPLACE(`url`, '^.*\/([^\/]+\.pdf)(?:\?.*)?$', '$1')
-
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.
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In