GrantSmith Coach 
-
Re: Custom Domo App (Replicating the SugarForce example)
In your manifest file you should have an alias defined which is mapped to a specific dataset. You'll want to make sure you're using that alias instead of leads1 -
Re: Previous day status from snapshot data
You can use a Rank and Window tile with LAG to get the prior value based on your sorting.1 -
Re: Charting rolling n weeks based on week number selected in the dashboard filter
You'd need to either define all of the selectable weeks in a variable (which you must keep manually updated every week) or alternatively duplicate your data so that for every date you have that week …1 -
Re: Beast mode 'Case when' for if a date exists
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 values1 -
Re: Search results to show unique values
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…2
