GrantSmith Coach 
-
Re: How to migrate Workbench jobs to new server safely?
The last time I utilized the backup and import backup, it created new jobs with the same definition but with new datasets and job IDs, which caused a lot of issues and duplicated datasets. What I rec…1 -
Re: Need help writing a Beastmode
Try putting your aggregation outside of your case statement SUM(CASE WHEN `Age group` IN ('121-180 Days','181-270 Days','271-365 Days','366-730 Days','731 Days+') THEN `CurrentBalance` END)2 -
Re: Charting rolling n weeks based on week number selected in the dashboard filter
Here's an example where you can use the Calendar reference dataset from the Domo Dimensions connector: This example is getting 12 digits but you can change it to 8 if you want 8. After the join I fee…1 -
Re: How to Use Partitioning to Retain Data in a Monthly Rolling Window Dataset
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 fr…1 -
Re: Can Domo Workbench Support TCP/IP Over SSH for Secure Database Connections?
I've typically utilized a VPN connection to have a secure layer to process data through on the Workbench server.1
