GrantSmith Coach 
-
Re: Dataflow loads in preview, but not in actual dataset?
does the user you’re logged in as have permissions to those output datasets?1 -
Re: Filtering data automatically for a specific Monday in a Domo dataset
Here's some KB articles for you to reference:1 -
Re: Calculating only the distinct values for many duplicate sessions
You can use a fixed function for this: AVG(MAX(`duration`) FIXED (BY `session`)) This will take the maximum of the duration for each session identifier and then average each of those values out. As t…3 -
Re: Filtering data automatically for a specific Monday in a Domo dataset
You can utilize the DataSet Copy connector to run every Monday to take make a copy of your original dataset and set the update method to append. It will have the BATCH_LAST_RUN field when the snapsho…1 -
Re: How can I count occurrences grouped by a given field?
Ok I think I understand. You want the count of the IDs on each line of the ID. For that you can utilize a window function SUM(SUM(1)) OVER (PARTITION BY `ID#`)1
