GrantSmith Coach 
-
DP22 - Using Beast Mode to Build Data Storytelling - Formatted Time Duration
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it…2 -
Re: Supress Zero Value rows in Pivot table
Since you want to ignore if an entire row is all 0s there isn't a simple built-in way to do this. You could write a beast mode which would aggregate all of the different values together for each row …1 -
Re: Initial Sandbox Setup
Hi @SarahR365 I'd recommend starting with as it outlines the Sandbox process and how you can promote connectors and share with users from your current dev instance to your new prod instance.1 -
Re: Running time intervals based off of an identifier
You can use a window function to do a lag LAG(`Action Time`) OVER (PARTITION BY `Ticket Number` ORDER BY `Action Time`) This can also be calculated using a Rank and Window tile in a Magic ETL Then ta…1 -
Re: Case when and formula with date
On your top condition you are returning `Total referrals `=0. If you want it to be 0 in this condition then just return 0 case when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= …2
