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…1 -
Re: Initial Sandbox Setup
Hi @SarahR365 I'd recommend starting with https://domo-support.domo.com/s/article/4403367344023?language=en_US as it outlines the Sandbox process and how you can promote connectors and share wit…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 `Da…2
