GrantSmith Coach 
-
Re: How do I change the data from being horizontal to vertical using a calculated field?
Hi @gabriellegeither It's a bit difficult to do this with a beast mode. I'd recommend utilizing an ETL and the Dynamic UnPivot tile to transpose your data. You can read on these here: https…3 -
Re: Using Beast Mode, how can I use the last value when a value equals zero?
The ETL would be more accurate and flexible in terms of how far back your last value occurred whereas the beast mode would only go back as far as you have defined.1 -
Re: Why do private embed links resolve to a "public.domo.com" address?
This is the embed server that handles embedding. It's a bit confusing with the domain being public but all the logic is handled there for private and public embedding. @ChrisBaker@chrishaleua ma…1 -
Re: Rolling Average for Each Category
I've done a writeup of lag functions and rolling averages before utilizing Beast Modes but the idea at the end is the same concept. You just need to calculate the Lag for 1 month ago and 2 month…1 -
Re: Rolling Average for Each Category
Hi @JR_S1L You'd need to keep your data as is to partition based on name to get the lag for the prior 3 months to get your rolling average. You can use a rank & window tile in Magic ETL to c…1
