GrantSmith Coach 
-
Re: Undelete a user
If you add the account back with the same email address it should restore the user's account with the same ID and metadata.1 -
Re: Display state selected
You could use a beast mode to display the selected state if only one is selected: CASE WHEN COUNT(DISTINCT `State`) = 1 THEN MAX(`State`) ELSE '' END1 -
Re: Count transactions AND sum quantity on specific transactions by type
Are your transactions duplicated? If not you could do a conditional sum like: SUM(CASE WHEN `transaction_type` = 'Quantity' THEN `quantity` ELSE 1 END)3 -
Re: Last week data
When I'm doing period over period (WoW in your case) analysis I like to restrucutre my data so that each day has a relative entry in the dataset. This will allow you to go back in time and see what t…1 -
Re: Lost Business Beast Mode
You can filter based on the max closed date CASE WHEN MAX(`closed_date`) FIXED (BY client_id) < CURRENT_DATE() - INTERVAL 2 YEAR THEN 'Stale' ELSE 'Active' END this will find the max date for each…1
