GrantSmith Coach

I've typically utilized a VPN connection to have a secure layer to process data through on the Workbench server.

currently there isn’t. I’d recommend adding an idea to the idea exchange

COALESCE(`(A2) Posted Bill Rate`, `(A1) Original Bill Rate`) + COALESCE(`(B2) Posted Bill Adj`, `(B1) Original Bill Adj`) COALESCE takes the first non-null value in the parameters passed. So this is saying Use A2 Posted Bill Rate if it's not null, otherwise use (A1) Original Bill Rate. Add that to B2 otherwise add it to B1.

You might be able to utilize the Java CLI with the delete-rows command to delete specific upsert keys in your dataset. If you need to define an upsert key on your dataset you can use the define-upsert command. As a precaution, I'd recommend backing up your dataset and trying out on a copy first before modifying the…

There isn’t a straightforward way to trigger the workbench job outside of the server because it’s not known outside of the server. If you wanted to get super technical you may be able to configure that server to be exposed to the outside world and then potentially utilize a workflow and custom app to call out to that…

CASE WHEN `Lead Stage` IN ('Move In', 'Moved In', 'Deposit') THEN 1 WHEN `MOVE_IN_DATE` IS NOT NULL THEN 1 ELSE 0 END You can use IN to check for multiple values

Those are unique to each user in your instance. To create a client ID and secret you need to login to https://developer.domo.com/manage-clients and create an API Client (Client ID and Secret) As for the Embed ID, that will depened if you're embedding a dashboard or a card. You can select under the Share menu (box with…

Have you tried recreating a new connection to these files? Territoriale Reauthenticated the domo account used to connect to one drive? If you’re still having issues you may need to contact Domo support

if you're getting a bit all data is shown error is because Domo limits the number of rows a card would import unless you tell it to increase the rows. This is to keep the card loading quick and efficiently. You can increase the size but putting in a number larger than the default of 25000 or 50000 depending on the card in…

not all of your data is being pulled into the card due to the size of your dataset so it’s not finding your exact match. In analyzer under the filter section you can put in a number larger than 50000 to pull in all of your data. Alternatively if your ids are not unique you could aggregate your data in the card to get a…

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.