GrantSmith Coach 
-
Re: Substitute for if / then statements
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 …1 -
Re: Domo Everywhere .env file
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 …1 -
Re: Click to select, not deselect
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 interaction1 -
Re: Error in workbench, Dataset is currently locked and cannot be executed right now
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 data1 -
Re: Period over Period Beast Mode
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(CURDA…1
