GrantSmith Coach 
-
Re: Case Syntax
Instead of using ELSE WHEN just use WHEN for additional cases. Use just ELSE for your default clause.2 -
Re: Aggregation on Lag/Lead functions
This isn't possible as you can't aggregate a window function within a beast mode. What you'd need to do is perform your lag in an ETL and then calculate the average in your card. You m…2 -
Re: Is it possible to add context to legend entries
You can define a beast mode to conditionally set the context description and then drag that beast mode to the tooltip section o. The tip of analyzer. You may need to click the tooltip icon on the top…2 -
Re: Identifying "Last Week' when current week is 0 or 1
CASE WHEN `Date` + INTERVAL (7-DAYOFWEEK(`Date`)) DAY = CURRENT_DATE() - INTERVAL DAYOFWEEK(CURRENT_DATE()) DAY THEN 'Last Week' ELSE 'Not Last Week' END To add some additional co…3 -
Re: YTD Previus Year
I’d recommend reformatting your dataset to use a custom date offset dimension dataset. This will allow the interactions with the page date filters and simplify your data structure. I’ve done a write …2
