GrantSmith Coach

currently this isn’t an option but you could either put this as an idea in the idea exchange or you could write your own custom app or Domo brick to do this interaction

You can use a beast mode to denote if the date is within the last 45 days and if so ignore it in the filter CASE WHEN `date` > CURDATE() - INTERVAL 45 DAY THEN 'EXCLUDE' ELSE 'INCLUDE' END then use that beast mode as a filler and only include the INCLUDE value

You can configure a MagicETL dataflow Output Dataset tile to use a Partition update method and specify the month field as your key. This will keep around any data that is no longer being pulled in from your source dataset. This is a beta feature so you may need to reach out to your account executive.

COUNT( CASE WHEN `Full-Time/Part-Time` = 'Full-Time' THEN 1 END) This case statement will return a value if your column is full time and then count that many values

if your data is exactly the same then you can swap it out but be mindful of any downstream triggers that may be reliant on your old data

you could also a summary number in your smart text to select the min and max date values Alternatively you can do this in a beast mode and add the beast mode as smart text

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…